USP_BBNCUSERMAP_EDIT

Edits a link between an application user and a website user.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATABASESINTEGRATED	bit	IN
@BBNCUSERNAME	nvarchar(50)	IN

Definition

Copy



create procedure dbo.[USP_BBNCUSERMAP_EDIT]
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
  @DATABASESINTEGRATED bit,
    @BBNCUSERNAME nvarchar(50)
)
as
    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

  if @DATABASESINTEGRATED = 1
    if not exists (select top 1 1 from dbo.[ClientUsers] where [UserName] = @BBNCUSERNAME)
      begin
        raiserror('ERR_BBNCUSERMAP_INVALIDBBNCUSER', 13, 1);
        return 1;
      end

    begin try
        update dbo.[BBNCUSERMAP] set
            [BBNCUSERNAME] = @BBNCUSERNAME,
            [CHANGEDBYID] = @CHANGEAGENTID
        where [ID] = @ID;
    end try

    begin catch
        exec dbo.[USP_RAISE_ERROR];
        return 1;
    end catch

  return 0;