USP_TIXEVENT_CHECKSCHEDULECONFLICT

Checks the availability of an event location.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@EVENTLOCATIONID	uniqueidentifier	IN
@EVENTDATE	date	IN
@STARTTIME	datetime	IN
@ENDTIME	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_TIXEVENT_CHECKSCHEDULECONFLICT
            (
                @ID uniqueidentifier=null output,
                @EVENTLOCATIONID uniqueidentifier=null,
                @EVENTDATE date=null,
                @STARTTIME datetime=null,
                @ENDTIME datetime=null

            )
            as
            set nocount on;
            begin 

                select
                    @ID=ID
                from
                    dbo.TIXEVENT 
                where
                    (((@STARTTIME >= STARTTIME ) and (@STARTTIME < ENDTIME)) OR ((@ENDTIME > STARTTIME) AND (@ENDTIME <= ENDTIME)) OR ((@STARTTIME > STARTTIME) AND (@ENDTIME <= ENDTIME)))
                    and dbo.UFN_GETDATEONLY(EVENTDATE)=dbo.UFN_GETDATEONLY(@EVENTDATE)
                    and ID in (select TIXEVENTID from dbo.TIXEVENTLOCATION where EVENTLOCATIONID=@EVENTLOCATIONID);


            end
            return 0;