USP_DATAFORMTEMPLATE_EDITLOAD_EVENT_3

The load procedure used by the edit dataform template "Event Edit Form 3"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@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
@MAINEVENTID	uniqueidentifier	INOUT	Main event
@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.
@SITES	xml	INOUT	Sites
@SITEREQUIRED	bit	INOUT	Site required
@EVENTCATEGORYCODEID	uniqueidentifier	INOUT	Category
@QUICKCOMPAREEVENTID	uniqueidentifier	INOUT	Quick comparison event
@EVENTLOCATIONROOMID	uniqueidentifier	INOUT	Room/Unit
@ISAUCTION	bit	INOUT	Event is an auction
@EVENTAUCTIONHASITEMS	bit	INOUT	Event has items associated
@DESIGNATIONSONFEES	bit	INOUT	Event allows designations on fees
@EVENTHASREGISTRANTS	bit	INOUT	Event has registrants

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENT_3
                    (
                        @ID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @DATALOADED bit = 0 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,
                        @MAINEVENTID uniqueidentifier = null output,
                        @TSLONG bigint = 0 output,
                        @SITES xml = null output,
                        @SITEREQUIRED bit = null output,
                        @EVENTCATEGORYCODEID uniqueidentifier =null output,
                        @QUICKCOMPAREEVENTID uniqueidentifier = null output,
                        @EVENTLOCATIONROOMID uniqueidentifier = null output,
                        @ISAUCTION bit = null output,
                        @EVENTAUCTIONHASITEMS bit = null output,
                        @DESIGNATIONSONFEES bit = null output,
                        @EVENTHASREGISTRANTS bit = null output
                    )
                    as
                    begin

                        set nocount on

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

                        select 
                            @DATALOADED = 1,
                            @NAME = EVENT.NAME,
                            @DESCRIPTION = EVENT.DESCRIPTION,    
                            @STARTDATE = EVENT.STARTDATE,
                            @STARTTIME = EVENT.STARTTIME,
                            @ENDDATE = EVENT.ENDDATE,
                            @ENDTIME = EVENT.ENDTIME,                                
                            @CAPACITY = EVENT.CAPACITY,
                            @EVENTLOCATIONID = EVENT.EVENTLOCATIONID,
                            @EVENTLOCATIONCONTACTID = EVENT.EVENTLOCATIONCONTACTID,
                            @MAINEVENTID = EVENT.MAINEVENTID,
                            @TSLONG = EVENT.TSLONG,
                            @SITES = dbo.UFN_EVENT_GETSITES_TOITEMLISTXML(EVENT.ID),
                            @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID),
                            @EVENTCATEGORYCODEID = EVENT.EVENTCATEGORYCODEID,
                            @QUICKCOMPAREEVENTID = EVENT.QUICKCOMPAREEVENTID,
                            @EVENTLOCATIONROOMID = EVENT.EVENTLOCATIONROOMID,
                            @ISAUCTION = case when EVENTAUCTION.ID is null then 0 else 1 end,
                            @EVENTAUCTIONHASITEMS = case when exists(select 1 from dbo.AUCTIONITEM where AUCTIONITEM.EVENTAUCTIONID = @ID) then 1 else 0 end,
                            @DESIGNATIONSONFEES = EVENT.DESIGNATIONSONFEES,
                            @EVENTHASREGISTRANTS = case when exists(select 1 from dbo.REGISTRANT where REGISTRANT.EVENTID = @ID) then 1 else 0 end
                        from  
                            dbo.EVENT
                            left join dbo.EVENTAUCTION on EVENT.ID = EVENTAUCTION.ID
                        where 
                            EVENT.ID = @ID                    

                        return 0
                    end