USP_DATAFORM_EDITSAVE_CONSTITUENTSOLICITCODE

The save procedure used by the edit dataform template "Constituent Solicit Code Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SOLICITCODEID	uniqueidentifier	IN	Solicit code
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@COMMENTS	nvarchar(100)	IN	Comments

Definition

Copy



CREATE procedure dbo.USP_DATAFORM_EDITSAVE_CONSTITUENTSOLICITCODE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @SOLICITCODEID uniqueidentifier,
  @STARTDATE datetime,
  @ENDDATE datetime,
  @COMMENTS nvarchar(100)
)
as
  set nocount on;

  declare @CONSENTPREFERENCECODE tinyint;
  declare @SOURCEEVIDENCECODEID uniqueidentifier;
  declare @SOURCEFILE nvarchar(260);
  declare @PRIVACYPOLICY nvarchar(260);
  declare @SUPPORTINGINFORMATION nvarchar(max);
  declare @CONSENTSTATEMENT nvarchar(max);

  exec dbo.USP_DATAFORM_EDITLOAD_CONSTITUENTSOLICITCODE
    @ID = @ID,
    @CONSENTPREFERENCECODE = @CONSENTPREFERENCECODE output,
    @SOURCEEVIDENCECODEID = @SOURCEEVIDENCECODEID output,
    @SOURCEFILE = @SOURCEFILE output,
    @PRIVACYPOLICY = @PRIVACYPOLICY output,
    @SUPPORTINGINFORMATION = @SUPPORTINGINFORMATION output,
    @CONSENTSTATEMENT = @CONSENTSTATEMENT output;

  exec dbo.USP_DATAFORM_EDITSAVE_CONSTITUENTSOLICITCODE_2
    @ID,
    @CHANGEAGENTID,
    @SOLICITCODEID,
    @STARTDATE,
    @ENDDATE,
    @COMMENTS,
    @CONSENTPREFERENCECODE,
    @SOURCEEVIDENCECODEID,
    @SOURCEFILE,
    @PRIVACYPOLICY,
    @SUPPORTINGINFORMATION,
    @CONSENTSTATEMENT;

  return 0;