USP_DATAFORMTEMPLATE_EDIT_FINDERSETTINGS

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@USERNAME	nvarchar(100)	IN
@SECRETKEY	nvarchar(250)	IN
@ADDRESS	nvarchar(50)	IN
@CITY	nvarchar(30)	IN
@STATEID	uniqueidentifier	IN
@POSTCODE	nvarchar(10)	IN
@NAICS	nvarchar(6)	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_FINDERSETTINGS
(
  @CHANGEAGENTID uniqueidentifier = null,
  @USERNAME nvarchar(100),
  @SECRETKEY nvarchar(250),
  @ADDRESS nvarchar(50),
  @CITY nvarchar(30),
  @STATEID uniqueidentifier,
  @POSTCODE nvarchar(10),
  @NAICS nvarchar(6)
)
as
  set nocount on;

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

  declare @CURRENTDATE datetime = getdate();

  exec dbo.[USP_GET_KEY_ACCESS];

  begin try
    if (select count(1) from dbo.[SABOTEN]) = 1
    begin
      update
        dbo.[SABOTEN]
      set
        [USERNAME] = @USERNAME,
        [SECRETKEY] = EncryptByKey(key_GUID('sym_BBInfinity'), @SECRETKEY),
        [ADDRESS] = @ADDRESS,
        [CITY] = @CITY,
        [STATEID] = @STATEID,
        [POSTCODE] = @POSTCODE,
        [NAICS] = @NAICS,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = @CURRENTDATE;
    end
    else
    begin
      insert into
        dbo.[SABOTEN]
      (
        [USERNAME],
        [SECRETKEY],
        [ADDRESS],
        [CITY],
        [STATEID],
        [POSTCODE],
        [NAICS],
        [ADDEDBYID],
        [CHANGEDBYID],
        [DATEADDED],
        [DATECHANGED]
      )
      values
      (
        @USERNAME,
        EncryptByKey(key_GUID('sym_BBInfinity'), @SECRETKEY),
        @ADDRESS,
        @CITY,
        @STATEID,
        @POSTCODE,
        @NAICS,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE
      );
    end
  end try
  begin catch
    close symmetric key sym_BBInfinity;

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

  close symmetric key sym_BBInfinity;

  return 0;