USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEVENTBATCHROW

The load 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 used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@SEQUENCE	int	INOUT	Sequence
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@STARTDATE	date	INOUT	Start date
@STARTTIME	UDT_HOURMINUTE	INOUT	Start time
@ENDDATE	date	INOUT	End date
@ENDTIME	UDT_HOURMINUTE	INOUT	End time
@CAPACITY	int	INOUT	Capacity
@EVENTLOCATIONID	uniqueidentifier	INOUT	Location
@EVENTLOCATIONCONTACTID	uniqueidentifier	INOUT	Contact
@APPEALID	uniqueidentifier	INOUT	Appeal
@EVENTCATEGORYCODEID	uniqueidentifier	INOUT	Category
@PRICES	xml	INOUT	Registration options
@TASKS	xml	INOUT	Tasks
@EXPENSES	xml	INOUT	Expenses
@COORDINATORS	xml	INOUT	Coordinators
@SITES	xml	INOUT	Sites
@EVENTLOCATIONROOMID	uniqueidentifier	INOUT	Room/Unit
@CUSTOMIDENTIFIER	nvarchar(100)	INOUT	Lookup ID
@HIDEFROMCALENDAR	bit	INOUT	Do not show event on calendar
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@DESIGNATIONSONFEES	bit	INOUT	Event allows designations on fees
@DESIGNATIONS	xml	INOUT	Designations

Definition

Copy


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

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @TSLONG = [TSLONG],
        @SEQUENCE = [SEQUENCE],
        @NAME = [NAME],
        @DESCRIPTION = [DESCRIPTION],
        @STARTDATE = [STARTDATE],
        @STARTTIME = [STARTTIME],
        @ENDDATE = [ENDDATE],
        @ENDTIME = [ENDTIME],
        @CAPACITY = [CAPACITY],
        @EVENTLOCATIONID = [EVENTLOCATIONID],
        @EVENTLOCATIONROOMID = [EVENTLOCATIONROOMID],
        @EVENTLOCATIONCONTACTID = [EVENTLOCATIONCONTACTID],
        @APPEALID = [APPEALID],
        @EVENTCATEGORYCODEID = [EVENTCATEGORYCODEID],
        @PRICES = dbo.UFN_BATCHEVENT_GETPRICES_2_TOITEMLISTXML(ID),
        @TASKS = dbo.UFN_BATCHEVENT_GETTASKS_TOITEMLISTXML(ID),
        @EXPENSES = dbo.UFN_BATCHEVENT_GETEXPENSES_TOITEMLISTXML(ID),
        @COORDINATORS = dbo.UFN_BATCHEVENT_GETCOORDINATORS_TOITEMLISTXML(ID),
        @SITES = dbo.UFN_BATCHEVENT_GETSITES_TOITEMLISTXML(ID),
        @CUSTOMIDENTIFIER = CUSTOMID,
        @HIDEFROMCALENDAR = HIDEFROMCALENDAR,
        @BASECURRENCYID = coalesce(BASECURRENCYID, dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY()),
        @DESIGNATIONSONFEES = DESIGNATIONSONFEES,
        @DESIGNATIONS = dbo.UFN_BATCHEVENT_GETDESIGNATIONS_TOITEMLISTXML(ID)
    from
        dbo.BATCHEVENT
    where
        BATCHEVENT.ID = @ID;

    return 0;