USP_DATAFORMTEMPLATE_EDIT_BATCHGIVINGSUMMARYUPDATEBATCHCOMMIT

The save procedure used by the edit dataform template "Giving Summary Update Batch Row Commit 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.
@VALIDATEONLY	bit	IN	Validate only
@LOOKUP_ID	nvarchar(100)	IN	Constituent/Lookup ID
@KEYNAME	nvarchar(100)	IN	Last/org/group/household name
@FIRSTNAME	nvarchar(50)	IN	First name
@TOTALGIFTSGIVEN	int	IN	Total number of gifts
@TOTALGIFTAMOUNT	money	IN	Total giving
@LARGESTGIFTAMOUNT	money	IN	Largest gift amount
@LARGESTGIFTDATE	datetime	IN	Largest gift date
@LARGESTGIFTTYPE	nvarchar(100)	IN	Largest gift type
@LARGESTGIFTDESIGNATION	nvarchar(100)	IN	Largest gift designation
@FIRSTGIFTAMOUNT	money	IN	First gift amount
@FIRSTGIFTDATE	datetime	IN	First gift date
@FIRSTGIFTTYPE	nvarchar(100)	IN	First gift type
@FIRSTGIFTDESIGNATION	nvarchar(100)	IN	First gift designation
@LATESTGIFTAMOUNT	money	IN	Latest gift amount
@LATESTGIFTDATE	datetime	IN	Latest gift date
@LATESTGIFTTYPE	nvarchar(100)	IN	Latest gift type
@LATESTGIFTDESIGNATION	nvarchar(100)	IN	Latest gift designation

Definition

Copy



    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHGIVINGSUMMARYUPDATEBATCHCOMMIT(
        @ID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier,
        @VALIDATEONLY bit,
        @LOOKUP_ID nvarchar(100),
        @KEYNAME nvarchar(100),
        @FIRSTNAME nvarchar(50),
        @TOTALGIFTSGIVEN int,
        @TOTALGIFTAMOUNT money,
        @LARGESTGIFTAMOUNT money,
        @LARGESTGIFTDATE datetime,
        @LARGESTGIFTTYPE nvarchar(100),
        @LARGESTGIFTDESIGNATION nvarchar(100),
        @FIRSTGIFTAMOUNT money,
        @FIRSTGIFTDATE datetime,
        @FIRSTGIFTTYPE nvarchar(100),
        @FIRSTGIFTDESIGNATION nvarchar(100),
        @LATESTGIFTAMOUNT money,
        @LATESTGIFTDATE datetime,
        @LATESTGIFTTYPE nvarchar(100),
        @LATESTGIFTDESIGNATION nvarchar(100)) as
    set nocount on;

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

        begin try
        exec dbo.USP_DATAFORMTEMPLATE_EDIT_GIVINGSUMMARYBATCHTEMPLATE @ID = @ID, @CHANGEAGENTID = @CHANGEAGENTID, @LOOKUP_ID = @LOOKUP_ID, @FIRSTGIFTAMOUNT = @FIRSTGIFTAMOUNT, @FIRSTGIFTDATE = @FIRSTGIFTDATE, @FIRSTGIFTDESIGNATION = @FIRSTGIFTDESIGNATION, @FIRSTGIFTTYPE = @FIRSTGIFTTYPE, @LARGESTGIFTAMOUNT = @LARGESTGIFTAMOUNT, @LARGESTGIFTDATE = @LARGESTGIFTDATE, @LARGESTGIFTDESIGNATION = @LARGESTGIFTDESIGNATION, @LARGESTGIFTTYPE = @LARGESTGIFTTYPE, @LATESTGIFTAMOUNT = @LATESTGIFTAMOUNT, @LATESTGIFTDATE = @LATESTGIFTDATE, @LATESTGIFTDESIGNATION = @LATESTGIFTDESIGNATION, @LATESTGIFTTYPE = @LATESTGIFTTYPE, @TOTALGIFTAMOUNT = @TOTALGIFTAMOUNT, @TOTALGIFTSGIVEN = @TOTALGIFTSGIVEN;

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

    return 0;