USP_DATAFORMTEMPLATE_EDITLOAD_EVENTSPONSORBENEFIT

The load procedure used by the edit dataform template "Event Sponsor Benefit Edit Data 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.
@BENEFIT	xml	INOUT	Benefits
@BENEFITSWAIVED	bit	INOUT	Waive benefits
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@SPONSORNAME	nvarchar(100)	INOUT	Sponsor name
@EVENTBASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@EVENTBASECURRENCYDECIMALDIGITS	tinyint	INOUT	Event base currency decimal digits
@EVENTBASECURRENCYROUNDINGTYPECODE	tinyint	INOUT	Event base currency rounding type code
@EVENTNAME	nvarchar(100)	INOUT	Event name

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENTSPONSORBENEFIT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @BENEFIT xml = null output,
    @BENEFITSWAIVED bit = null output,
    @TSLONG bigint = 0 output,
    @SPONSORNAME nvarchar(100) = null output,
    @EVENTBASECURRENCYID uniqueidentifier = null output,
    @EVENTBASECURRENCYDECIMALDIGITS tinyint = null output,
    @EVENTBASECURRENCYROUNDINGTYPECODE tinyint = null output,
    @EVENTNAME nvarchar(100) = null output
)
as
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @TSLONG = ES.TSLONG,
        @BENEFIT = dbo.UFN_EVENTSPONSOR_GETBENEFITS_TOITEMLISTXML(@ID), 
        @BENEFITSWAIVED = ES.BENEFITSWAIVED,
        @SPONSORNAME = dbo.UFN_CONSTITUENT_BUILDNAME(ES.CONSTITUENTID),
        @EVENTBASECURRENCYID = E.BASECURRENCYID,
        @EVENTNAME = E.NAME
    from
        dbo.EVENTSPONSOR ES(nolock)
        inner join dbo.[EVENT] E(nolock) on ES.EVENTID = E.ID
    where    
        ES.ID = @ID;

    select     
        @EVENTBASECURRENCYDECIMALDIGITS = DECIMALDIGITS,
        @EVENTBASECURRENCYROUNDINGTYPECODE = ROUNDINGTYPECODE
    from 
        dbo.CURRENCY
    where 
        ID = @EVENTBASECURRENCYID;

    return 0;