USP_DATAFORMTEMPLATE_ADD_BBNCUSERMAP

The save procedure used by the add dataform template "Website User Map Entry Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@APPUSERID	uniqueidentifier	IN	Application user
@BBNCUSERNAME	nvarchar(50)	IN	Website user

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_BBNCUSERMAP]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @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();

  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;