USP_DATAFORMTEMPLATE_ADD_REGISTRATIONPACKAGE_PRELOAD

The load procedure used by the edit dataform template "Registration Package Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@MAINEVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@PRICESDISPLAY	xml	INOUT
@MAINEVENTBASECURRENCYID	uniqueidentifier	INOUT	Main event currency ID

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_REGISTRATIONPACKAGE_PRELOAD
                    (
                        @MAINEVENTID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @PRICESDISPLAY xml = null output,
                        @MAINEVENTBASECURRENCYID uniqueidentifier = null output
                    )
                    as                    
                        set nocount on;

                        select
                            @MAINEVENTBASECURRENCYID = EVENT.BASECURRENCYID
                        from
                            dbo.EVENT
                        where
                            EVENT.ID = @MAINEVENTID;

                        create table #CHILDEVENTSWITHSITEACCESS (ID uniqueidentifier, [NAME] nvarchar(100));
                        insert into #CHILDEVENTSWITHSITEACCESS select ID, [NAME] from dbo.UFN_CHILDEVENTSWITHSITEACCESS(@MAINEVENTID, @CURRENTAPPUSERID);

                        set @PRICESDISPLAY = 
                            (
                                select
                                    null [ID],
                                    EVENTPRICE.ID [EVENTPRICEID],
                                    0 [SEQUENCE],
                                    0 [INCLUDE],
                                    EVENTPRICE.NAME [EVENTPRICENAME],
                                    EVENTPRICE.AMOUNT,
                                    EVENTPRICE.RECEIPTAMOUNT,
                                    [EVENT].BASECURRENCYID,
                                    EVENTPRICE.REGISTRATIONCOUNT,
                                    EVENTPRICE.EVENTID,
                                    [EVENTS].NAME [EVENTNAME],
                  EVENTHIERARCHY.HIERARCHYPATH.GetLevel() EVENTLEVEL
                                from 
                                    dbo.EVENTPRICE                         
                                    inner join #CHILDEVENTSWITHSITEACCESS [EVENTS] on [EVENTS].ID = EVENTPRICE.EVENTID
                                    inner join dbo.EVENTREGISTRATIONTYPE on EVENTREGISTRATIONTYPE.ID = EVENTPRICE.EVENTREGISTRATIONTYPEID
                                    inner join dbo.[EVENT] on EVENTPRICE.EVENTID = [EVENT].ID
                  inner join dbo.EVENTHIERARCHY on EVENTHIERARCHY.ID = EVENTPRICE.EVENTID
                                order by
                                    EVENTLEVEL, [EVENTS].NAME, EVENTREGISTRATIONTYPE.DESCRIPTION
                                for xml raw('ITEM'),type,elements,root('PRICESDISPLAY'),binary base64
                            );

                        drop table #CHILDEVENTSWITHSITEACCESS;
                        return 0;