USP_DATAFORMTEMPLATE_VIEW_PAYMENTEVENTREVENUEBATCHREGISTRANTVIEW

The load procedure used by the view dataform template "Payment: Event Revenue Batch Registration 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.
@AMOUNT	money	INOUT	AMOUNT
@RECEIPTAMOUNT	money	INOUT	RECEIPTAMOUNT
@APPLICATIONCURRENCYID	uniqueidentifier	INOUT	APPLICATIONCURRENCYID

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PAYMENTEVENTREVENUEBATCHREGISTRANTVIEW
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @AMOUNT money = null output,
                @RECEIPTAMOUNT money = null output,
                @APPLICATIONCURRENCYID uniqueidentifier = null output
            )
            as
            begin
                set nocount on;

                set @DATALOADED = 0;

                select
                    @AMOUNT = sum(BATCHREVENUEREGISTRANTREGISTRATION.AMOUNT),
                    @RECEIPTAMOUNT = sum(BATCHREVENUEREGISTRANTREGISTRATION.RECEIPTAMOUNT),
                    @APPLICATIONCURRENCYID = EVENT.BASECURRENCYID
                from dbo.BATCHREVENUEREGISTRANTREGISTRATION
                inner join dbo.EVENTPRICE on BATCHREVENUEREGISTRANTREGISTRATION.EVENTPRICEID = EVENTPRICE.ID
                inner join dbo.EVENT on EVENTPRICE.EVENTID = EVENT.ID
                where
                    REGISTRANTID = @ID
                group by EVENT.BASECURRENCYID;

                if @AMOUNT is not null
                    set @DATALOADED = 1;

                return 0;
            end