USP_DATALIST_EVENTPRICELIST

Lists all event price lists.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



      CREATE procedure dbo.USP_DATALIST_EVENTPRICELIST
        (
            @CONTEXTID uniqueidentifier,
            @INCLUDEINACTIVE bit = 0
        )
      as
        set nocount on;

        if exists (select ID from PROGRAMEVENTPRICE where EVENTID = @CONTEXTID)
            begin    
            select
                PROGRAMEVENTPRICE.ID,
                PRICETYPECODE.DESCRIPTION as PRICETYPE,
                PROGRAMEVENTPRICE.FACEPRICE,
                PRICETYPECODE.ID as PRICETYPECODEID
            from dbo.PROGRAMEVENTPRICE
                inner join dbo.PRICETYPECODE on PRICETYPECODE.ID = PROGRAMEVENTPRICE.PRICETYPECODEID
            where PROGRAMEVENTPRICE.EVENTID = @CONTEXTID and (@INCLUDEINACTIVE = 1 or PRICETYPECODE.ACTIVE = 1)
            order by PROGRAMEVENTPRICE.SEQUENCE
            end
        else
            begin    
            select
                PROGRAMPRICE.ID,
                PRICETYPECODE.DESCRIPTION as PRICETYPE,
                PROGRAMPRICE.FACEPRICE,
                PRICETYPECODE.ID as PRICETYPECODEID
            from dbo.PROGRAMPRICE
                inner join dbo.PRICETYPECODE on PRICETYPECODE.ID = PROGRAMPRICE.PRICETYPECODEID
                inner join dbo.EVENT on PROGRAMPRICE.PROGRAMID = EVENT.PROGRAMID
            where EVENT.ID = @CONTEXTID and (@INCLUDEINACTIVE = 1 or PRICETYPECODE.ACTIVE = 1)
            order by PROGRAMPRICE.SEQUENCE
            end