UFN_DAILYSALEITEM_EVENT_GETAVAILABILITY

Returns event availability for daily sales item event buttons for date and salesmethod

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DATETIMEOFFSET	datetimeoffset	IN
@SALESMETHODID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_DAILYSALEITEM_EVENT_GETAVAILABILITY
        (
            @DATETIMEOFFSET datetimeoffset, 
            @SALESMETHODID uniqueidentifier
        )
        returns @VALIDEVENTS table
        (
            EVENTID uniqueidentifier,
            PROGRAMID uniqueidentifier,
            CAPACITY integer,
            ISONSALE bit,
            FACEPRICE money,
            PRICETYPECODEID uniqueidentifier,
            LOCATION nvarchar(100)
        )
        as
            begin

                insert into @VALIDEVENTS
                select
                    EVENTID,
                    PROGRAMID,
                    CAPACITY,
                    ISONSALE,
                    FACEPRICE,
                    PRICETYPECODEID,
                    LOCATION
                from dbo.UFN_DAILYSALEITEM_EVENT_GETAVAILABILITY_2(@DATETIMEOFFSET, @SALESMETHODID)

                return;
            end;