USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTBATCHROW

The save procedure used by the edit dataform template "Event Batch Row Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@STARTDATE	date	IN	Start date
@STARTTIME	UDT_HOURMINUTE	IN	Start time
@ENDDATE	date	IN	End date
@ENDTIME	UDT_HOURMINUTE	IN	End time
@CAPACITY	int	IN	Capacity
@EVENTLOCATIONID	uniqueidentifier	IN	Location
@EVENTLOCATIONCONTACTID	uniqueidentifier	IN	Contact
@APPEALID	uniqueidentifier	IN	Appeal
@EVENTCATEGORYCODEID	uniqueidentifier	IN	Category
@PRICES	xml	IN	Registration options
@TASKS	xml	IN	Tasks
@EXPENSES	xml	IN	Expenses
@COORDINATORS	xml	IN	Coordinators
@SITES	xml	IN	Sites
@EVENTLOCATIONROOMID	uniqueidentifier	IN	Room/Unit
@CUSTOMIDENTIFIER	nvarchar(100)	IN	Lookup ID
@HIDEFROMCALENDAR	bit	IN	Do not show event on calendar
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@DESIGNATIONSONFEES	bit	IN	Event allows designations on fees
@DESIGNATIONS	xml	IN	Designations

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHEVENTBATCHROW
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @STARTDATE date,
    @STARTTIME dbo.UDT_HOURMINUTE,
    @ENDDATE date,
    @ENDTIME dbo.UDT_HOURMINUTE,
    @CAPACITY int,
    @EVENTLOCATIONID uniqueidentifier,
    @EVENTLOCATIONCONTACTID uniqueidentifier,
    @APPEALID uniqueidentifier,
    @EVENTCATEGORYCODEID uniqueidentifier,
    @PRICES xml,
    @TASKS xml,
    @EXPENSES xml,
    @COORDINATORS xml,
    @SITES xml,
    @EVENTLOCATIONROOMID uniqueidentifier,
    @CUSTOMIDENTIFIER nvarchar(100),
    @HIDEFROMCALENDAR bit,
    @BASECURRENCYID uniqueidentifier,
    @DESIGNATIONSONFEES bit,
    @DESIGNATIONS xml
) as
    set nocount on;

    declare @CURRENTDATE datetime;

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

    set @CURRENTDATE = getdate();

    if @BASECURRENCYID is null
        select @BASECURRENCYID = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()

    begin try
    update dbo.BATCHEVENT
        set [SEQUENCE] = @SEQUENCE,
            [CHANGEDBYID] = @CHANGEAGENTID,
            [DATECHANGED] = @CURRENTDATE,
            [NAME] = coalesce(@NAME, ''),
            [DESCRIPTION] = coalesce(@DESCRIPTION, ''),
            [STARTDATE] = @STARTDATE,
            [STARTTIME] = @STARTTIME,
            [ENDDATE] = @ENDDATE,
            [ENDTIME] = @ENDTIME,
            [CAPACITY] = coalesce(@CAPACITY, 0),
            [EVENTLOCATIONID] = @EVENTLOCATIONID,
            [EVENTLOCATIONROOMID] = @EVENTLOCATIONROOMID,
            [EVENTLOCATIONCONTACTID] = @EVENTLOCATIONCONTACTID,
            [APPEALID] = @APPEALID,
            [EVENTCATEGORYCODEID] = @EVENTCATEGORYCODEID,
            [CUSTOMID] = @CUSTOMIDENTIFIER,
            [HIDEFROMCALENDAR] = @HIDEFROMCALENDAR,
            [BASECURRENCYID] = @BASECURRENCYID,
            [DESIGNATIONSONFEES] = coalesce(@DESIGNATIONSONFEES,0)
        where
            ID = @ID

    exec dbo.USP_BATCHEVENT_GETPRICES_2_UPDATEFROMXML @ID, @PRICES, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETTASKS_UPDATEFROMXML @ID, @TASKS, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETEXPENSES_2_UPDATEFROMXML @ID, @EXPENSES, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETCOORDINATORS_UPDATEFROMXML @ID, @COORDINATORS, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETSITES_UPDATEFROMXML @ID, @SITES, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETDESIGNATIONS_UPDATEFROMXML @ID, @DESIGNATIONS, @CHANGEAGENTID;

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

    return 0;