USP_DATAFORMTEMPLATE_VIEW_PREREGISTEREDPROGRAMEVENTREGISTRANTMOBILE

The load procedure used by the view dataform template "Preregistered Program Event Registrant Mobile View Data 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.
@EVENTID	uniqueidentifier	INOUT	Event
@ATTENDED	bit	INOUT	Attended
@ISCANCELLED	bit	INOUT	Cancelled
@ORDERNUMBER	int	INOUT	Order
@BALANCE	money	INOUT	Balance
@PREFERENCES	nvarchar(255)	INOUT	Preferences
@RESTRICTIONS	nvarchar(255)	INOUT	Restrictions
@NOTES	nvarchar(255)	INOUT	Notes
@ISUNNAMEDGUEST	bit	INOUT	Is unnamed guest
@CONSTITUENTID	uniqueidentifier	INOUT	ConstituentID
@ISWALKIN	bit	INOUT
@USERMARKEDATTENDANCE	bit	INOUT
@SPECIALEVENTHOSTCANCELLED	bit	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PREREGISTEREDPROGRAMEVENTREGISTRANTMOBILE
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @EVENTID uniqueidentifier = null output,
                @ATTENDED bit = null output,
                @ISCANCELLED bit = null output,
                @ORDERNUMBER int = null output,
                @BALANCE money = null output,
                @PREFERENCES nvarchar(255) = null output,
                @RESTRICTIONS nvarchar(255) = null output,
                @NOTES nvarchar(255) = null output,
                @ISUNNAMEDGUEST bit = null output,
                @CONSTITUENTID uniqueidentifier = null output,
                @ISWALKIN bit = null output,
                @USERMARKEDATTENDANCE bit = null output,
                @SPECIALEVENTHOSTCANCELLED bit = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select 
                    @DATALOADED = 1,
                    @EVENTID = REGISTRANT.EVENTID,
                    @ATTENDED = REGISTRANT.ATTENDED,
                    @ISCANCELLED = REGISTRANT.ISCANCELLED,
                    @ORDERNUMBER = SALESORDER.SEQUENCEID,
                    @BALANCE = REGISTRANT_BALANCE.BALANCEINCURRENCY,
                    @PREFERENCES = 
                        coalesce((
                            select dbo.UDA_BUILDLIST(EVENTPREFERENCE.NAME) 
                            from dbo.EVENTPREFERENCE
                            inner join dbo.REGISTRANTPREFERENCE on
                                EVENTPREFERENCE.ID = REGISTRANTPREFERENCE.EVENTPREFERENCEID
                            where
                                REGISTRANTPREFERENCE.REGISTRANTID = REGISTRANT.ID
                        ),''),
                    @RESTRICTIONS = 
                        coalesce((
                            select dbo.UDA_BUILDLIST(RESTRICTION.NAME) from 
                            (    
                                select EVENTRESTRICTIONOPTION.NAME
                                from dbo.EVENTRESTRICTIONOPTION
                                inner join dbo.CONSTITUENTRESTRICTIONOPTION 
                                    on CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID = EVENTRESTRICTIONOPTION.ID
                                where CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID = REGISTRANT.CONSTITUENTID
                            ) as [RESTRICTION]
                        ),''),
                    @NOTES = REGISTRANT.NOTES,
                    @ISUNNAMEDGUEST = case
                        when REGISTRANT.CONSTITUENTID is null then 1
                        else 0
                    end,
                    @CONSTITUENTID = REGISTRANT.CONSTITUENTID,
                    @ISWALKIN = REGISTRANT.ISWALKIN,
                    @USERMARKEDATTENDANCE = REGISTRANT.USERMARKEDATTENDANCE,
                    @SPECIALEVENTHOSTCANCELLED = coalesce((
                                                            select
                                                                ISCANCELLED
                                                            from dbo.REGISTRANT as REG
                                                            inner join dbo.EVENT on
                                                                EVENT.ID = REG.EVENTID
                                                            where
                                                                REG.ID = REGISTRANT.GUESTOFREGISTRANTID
                                                                and EVENT.PROGRAMID is null
                                                           ), 0)

                from dbo.REGISTRANT
                left join UFN_EVENTREGISTRANT_GETBALANCEINCURRENCY_BULK((select ID from CURRENCY where ISORGANIZATIONCURRENCY = 1)) as REGISTRANT_BALANCE on
                    REGISTRANT.ID = REGISTRANT_BALANCE.ID
                left join dbo.SALESORDERITEMTICKETREGISTRANT on 
                    REGISTRANT.ID = SALESORDERITEMTICKETREGISTRANT.REGISTRANTID
                left join dbo.SALESORDERITEM on 
                    SALESORDERITEMTICKETREGISTRANT.SALESORDERITEMTICKETID = SALESORDERITEM.ID
                left join dbo.SALESORDER on 
                    SALESORDERITEM.SALESORDERID = SALESORDER.ID
                where 
                    REGISTRANT.ID = @ID

                return 0;