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;