USP_DATAFORMTEMPLATE_VIEW_REGISTRANTPAGEEXPRESSION

The load procedure used by the view dataform template "Registrant Page Expression View 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.
@CONSTITUENTNAME	nvarchar(700)	INOUT	Name
@CONSTITUENTID	uniqueidentifier	INOUT	CONSTITUENTID
@ISGUEST	bit	INOUT	ISGUEST
@ISUNKNOWNGUEST	bit	INOUT	ISUNKNOWNGUEST
@GUESTOFREGISTRANTID	uniqueidentifier	INOUT	GUESTOFREGISTRANTID
@GUESTOFREGISTRANTNAME	nvarchar(700)	INOUT	GUESTOFREGISTRANTNAME
@EVENTID	uniqueidentifier	INOUT	EVENTID
@EVENTNAME	nvarchar(100)	INOUT	EVENTNAME
@HASAPPEAL	bit	INOUT	HASAPPEAL
@ATTENDED	bit	INOUT	ATTENDED
@WILLNOTATTEND	bit	INOUT	WILLNOTATTEND
@ATTRIBUTEDEFINED	bit	INOUT	ATTRIBUTEDEFINED
@SMARTFIELDDEFINED	bit	INOUT	SMARTFIELDDEFINED
@BENEFITSWAIVED	bit	INOUT	BENEFITSWAIVED
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REGISTRANTPAGEEXPRESSION
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CONSTITUENTNAME nvarchar(700) = null output,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @ISGUEST bit = null output,
                    @ISUNKNOWNGUEST bit = null output,
                    @GUESTOFREGISTRANTID uniqueidentifier = null output,
                    @GUESTOFREGISTRANTNAME nvarchar(700) = null output,
                    @EVENTID uniqueidentifier = null output,
                    @EVENTNAME nvarchar(100) = null output,
                    @HASAPPEAL bit = null output,
                    @ATTENDED bit = null output,
                    @WILLNOTATTEND bit = null output,
                    @ATTRIBUTEDEFINED bit = null output,
                    @SMARTFIELDDEFINED bit = null output,
                    @BENEFITSWAIVED bit = null output,
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @CONSTITUENTNAME = dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID),
                        @CONSTITUENTID = REGISTRANT.CONSTITUENTID,
                        @ISGUEST = case when REGISTRANT.GUESTOFREGISTRANTID is null then 0 else 1 end,
                        @ISUNKNOWNGUEST = case when REGISTRANT.CONSTITUENTID is null then 1 else 0 end,
                        @GUESTOFREGISTRANTID = REGISTRANT.GUESTOFREGISTRANTID,
                        @GUESTOFREGISTRANTNAME = GUESTOF_NF.NAME,
                        @EVENTID = REGISTRANT.EVENTID,
                        @EVENTNAME = EVENT.NAME,
                        @HASAPPEAL = case when EVENT.APPEALID is null then 0 else 1 end,
                        @ATTENDED = REGISTRANT.ATTENDED,
                        @WILLNOTATTEND = REGISTRANT.WILLNOTATTEND,
                        @ATTRIBUTEDEFINED = dbo.UFN_ATTRIBUTECATEGORY_DEFINEDFORRECORDTYPE_FORAPPUSER('REGISTRANT',@CURRENTAPPUSERID),
                        @SMARTFIELDDEFINED = dbo.UFN_SMARTFIELD_DEFINEDFORRECORDTYPE('REGISTRANT'),
                        @BENEFITSWAIVED = REGISTRANT.BENEFITSWAIVED
                    from
                        dbo.REGISTRANT
                        left join dbo.EVENT on REGISTRANT.EVENTID = EVENT.ID
                        left join dbo.CONSTITUENT on REGISTRANT.CONSTITUENTID = CONSTITUENT.ID
                        left join dbo.ADDRESS on ADDRESS.CONSTITUENTID = CONSTITUENT.ID and ADDRESS.ISPRIMARY = 1
                        left join dbo.PHONE on PHONE.CONSTITUENTID = CONSTITUENT.ID and PHONE.ISPRIMARY = 1
                        left join dbo.EMAILADDRESS on EMAILADDRESS.CONSTITUENTID = CONSTITUENT.ID and EMAILADDRESS.ISPRIMARY = 1
                        left join dbo.REGISTRANT as GUESTOF on GUESTOF.ID = REGISTRANT.GUESTOFREGISTRANTID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(GUESTOF.CONSTITUENTID) GUESTOF_NF
                    where 
                        REGISTRANT.ID = @ID;

                return 0;