USP_DATALIST_EVENTGROUPPRICES

Displays the registration options for the given event and all events below it.

Parameters

Parameter	Parameter Type	Mode	Description
@MAINEVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EVENTGROUPPRICES
                (
                    @MAINEVENTID uniqueidentifier, 
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select EVENTPRICE.ID,
                           EVENTREGISTRATIONTYPE.DESCRIPTION,
                           EVENTPRICE.AMOUNT,
                           EVENTPRICE.RECEIPTAMOUNT,
                           EVENTPRICE.REGISTRATIONCOUNT,
                           EVENTS.NAME,
                           EVENTPRICE.NAME
                    from 
                        dbo.EVENTPRICE                         
                        inner join dbo.UFN_CHILDEVENTSWITHSITEACCESS(@MAINEVENTID, @CURRENTAPPUSERID) EVENTS on EVENTS.ID = EVENTPRICE.EVENTID
                        inner join dbo.EVENTREGISTRATIONTYPE on EVENTREGISTRATIONTYPE.ID = EVENTPRICE.EVENTREGISTRATIONTYPEID
                    order by
                        EVENTS.NAME, EVENTREGISTRATIONTYPE.DESCRIPTION;