UFN_REGISTRATIONPACKAGE_GETEVENTPACKAGES
Get all selectable packages in an event that have at least one option that the user has access to.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | |
| @MAINEVENTID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_REGISTRATIONPACKAGE_GETEVENTPACKAGES(
@EVENTID uniqueidentifier,
@MAINEVENTID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier
)
returns table
as
return (
select distinct
REGISTRATIONPACKAGE.ID,
REGISTRATIONPACKAGE.EVENTID
from
dbo.REGISTRATIONPACKAGE
inner join dbo.EVENT on EVENT.ID = REGISTRATIONPACKAGE.EVENTID
inner join dbo.REGISTRATIONPACKAGEPRICE on REGISTRATIONPACKAGEPRICE.REGISTRATIONPACKAGEID = REGISTRATIONPACKAGE.ID
inner join dbo.EVENTPRICE on EVENTPRICE.ID = REGISTRATIONPACKAGEPRICE.EVENTPRICEID
inner join dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID) CHILDEVENTS on CHILDEVENTS.ID = EVENTPRICE.EVENTID
)