USP_DATAFORMTEMPLATE_ADD_COPYEVENT_PRELOAD

The load procedure used by the edit dataform template "Copy Event Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DESCRIPTION	nvarchar(255)	INOUT	Description
@CAPACITY	int	INOUT	Capacity
@EVENTLOCATIONID	uniqueidentifier	INOUT	Location
@EVENTLOCATIONCONTACTID	uniqueidentifier	INOUT	Contact
@COPYFROMEVENTNAME	nvarchar(100)	INOUT	Copy from
@COPYFROMEVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ATTRIBUTEDEFINED	bit	INOUT	Event attributes defined
@SITES	xml	INOUT	Sites
@EVENTCATEGORYCODEID	uniqueidentifier	INOUT	Category
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site required
@EVENTLOCATIONROOMID	uniqueidentifier	INOUT	Room/Unit
@ISAUCTION	bit	INOUT	Event is an auction

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COPYEVENT_PRELOAD
                    (
                        @DESCRIPTION nvarchar(255) = null output,
                        @CAPACITY int = null output,
                        @EVENTLOCATIONID uniqueidentifier = null output,
                        @EVENTLOCATIONCONTACTID uniqueidentifier = null output,
                        @COPYFROMEVENTNAME nvarchar(100) = null output,
                        @COPYFROMEVENTID uniqueidentifier,
                        @ATTRIBUTEDEFINED bit = null output,
                        @SITES xml = null output,
                        @EVENTCATEGORYCODEID uniqueidentifier = null output,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @SITEREQUIRED bit = null output,
                        @EVENTLOCATIONROOMID uniqueidentifier = null output,
                        @ISAUCTION bit = null output
                    )
                    as                    
                        set nocount on;

                        select
                            @DESCRIPTION = DESCRIPTION,
                            @CAPACITY = CAPACITY,
                            @EVENTLOCATIONID = EVENTLOCATIONID,
                            @EVENTLOCATIONCONTACTID = EVENTLOCATIONCONTACTID,
                            @COPYFROMEVENTNAME = [NAME],
                            @SITES = (SELECT newID() as ID, SITEID as SITEID from dbo.EVENTSITE where EVENTSITE.EVENTID = @COPYFROMEVENTID for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64),
                            @EVENTCATEGORYCODEID = EVENTCATEGORYCODEID,
                            @EVENTLOCATIONROOMID = EVENTLOCATIONROOMID,
                            @ISAUCTION = case when EVENTAUCTION.ID is not null then 1 else 0 end
                        from
                            dbo.EVENT
                            left join dbo.EVENTAUCTION on EVENT.ID = EVENTAUCTION.ID
                        where
                            EVENT.ID = @COPYFROMEVENTID;

                        set @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('EVENT', @CURRENTAPPUSERID);
                        set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

                        return 0;