USP_DATAFORM_EDITSAVE_CONSTITUENTSOLICITCODE_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SOLICITCODEID	uniqueidentifier	IN
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@COMMENTS	nvarchar(100)	IN
@CONSENTPREFERENCECODE	tinyint	IN
@SOURCEEVIDENCECODEID	uniqueidentifier	IN
@SOURCEFILE	nvarchar(260)	IN
@PRIVACYPOLICY	nvarchar(260)	IN
@SUPPORTINGINFORMATION	nvarchar(max)	IN
@CONSENTSTATEMENT	nvarchar(max)	IN

Definition

Copy



create procedure dbo.USP_DATAFORM_EDITSAVE_CONSTITUENTSOLICITCODE_2
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @SOLICITCODEID uniqueidentifier,
  @STARTDATE datetime,
  @ENDDATE datetime,
  @COMMENTS nvarchar(100),
  @CONSENTPREFERENCECODE tinyint,
  @SOURCEEVIDENCECODEID uniqueidentifier,
  @SOURCEFILE nvarchar(260),
  @PRIVACYPOLICY nvarchar(260),
  @SUPPORTINGINFORMATION nvarchar(max),
  @CONSENTSTATEMENT nvarchar(max)
)
as
set nocount on;

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

begin try
  declare @CONSTITUENTID uniqueidentifier = null;
  select @CONSTITUENTID = CONSTITUENTID
  from dbo.CONSTITUENTSOLICITCODE
  where ID = @ID;

  -- Adjust date ranges for GDPR solicit codes

  exec dbo.USP_CONSTITUENTSOLICITCODE_ADJUSTPREVIOUSDATERANGE @CONSTITUENTID, @SOLICITCODEID, @STARTDATE, @CHANGEAGENTID;

  update dbo.CONSTITUENTSOLICITCODE set
    SOLICITCODEID = @SOLICITCODEID,
    STARTDATE = @STARTDATE,
    ENDDATE = @ENDDATE,
    COMMENTS = @COMMENTS,
    CONSENTPREFERENCECODE = @CONSENTPREFERENCECODE,
    SOURCECODEID = @SOURCEEVIDENCECODEID,
    SOURCEFILEPATH = @SOURCEFILE,
    PRIVACYPOLICYFILEPATH = @PRIVACYPOLICY,
    SUPPORTINGINFORMATION = @SUPPORTINGINFORMATION,
    CONSENTSTATEMENT = @CONSENTSTATEMENT,
    CHANGEDBYID = @CHANGEAGENTID
  where ID = @ID;
end try
begin catch
  exec dbo.USP_RAISE_ERROR;
  return 1;
end catch

return 0;