USP_DATAFORMTEMPLATE_ADD_GIVINGSUMMARYUPDATEBATCHCOMMIT

The save procedure used by the add dataform template "Giving Summary Update Batch Row Commit 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.
@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_ADD_GIVINGSUMMARYUPDATEBATCHCOMMIT
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @VALIDATEONLY bit = 0,
    @LOOKUP_ID nvarchar(100) = null,
    @KEYNAME nvarchar(100) = null,
    @FIRSTNAME nvarchar(50) = null,
    @TOTALGIFTSGIVEN int = 0,
    @TOTALGIFTAMOUNT money = 0,
    @LARGESTGIFTAMOUNT money = 0,
    @LARGESTGIFTDATE datetime = null,
    @LARGESTGIFTTYPE nvarchar(100) = '',
    @LARGESTGIFTDESIGNATION nvarchar(100) = '',
    @FIRSTGIFTAMOUNT money = 0,
    @FIRSTGIFTDATE datetime = null,
    @FIRSTGIFTTYPE nvarchar(100) = '',
    @FIRSTGIFTDESIGNATION nvarchar(100) = '',
    @LATESTGIFTAMOUNT money = 0,
    @LATESTGIFTDATE datetime = null,
    @LATESTGIFTTYPE nvarchar(100) = '',
    @LATESTGIFTDESIGNATION nvarchar(100) = ''
)
as

set nocount on;

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

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

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try
    raiserror('There are no matched constituents for this ID.', 13, 1);
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0