USP_DATAFORMTEMPLATE_VIEW_PAYMENTMGPLEDGE

The load procedure used by the view dataform template "Payment: Matching Gift Pledge View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TRANSACTIONTYPE	nvarchar(20)	INOUT	Type
@CONSTITUENTNAME	nvarchar(700)	INOUT	Constituent
@DESCRIPTION	nvarchar(700)	INOUT	Description
@PLEDGEDATE	datetime	INOUT	Date
@AMOUNT	money	INOUT	Amount
@BALANCE	money	INOUT	Balance
@TOTALPAID	money	INOUT	Total paid
@MAXAMOUNT	money	INOUT	MAXAMOUNT
@APPLIEDTOCOUNT	int	INOUT	APPLIEDTOCOUNT
@APPLIEDAMOUNT	money	INOUT	APPLIEDAMOUNT
@APPLIEDTYPE	nvarchar(20)	INOUT	APPLIEDTYPE
@APPLIEDNAME	nvarchar(500)	INOUT	APPLIEDNAME
@ANONYMOUS	bit	INOUT	ANONYMOUS
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency ID
@APPLIEDLOOKUPID	nvarchar(100)	INOUT	APPLIEDLOOKUPID

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PAYMENTMGPLEDGE
                (
                    @ID uniqueidentifier,    
                    @DATALOADED bit = 0 output,
                    @TRANSACTIONTYPE nvarchar(20) = null output,
                    @CONSTITUENTNAME nvarchar(700) = null output,
                    @DESCRIPTION nvarchar(700) = null output,
                    @PLEDGEDATE datetime = null output,
                    @AMOUNT money = null output,
                    @BALANCE money = null output,
                    @TOTALPAID money = null output,
                    @MAXAMOUNT money = null output,
                    @APPLIEDTOCOUNT integer = null output,
                    @APPLIEDAMOUNT money = null output,
                    @APPLIEDTYPE nvarchar(20) = null output,
                    @APPLIEDNAME nvarchar(500) = null output,
                    @ANONYMOUS bit = null output,
                    @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                    @APPLIEDLOOKUPID as nvarchar(100) = null output
                )
                as
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @TRANSACTIONTYPE = REVENUE.TRANSACTIONTYPE,
                    @CONSTITUENTNAME = NF.NAME,
                    @PLEDGEDATE = REVENUE.DATE,
                    @AMOUNT = REVENUE.TRANSACTIONAMOUNT,
                    @BALANCE = dbo.UFN_PLEDGE_GETBALANCE(REVENUE.ID),
                    @TOTALPAID = dbo.UFN_PLEDGE_GETAMOUNTPAID(REVENUE.ID),
                    @ANONYMOUS = REVENUE.GIVENANONYMOUSLY,
                    @TRANSACTIONCURRENCYID = REVENUE.TRANSACTIONCURRENCYID
                from dbo.REVENUE
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REVENUE.CONSTITUENTID) NF
                where REVENUE.ID = @ID;


                select @APPLIEDTOCOUNT = count(*) 
                from dbo.REVENUEMATCHINGGIFT
                where REVENUEMATCHINGGIFT.ID = @ID;

                if @APPLIEDTOCOUNT = 1
                    select top 1
                        @APPLIEDAMOUNT  = REVENUE.TRANSACTIONAMOUNT,
                        @APPLIEDTYPE = REVENUE.TRANSACTIONTYPE,
                        @APPLIEDNAME = NF.NAME,
                        @APPLIEDLOOKUPID = CONSTITUENT.LOOKUPID
                    from dbo.REVENUEMATCHINGGIFT
                        inner join dbo.REVENUE on MGSOURCEREVENUEID = REVENUE.ID
                        inner join dbo.CONSTITUENT on CONSTITUENT.ID = REVENUE.CONSTITUENTID
                        cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REVENUE.CONSTITUENTID) NF
                    where REVENUEMATCHINGGIFT.ID = @ID;                

                set @DESCRIPTION = @CONSTITUENTNAME;

                return 0;