USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTCONDITION_1_1

The save procedure used by the edit dataform template "Matching Gift Condition Edit Form 1.1".

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
@RELATIONSHIPS	xml	IN	Relationship mappings

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTCONDITION_1_1
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @MATCHINGFACTOR decimal(5,2),
                    @MINMATCHPERGIFT money,
                    @MAXMATCHPERGIFT money,
                    @MAXMATCHANNUAL money,
                    @MAXMATCHTOTAL money,
                    @NOTES nvarchar(max),
                    @RELATIONSHIPS xml
                ) 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;

                        exec dbo.USP_MATCHINGGIFTCONDITIONRELATIONSHIP_VALIDATERELATIONSHIPTYPES @ID, @RELATIONSHIPS;
                        exec dbo.USP_MATCHINGGIFTCONDITIONRELATIONSHIP_GETRELATIONSHIPS_UPDATEFROMXML @ID, @RELATIONSHIPS, @CHANGEAGENTID;
                    end try

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

                    return 0;