USP_DATALIST_REGISTRATIONPACKAGES

Displays the registration packages for the event group.
Parameters

Parameter	Parameter Type	Mode	Description
@MAINEVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_REGISTRATIONPACKAGES
                (
                    @MAINEVENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        REGISTRATIONPACKAGE.ID, 
                        REGISTRATIONPACKAGE.NAME,
                        (
                            select 
                                count(ID) 
                            from 
                                dbo.REGISTRATIONPACKAGEPRICE 
                            where 
                                REGISTRATIONPACKAGEPRICE.REGISTRATIONPACKAGEID = REGISTRATIONPACKAGE.ID
                        ) [EVENTCOUNT],
                        dbo.UFN_REGISTRATIONPACKAGE_GETAMOUNT(REGISTRATIONPACKAGE.ID) [TOTALAMOUNT],
                        case when dbo.UFN_REGISTRATIONPACKAGE_GETPRICESBASECURRENCYID(REGISTRATIONPACKAGE.ID) is null
                            then
                                (select BASECURRENCYID from EVENT where ID = @MAINEVENTID)
                            else
                                dbo.UFN_REGISTRATIONPACKAGE_GETPRICESBASECURRENCYID(REGISTRATIONPACKAGE.ID)
                        end [BASECURRENCYID]
                    from 
                        dbo.REGISTRATIONPACKAGE                         
                    where 
                        REGISTRATIONPACKAGE.EVENTID = @MAINEVENTID
                    order by
                        REGISTRATIONPACKAGE.DATEADDED;