USP_DATAFORMTEMPLATE_PRELOAD_ADD_MGPLEDGE

The load procedure used by the edit dataform template "Matching Gift Claim Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ORIGINALGIFTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ORIGINALGIFTAMOUNT	money	INOUT	Original gift amount
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@CONSTITUENTNAME	nvarchar(255)	INOUT	Constituent name
@DATE	datetime	INOUT	Date
@SPLITS	xml	INOUT	Designations
@POSTDATE	datetime	INOUT	Post date

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_MGPLEDGE
                    (
                        @ORIGINALGIFTID uniqueidentifier,
                        @ORIGINALGIFTAMOUNT money = null output,
                        @CONSTITUENTID uniqueidentifier = null output,
                        @CONSTITUENTNAME nvarchar(255) = null output,
                        @DATE datetime = null output,
                        @SPLITS xml = null output,
                        @POSTDATE datetime = null output
                    )
                    as 
                    set nocount on;

                    if @ORIGINALGIFTID is null 
                        return 1;

                    declare @SPLITSTABLE table
                    (
                        ID uniqueidentifier,
                        DESIGNATIONID uniqueidentifier,
                        AMOUNT money
                    );

                    set @ORIGINALGIFTAMOUNT = 0;
                    set @DATE = getdate();
                    set @POSTDATE = getdate();

                    select 
                        top 1 
                            @CONSTITUENTID = REVENUE.CONSTITUENTID,
                            @ORIGINALGIFTAMOUNT = REVENUE.AMOUNT
                    from dbo.REVENUE
                    where REVENUE.ID = @ORIGINALGIFTID;

                    select 
                        @CONSTITUENTNAME = NAME 
                    from dbo.CONSTITUENT 
                    where ID = @CONSTITUENTID;

                    insert into @SPLITSTABLE 
                        select 
                            newid(),
                            DESIGNATIONID,
                            AMOUNT
                        from dbo.UFN_REVENUE_GETSPLITS(@ORIGINALGIFTID);

                    select @SPLITS = 
                        (
                            select 
                                AMOUNT,
                                DESIGNATIONID,
                                ID
                            from @SPLITSTABLE
                            order by ID
                            for xml raw('ITEM'),type,elements,root('SPLITS'),binary base64
                        );

                    return 0;