USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIP_PAYMENT

The save procedure used by the edit dataform template "Sponsorship Payment 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.
@STARTDATE	datetime	IN	Next transaction date
@ENDDATE	datetime	IN	Ending on
@AMOUNT	money	IN	Amount
@REFERENCE	nvarchar(20)	IN	Reference
@SPLITS	xml	IN	Designations
@FREQUENCYCODE	tinyint	IN	Frequency
@SENDREMINDER	bit	IN	Send reminders
@NEXTINSTALLMENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIP_PAYMENT (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @STARTDATE datetime,
    @ENDDATE datetime,
    @AMOUNT money,
    @REFERENCE nvarchar(20),
    @SPLITS xml,
    @FREQUENCYCODE tinyint,
    @SENDREMINDER bit,
    @NEXTINSTALLMENTID uniqueidentifier
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data


        -- TODO - we SHOULD be able to get rid of this reload if we add the missing

        -- RecurringGift.Edit.2 fields to the form metadata, per Ben Lambert's recent

        -- changes; however this is not working right now (getting a timeout error)

        declare @DATE datetime;
        declare @FINDERNUMBER bigint;
        declare @SOURCECODE nvarchar(50);
        declare @APPEALID uniqueidentifier;
        declare @GIVENANONYMOUSLY bit;
        declare @MAILINGID uniqueidentifier;
        declare @CHANNELCODEID uniqueidentifier;
        declare @DONOTACKNOWLEDGE bit;
        declare @CATEGORYCODEID uniqueidentifier;

        exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFT_2
            @ID = @ID,
            @DATE = @DATE output,
            @FINDERNUMBER = @FINDERNUMBER output,
            @SOURCECODE = @SOURCECODE output,
            @APPEALID = @APPEALID output,
            @GIVENANONYMOUSLY = @GIVENANONYMOUSLY output,
            @MAILINGID = @MAILINGID output,
            @CHANNELCODEID = @CHANNELCODEID output,
            @DONOTACKNOWLEDGE = @DONOTACKNOWLEDGE output,
            @REFERENCE = @REFERENCE output,
            @CATEGORYCODEID = @CATEGORYCODEID output

        exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFT_3
          @ID,
          @CHANGEAGENTID,
          @DATE,
          @AMOUNT,
          @SPLITS,
          @FREQUENCYCODE,
          @ENDDATE,
          @STARTDATE,
          @FINDERNUMBER,
          @SOURCECODE,
          @APPEALID,
          @GIVENANONYMOUSLY,
          @MAILINGID,
          @CHANNELCODEID,
          @DONOTACKNOWLEDGE,
          @REFERENCE,
          @CATEGORYCODEID,
          @SENDREMINDER,
          @NEXTINSTALLMENTID,
          null
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;