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;