USP_BBNCUSERMAP_ADD

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

Parameters

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

Definition

Copy



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

  declare @CURRENTDATE datetime;

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

  set @CURRENTDATE = getdate();

  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
      insert into dbo.[BBNCUSERMAP]
      (
      [ID],
      [BBNCUSERNAME],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    )
    values
      (
      @APPUSERID,
      @BBNCUSERNAME,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );

      set @ID = @APPUSERID;
  end try

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

  return 0;