USP_DATAFORMTEMPLATE_ADD_EVENTPRICE_PRELOAD_2

The load procedure used by the edit dataform template "Registration Option Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@REGISTRATIONCOUNT	int	INOUT	Registration count
@EVENTREGISTRATIONTYPES	xml	INOUT	Registration types list
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@EVENTBASECURRENCYDECIMALDIGITS	tinyint	INOUT	Event base currency decimal digits
@EVENTBASECURRENCYROUNDINGTYPECODE	tinyint	INOUT	Event base currency rounding type code

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EVENTPRICE_PRELOAD_2
                    (
                        @EVENTID uniqueidentifier,
                        @REGISTRATIONCOUNT int = null output,
                        @EVENTREGISTRATIONTYPES xml = null output,
                        @BASECURRENCYID uniqueidentifier = null output,
                        @EVENTBASECURRENCYDECIMALDIGITS tinyint = null output,
                        @EVENTBASECURRENCYROUNDINGTYPECODE tinyint = null output
                    )
                    as
                        set nocount on;

                        select 
                            @BASECURRENCYID = EVENT.BASECURRENCYID 
                        from
                            dbo.EVENT
                        where 
                            ID = @EVENTID;

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

                        set @REGISTRATIONCOUNT = null; -- Registration count initially is blank, without this it would default to the min value.

                        set @EVENTREGISTRATIONTYPES = dbo.UFN_EVENTREGISTRATIONTYPE_GETREGISTRATIONTYPES_TOITEMLISTXML();