USP_DATAFORMTEMPLATE_EDIT_ENQUEUESETTINGS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ENQUEUESETTINGS 
(
  @APPUSERID uniqueidentifier,
  @PASSWORD nvarchar(100),
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime = getdate();

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

  exec dbo.USP_GET_KEY_ACCESS;

  begin try
    update
      dbo.[ENQUEUESETTINGS]
    set
      [ID] = @APPUSERID,
      [PASSWORD] = EncryptByKey(key_GUID('sym_BBInfinity'), @PASSWORD),
      [DATECHANGED] = @CURRENTDATE,
      [CHANGEDBYID] = @CHANGEAGENTID;

    -- If this is the first time this form is saved, the row needs to be created

    if @@ROWCOUNT = 0
    begin                                
      insert into dbo.[ENQUEUESETTINGS]
      (
        [ID],
        [PASSWORD],
        [ADDEDBYID],
        [CHANGEDBYID],
        [DATEADDED],
        [DATECHANGED]
      )
      values
      (
        @APPUSERID,
        EncryptByKey(key_GUID('sym_BBInfinity'), @PASSWORD),
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE    
      );
    end

    close symmetric key sym_BBInfinity;
  end try
  begin catch
    close symmetric key sym_BBInfinity;
    return 1;
  end catch

  return 0;