USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTAPPEAL

The save procedure used by the edit dataform template "Constituent Appeal 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.
@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_EDIT_CONSTITUENTAPPEAL
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @APPEALID uniqueidentifier,
  @MKTSEGMENTATIONID uniqueidentifier,
  @SOURCECODE nvarchar(50),
  @DATESENT datetime,
  @COMMENTS nvarchar(255),
  @MKTPACKAGEID uniqueidentifier
)
as
  set nocount on;

  declare @CURRENTDATE datetime;
  set @CURRENTDATE = getdate();

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

    declare @ISREADONLY bit;
    select @ISREADONLY = case when MKTSEGMENTATIONSEGMENTID is null then 0 else 1 end
    from dbo.CONSTITUENTAPPEAL
    where ID = @ID;

    if @ISREADONLY = 0
      update 
        dbo.CONSTITUENTAPPEAL
      set
        APPEALID = @APPEALID,
        MKTSEGMENTATIONID = @MKTSEGMENTATIONID,
        SOURCECODE = @SOURCECODE,
        DATESENT = @DATESENT,
        COMMENTS = @COMMENTS,
        MKTPACKAGEID = @MKTPACKAGEID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
      where
        ID = @ID;
    else
      update
        dbo.CONSTITUENTAPPEAL
      set
        COMMENTS = @COMMENTS,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
      where
        ID = @ID;

  end try

  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;