USP_DATAFORMTEMPLATE_EDIT_EVENT_3

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@STARTDATE	datetime	IN	Start date
@STARTTIME	UDT_HOURMINUTE	IN	Start time
@ENDDATE	datetime	IN	End date
@ENDTIME	UDT_HOURMINUTE	IN	End time
@CAPACITY	int	IN	Capacity
@EVENTLOCATIONID	uniqueidentifier	IN	Location
@EVENTLOCATIONCONTACTID	uniqueidentifier	IN	Contact
@MAINEVENTID	uniqueidentifier	IN	Main event
@SITES	xml	IN	Sites
@EVENTCATEGORYCODEID	uniqueidentifier	IN	Category
@QUICKCOMPAREEVENTID	uniqueidentifier	IN	Quick comparison event

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_EVENT_3
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @STARTDATE datetime,
    @STARTTIME dbo.UDT_HOURMINUTE,
    @ENDDATE datetime,
    @ENDTIME dbo.UDT_HOURMINUTE,
    @CAPACITY int,
    @EVENTLOCATIONID uniqueidentifier,
    @EVENTLOCATIONCONTACTID uniqueidentifier,
    @MAINEVENTID uniqueidentifier,
    @SITES xml,
    @EVENTCATEGORYCODEID uniqueidentifier,
    @QUICKCOMPAREEVENTID uniqueidentifier
)

as
    set nocount on;

    declare @EVENTLOCATIONROOMID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENT_3
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @EVENTLOCATIONROOMID = @EVENTLOCATIONROOMID output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_EVENT_4
        @ID,
        @CURRENTAPPUSERID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @STARTDATE,
        @STARTTIME,
        @ENDDATE,
        @ENDTIME,
        @CAPACITY,
        @EVENTLOCATIONID,
        @EVENTLOCATIONCONTACTID,
        @MAINEVENTID,
        @SITES,
        @EVENTCATEGORYCODEID,
        @QUICKCOMPAREEVENTID,
        @EVENTLOCATIONROOMID

    return 0;