UFN_EVENTPRICE_GETRELATEDEVENTSWITHPRICES

Returns all prices for a given event and its related events along with data for events that have no prices.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_EVENTPRICE_GETRELATEDEVENTSWITHPRICES
(
    @EVENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
returns table
as
return
(
    select
        EVENT.ID,
        EVENT.NAME [EVENTNAME],
        EVENTPRICE.ID [EVENTPRICEID],
        EVENTPRICE.NAME [EVENTPRICENAME],
        EVENTPRICE.EVENTREGISTRATIONTYPEID,
        EVENTREGISTRATIONTYPE.DESCRIPTION [EVENTREGISTRATIONTYPEDESCRIPTION],
        EVENTPRICE.AMOUNT [EVENTPRICEAMOUNT],
        EVENTPRICE.RECEIPTAMOUNT [EVENTPRICERECEIPTAMOUNT],
        EVENTPRICE.COST [EVENTPRICECOST],
        EVENTPRICE.REGISTRATIONCOUNT [EVENTPRICEREGISTRATIONCOUNT]
    from
        dbo.EVENT
        left join dbo.EVENTPRICE on EVENT.ID = EVENTPRICE.EVENTID
        left join dbo.EVENTREGISTRATIONTYPE on EVENTPRICE.EVENTREGISTRATIONTYPEID = EVENTREGISTRATIONTYPE.ID
    where
        EVENT.ID in (select ID from dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID))
)