USP_EVENTCONFLICT_INSERT

This procedure inserts data into the event conflict table.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@SCHEDULEID	uniqueidentifier	IN
@PROGRAMID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(500)	IN
@CAPACITY	int	IN
@EVENTSTARTDATE	date	IN
@EVENTENDDATE	date	IN
@STARTTIME	datetime	IN
@ENDTIME	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SUPERCEDESPROGRAMPUBLICDESCRIPTION	bit	IN
@PUBLICDESCRIPTIONTEXT	nvarchar(max)	IN
@PUBLICDESCRIPTIONHTML	nvarchar(max)	IN
@SOURCEEVENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_EVENTCONFLICT_INSERT
(
    @ID uniqueidentifier=null output,
    @SCHEDULEID uniqueidentifier=null,
    @PROGRAMID uniqueidentifier=null,
    @NAME nvarchar(100)=null,
    @DESCRIPTION nvarchar(500)=null,
    @CAPACITY integer=null,
    @EVENTSTARTDATE date=null,
    @EVENTENDDATE date=null,
    @STARTTIME datetime=null,
    @ENDTIME datetime=null,
    @CHANGEAGENTID uniqueidentifier=null,
    @SUPERCEDESPROGRAMPUBLICDESCRIPTION bit = 0,
    @PUBLICDESCRIPTIONTEXT nvarchar(max) = '',
    @PUBLICDESCRIPTIONHTML nvarchar(max) = '',
    @SOURCEEVENTID uniqueidentifier = null
)
as 
    set nocount on;

    if @ID is null 
        set @ID = newid();

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

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    begin try
        insert into dbo.EVENTCONFLICT (
            ID,
            SCHEDULEID,
            PROGRAMID,
            NAME,
            DESCRIPTION,
            CAPACITY,
            STARTDATE,
            STARTTIME,
            ENDDATE,
            ENDTIME,
            PUBLICDESCRIPTIONTEXT,
            PUBLICDESCRIPTIONHTML,
            SUPERCEDESPROGRAMPUBLICDESCRIPTION,
            SOURCEEVENTID,
            ADDEDBYID, 
            CHANGEDBYID, 
            DATEADDED, 
            DATECHANGED
        ) values (
            @ID,
            @SCHEDULEID,
            @PROGRAMID,
            @NAME,
            @DESCRIPTION,
            @CAPACITY,
            @EVENTSTARTDATE,
            dbo.UFN_HOURMINUTE_GETFROMDATE(@STARTTIME),
            @EVENTENDDATE,
            dbo.UFN_HOURMINUTE_GETFROMDATE(@ENDTIME),
            @PUBLICDESCRIPTIONTEXT,
            @PUBLICDESCRIPTIONHTML,
            @SUPERCEDESPROGRAMPUBLICDESCRIPTION,
            @SOURCEEVENTID,
            @CHANGEAGENTID, 
            @CHANGEAGENTID, 
            @CURRENTDATE, 
            @CURRENTDATE
        );
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;