USP_DATALIST_PROGRAM_DAILYADMISSION

Lists daily admission programs available via the specified sales method.

Parameters

Parameter	Parameter Type	Mode	Description
@ONLYACTIVE	bit	IN
@SALESMETHODTYPECODE	tinyint	IN	On-sale via specified sales method
@PROGRAMCATEGORYCODEID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_PROGRAM_DAILYADMISSION
            (
                @ONLYACTIVE bit = 1,
                @SALESMETHODTYPECODE tinyint,
                @PROGRAMCATEGORYCODEID uniqueidentifier = null
            )
            as
                set nocount on;    

                select 
                    P.ID, 
                    P.NAME,
                    P.PUBLICDESCRIPTIONHTML
                from dbo.PROGRAM P
                inner join dbo.PROGRAMSALESMETHOD PSM on PSM.PROGRAMID = P.ID
                inner join dbo.SALESMETHOD SM on SM.ID = PSM.SALESMETHODID
                where 
                    P.ISDAILYADMISSION = 1 and
                    SM.TYPECODE = @SALESMETHODTYPECODE and
                    (
                        @ONLYACTIVE = 0 or
                        P.ISACTIVE = 1
                    ) and
                    (    
                        @PROGRAMCATEGORYCODEID is null or
                        PROGRAMCATEGORYCODEID = @PROGRAMCATEGORYCODEID
                    )
                order by NAME