USP_MULTILEVELEVENT_ADD_PRELOAD

Loads the information required to add a multi-level event.
Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@SITEREQUIRED	bit	INOUT
@SITES	xml	INOUT
@ATTRIBUTEDEFINED	bit	INOUT
@EVENTHIERARCHY	xml	INOUT
@SOURCEEVENTID	uniqueidentifier	IN
@HASWEBFORMS	bit	INOUT
Definition

Copy


            CREATE procedure dbo.USP_MULTILEVELEVENT_ADD_PRELOAD
            (
                @CURRENTAPPUSERID uniqueidentifier,
                @SITEREQUIRED bit = null output,
                @SITES xml = null output,
                @ATTRIBUTEDEFINED bit = null output,
                @EVENTHIERARCHY xml = null output,
                @SOURCEEVENTID uniqueidentifier = null,
                @HASWEBFORMS bit = null output
            )
            as
            begin
                set @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('EVENT',@CURRENTAPPUSERID);
                set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

                declare @DEFAULTSITEID uniqueidentifier
                set @DEFAULTSITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)

                if @DEFAULTSITEID is not null
                    set @SITES = (select newID() as ID, @DEFAULTSITEID as SITEID for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64)

                if @SOURCEEVENTID is not null
                begin
                    set @EVENTHIERARCHY = (
                        select 
                            ID,
                            NAME,
                            DESCRIPTION,    
                            STARTDATE,
                            STARTTIME,
                            ENDDATE,
                            ENDTIME,
                            CAPACITY,
                            EVENTLOCATIONID,
                            EVENTLOCATIONROOMID,
                            EVENTLOCATIONCONTACTID,
                            dbo.UFN_EVENT_GETSITES_TOITEMLISTXML(@SOURCEEVENTID),
                            EVENTCATEGORYCODEID,
                            APPEALID,
                            1 as DISPLAYORDER,
                            0 as ISAUCTION,
                            HIDEFROMCALENDAR,
                            DESIGNATIONSONFEES
                        from dbo.EVENT
                        where ID = @SOURCEEVENTID
                        for xml raw('ITEM'),type,elements,root('EVENTHIERARCHY'),BINARY BASE64)

                    if exists (select 1 from dbo.[MICROSITEPAGE] where MICROSITEPAGE.OBJECTID = @SOURCEEVENTID and MICROSITEPAGE.EXCLUDED = 0)
                        set @HASWEBFORMS = 1
                end

                if @HASWEBFORMS is null
                    set @HASWEBFORMS = 0

                return 0;
            end