USP_DATAFORMTEMPLATE_ADD_BATCHEVENTBATCHROW

The save procedure used by the add dataform template "Event Batch Row Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@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_ADD_BATCHEVENTBATCHROW
(
    @ID uniqueidentifier = null output,
    @BATCHID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @SEQUENCE int,
    @NAME nvarchar(100) = '',
    @DESCRIPTION nvarchar(255) = '',
    @STARTDATE date = null,
    @STARTTIME dbo.UDT_HOURMINUTE = null,
    @ENDDATE date = null,
    @ENDTIME dbo.UDT_HOURMINUTE = null,
    @CAPACITY int = 0,
    @EVENTLOCATIONID uniqueidentifier = null,
    @EVENTLOCATIONCONTACTID uniqueidentifier = null,
    @APPEALID uniqueidentifier = null,
    @EVENTCATEGORYCODEID uniqueidentifier = null,
    @PRICES xml = null,
    @TASKS xml = null,
    @EXPENSES xml = null,
    @COORDINATORS xml = null,
    @SITES xml = null,
    @EVENTLOCATIONROOMID uniqueidentifier = null,
    @CUSTOMIDENTIFIER nvarchar(100) = '',
    @HIDEFROMCALENDAR bit = 0,
    @BASECURRENCYID uniqueidentifier = null,
    @DESIGNATIONSONFEES bit = 0,
    @DESIGNATIONS xml = null
) as
    set nocount on;

    declare @CURRENTDATE datetime;

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

    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
    insert into dbo.BATCHEVENT (
        [ID],
        [BATCHID],
        [SEQUENCE],
        [ADDEDBYID],
        [CHANGEDBYID],
        [DATEADDED],
        [DATECHANGED],
        [NAME],
        [DESCRIPTION],
        [STARTDATE],
        [STARTTIME],
        [ENDDATE],
        [ENDTIME],
        [CAPACITY],
        [EVENTLOCATIONID],
        [EVENTLOCATIONROOMID],
        [EVENTLOCATIONCONTACTID],
        [APPEALID],
        [EVENTCATEGORYCODEID],
        [CUSTOMID],
        [HIDEFROMCALENDAR],
        [BASECURRENCYID],
        [DESIGNATIONSONFEES]
    ) values (
        @ID,
        @BATCHID,
        @SEQUENCE,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE,
        coalesce(@NAME, ''),
        coalesce(@DESCRIPTION, ''),
        @STARTDATE,
        coalesce(@STARTTIME, ''),
        @ENDDATE,
        coalesce(@ENDTIME, ''),
        coalesce(@CAPACITY, 0),
        @EVENTLOCATIONID,
        @EVENTLOCATIONROOMID,
        @EVENTLOCATIONCONTACTID,
        @APPEALID,
        @EVENTCATEGORYCODEID,
        @CUSTOMIDENTIFIER,
        coalesce(@HIDEFROMCALENDAR, 0),
        @BASECURRENCYID,
        coalesce(@DESIGNATIONSONFEES,0)
    );

    exec dbo.USP_BATCHEVENT_GETPRICES_2_ADDFROMXML @ID, @PRICES, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETTASKS_ADDFROMXML @ID, @TASKS, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETEXPENSES_2_ADDFROMXML @ID, @EXPENSES, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETCOORDINATORS_ADDFROMXML @ID, @COORDINATORS, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETSITES_ADDFROMXML @ID, @SITES, @CHANGEAGENTID;
    exec dbo.USP_BATCHEVENT_GETDESIGNATIONS_ADDFROMXML @ID, @DESIGNATIONS, @CHANGEAGENTID;

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

    return 0;