USP_DATAFORMTEMPLATE_EDITSAVE_RE7INTEGRATIONGIVINGSUMMARY

The save procedure used by the edit dataform template "RE7 Integration Giving Summary 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.
@FIRSTGIFTAMOUNT	money	IN	Amount
@FIRSTGIFTDATE	datetime	IN	Date
@LATESTGIFTAMOUNT	money	IN	Amount
@LATESTGIFTDATE	datetime	IN	Date
@LARGESTGIFTAMOUNT	money	IN	Amount
@LARGESTGIFTDATE	datetime	IN	Date
@TOTALGIFTSGIVEN	int	IN	Total number of gifts
@TOTALGIFTAMOUNT	money	IN	Total giving
@FIRSTGIFTTYPE	nvarchar(100)	IN	Type
@FIRSTGIFTDESIGNATION	nvarchar(100)	IN	Designation
@LARGESTGIFTTYPE	nvarchar(100)	IN	Type
@LARGESTGIFTDESIGNATION	nvarchar(100)	IN	Designation
@LATESTGIFTTYPE	nvarchar(100)	IN	Type
@LATESTGIFTDESIGNATION	nvarchar(100)	IN	Designation

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_RE7INTEGRATIONGIVINGSUMMARY  (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @FIRSTGIFTAMOUNT money,
                        @FIRSTGIFTDATE datetime,
                        @LATESTGIFTAMOUNT money,
                        @LATESTGIFTDATE datetime,
                        @LARGESTGIFTAMOUNT money,
                        @LARGESTGIFTDATE datetime,
                        @TOTALGIFTSGIVEN int,
                        @TOTALGIFTAMOUNT money,
                        @FIRSTGIFTTYPE nvarchar(100),
                        @FIRSTGIFTDESIGNATION nvarchar(100),
                        @LARGESTGIFTTYPE nvarchar(100),
                        @LARGESTGIFTDESIGNATION nvarchar(100),
                        @LATESTGIFTTYPE nvarchar(100),
                        @LATESTGIFTDESIGNATION nvarchar(100)
                    ) as begin

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

                        set @TOTALGIFTSGIVEN = case when @TOTALGIFTSGIVEN is NULL then 0 else @TOTALGIFTSGIVEN end;

                        update dbo.RE7INTEGRATIONGIVINGSUMMARY set
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = getdate(),
                            FIRSTGIFTAMOUNT= @FIRSTGIFTAMOUNT,
                            FIRSTGIFTDATE = @FIRSTGIFTDATE,
                            LATESTGIFTAMOUNT = @LATESTGIFTAMOUNT,
                            LATESTGIFTDATE = @LATESTGIFTDATE,
                            LARGESTGIFTAMOUNT = @LARGESTGIFTAMOUNT,
                            LARGESTGIFTDATE = @LARGESTGIFTDATE,
                            TOTALGIFTSGIVEN = @TOTALGIFTSGIVEN,
                            TOTALGIFTAMOUNT = @TOTALGIFTAMOUNT,
                            FIRSTGIFTTYPE = @FIRSTGIFTTYPE,
                            FIRSTGIFTDESIGNATION = @FIRSTGIFTDESIGNATION,
                            LARGESTGIFTTYPE = @LARGESTGIFTTYPE,
                            LARGESTGIFTDESIGNATION = @LARGESTGIFTDESIGNATION,
                            LATESTGIFTTYPE = @LATESTGIFTTYPE,
                            LATESTGIFTDESIGNATION = @LATESTGIFTDESIGNATION
                        where
                            ID=@ID;

                        exec dbo.USP_WEALTHCAPACITY_UPDATE @ID, @CHANGEAGENTID;

                        return 0;

                    end;