USP_PROGRAMEVENTCONFLICT_INSERTCONFLICTS

Inserts program event conflicts.
Parameters

Parameter	Parameter Type	Mode
@EVENTS	xml	IN
@SCHEDULEID	uniqueidentifier	IN
@PROGRAMID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@CAPACITY	int	IN
@DESCRIPTION	nvarchar(500)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
Definition

Copy


            CREATE procedure dbo.USP_PROGRAMEVENTCONFLICT_INSERTCONFLICTS
            (
                @EVENTS xml,
                @SCHEDULEID uniqueidentifier,
                @PROGRAMID uniqueidentifier,
                @NAME nvarchar(100) = null,
                @CAPACITY integer = null,
                @DESCRIPTION nvarchar(500) = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CURRENTDATE datetime = null
            )
            as
            begin
                set nocount on;

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                if @CURRENTDATE is null
                    set @CURRENTDATE = getdate()

                declare @idoc int
                exec sp_xml_preparedocument @idoc OUTPUT, @EVENTS                    

                insert into dbo.EVENTCONFLICT
                (
                    ID,
                    SCHEDULEID,
                    PROGRAMID,
                    NAME,
                    DESCRIPTION,
                    CAPACITY,
                    STARTDATE,
                    STARTTIME,
                    ENDDATE,
                    ENDTIME,
                    ADDEDBYID, 
                    CHANGEDBYID, 
                    DATEADDED, 
                    DATECHANGED
                )
                select
                    CONFLICTID,
                    @SCHEDULEID,
                    @PROGRAMID,
                    @NAME,
                    @DESCRIPTION,
                    @CAPACITY,
                    STARTDATE,
                    STARTTIME,
                    ENDDATE,
                    ENDTIME,
                    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
                    from openxml (@idoc,'/EVENTS/ITEM', 2)
                    with
                        (CONFLICTID uniqueidentifier,
                        STARTDATE date,
                        STARTTIME udt_HOURMINUTE,
                        ENDDATE date,
                        ENDTIME udt_HOURMINUTE,
                        ISCONFLICT bit)
                    where ISCONFLICT = 1

            end