USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTCONDITION

The save procedure used by the edit dataform template "Matching Gift Condition 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.
@MATCHINGFACTOR	decimal(5, 2)	IN	Matching factor
@MINMATCHPERGIFT	money	IN	Min match per gift
@MAXMATCHPERGIFT	money	IN	Max match per gift
@MAXMATCHANNUAL	money	IN	Max match per year
@MAXMATCHTOTAL	money	IN	Max match total
@NOTES	nvarchar(max)	IN	Notes

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTCONDITION
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @MATCHINGFACTOR decimal(5,2),
                    @MINMATCHPERGIFT money,
                    @MAXMATCHPERGIFT money,
                    @MAXMATCHANNUAL money,
                    @MAXMATCHTOTAL money,
                    @NOTES nvarchar(max)
                ) as
                    set nocount on;

                    declare @CURRENTDATE datetime;

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

                    set @CURRENTDATE = getdate();

                    begin try
                        update
                            dbo.MATCHINGGIFTCONDITION
                        set
                            [MATCHINGFACTOR] = @MATCHINGFACTOR,
                            [MINMATCHPERGIFT] = @MINMATCHPERGIFT,
                            [MAXMATCHPERGIFT] = @MAXMATCHPERGIFT,
                            [MAXMATCHANNUAL] = @MAXMATCHANNUAL,
                            [MAXMATCHTOTAL] = @MAXMATCHTOTAL,
                            [NOTES] = @NOTES,
                            [DATECHANGED] = @CURRENTDATE,
                            [CHANGEDBYID] = @CHANGEAGENTID
                        where
                            [ID] = @ID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;