USP_DATAFORMTEMPLATE_ADD_CONSTITUENTAPPEAL

The save procedure used by the add dataform template "Constituent Appeal Add 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.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@APPEALID	uniqueidentifier	IN	Appeal
@MKTSEGMENTATIONID	uniqueidentifier	IN	Mailing
@SOURCECODE	nvarchar(50)	IN	Source code
@DATESENT	datetime	IN	Date sent
@COMMENTS	nvarchar(255)	IN	Comments
@MKTPACKAGEID	uniqueidentifier	IN	Package

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CONSTITUENTAPPEAL
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null, 
  @CONSTITUENTID uniqueidentifier,
  @APPEALID uniqueidentifier,
  @MKTSEGMENTATIONID uniqueidentifier = null,
  @SOURCECODE nvarchar(50) = null,
  @DATESENT datetime = null,
  @COMMENTS nvarchar(255) = null,
  @MKTPACKAGEID uniqueidentifier = null
)
as
begin
  set nocount on;

  declare @CURRENTDATE datetime;

  if @ID is null
    set @ID = newid();

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

  set @CURRENTDATE = getdate();

  begin try

  insert into dbo.CONSTITUENTAPPEAL
    (ID,CONSTITUENTID,APPEALID,MKTSEGMENTATIONID,SOURCECODE,DATESENT,MKTPACKAGEID,COMMENTS,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
  VALUES
    (@ID,@CONSTITUENTID,@APPEALID,@MKTSEGMENTATIONID,@SOURCECODE,@DATESENT,@MKTPACKAGEID,@COMMENTS,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE);

  end try

  begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
  end catch

  return 0

end