UFN_EVENTCONFLICT_CONFLICTSEXIST

Checks an event/itinerary/itinerary item for conflicts.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@START	datetime	IN
@END	datetime	IN
@LOCATIONS	xml	IN
@RESOURCES	xml	IN
@STAFFRESOURCES	xml	IN
@IGNORERECORDID	uniqueidentifier	IN
@IGNORESUBRECORDID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_EVENTCONFLICT_CONFLICTSEXIST
        (
            @START datetime,
            @END datetime,
            @LOCATIONS xml,
            @RESOURCES xml,
            @STAFFRESOURCES xml,
            @IGNORERECORDID uniqueidentifier = null,
            @IGNORESUBRECORDID uniqueidentifier = null
        )
        returns bit
        as 
        begin

            if dbo.UFN_EVENTCONFLICT_RESOURCECONFLICTSEXIST(@START, @END, @RESOURCES, @IGNORERECORDID, @IGNORESUBRECORDID) = 1 or
                dbo.UFN_EVENTCONFLICT_STAFFRESOURCECONFLICTSEXIST(@START, @END, @STAFFRESOURCES, @IGNORERECORDID, @IGNORESUBRECORDID) = 1 or
                dbo.UFN_EVENTCONFLICT_LOCATIONCONFLICTSEXIST(@START, @END, @LOCATIONS, @IGNORERECORDID, @IGNORESUBRECORDID) = 1
                return 1;

            return 0;
          end