USP_DATAFORMTEMPLATE_ADD_REGISTRANTMAINEVENT_PRELOAD

The load procedure used by the edit dataform template "Registrant Main Event Add Form"

Parameters

Parameter Parameter Type Mode Description
@EVENTID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@MAINEVENTID uniqueidentifier INOUT MAINEVENTID
@PACKAGESPRICES xml INOUT
@MULTICOMPONENTEVENTPRICES xml INOUT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_REGISTRANTMAINEVENT_PRELOAD
                    (
                        @EVENTID uniqueidentifier,
                        @MAINEVENTID uniqueidentifier = null output,
                        @PACKAGESPRICES xml = null output,
                        @MULTICOMPONENTEVENTPRICES xml = null output
                    )
                    as
                        set nocount on;

                        set @MAINEVENTID = @EVENTID;
                        set @PACKAGESPRICES = dbo.UFN_REGISTRATIONPACKAGE_GETPACKAGESPRICES_TOITEMLISTXML(@EVENTID);
                        set @MULTICOMPONENTEVENTPRICES = dbo.UFN_EVENTPRICE_GETMULTICOMPONENTEVENTPRICES_TOITEMLISTXML(@EVENTID);

                        return 0;