USP_DATAFORMTEMPLATE_VIEW_STUDENTPROFILEINTERACTION

The load procedure used by the view dataform template "Student Summary Profile View Interaction Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ISCONSTITUENTPROFILE	bit	INOUT	ISCONSTITUENTPROFILE
@ADDRESS	nvarchar(300)	INOUT	ADDRESS
@PHONENUMBER	nvarchar(100)	INOUT	PHONENUMBER
@PHONETYPE	nvarchar(100)	INOUT	PHONETYPE
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	EMAILADDRESS
@DONOTMAIL	bit	INOUT	DONOTMAIL
@DONOTEMAIL	bit	INOUT	DONOTEMAIL
@DONOTPHONE	bit	INOUT	DONOTPHONE
@WEBADDRESS	UDT_WEBADDRESS	INOUT	WEBADDRESS
@ISINACTIVE	bit	INOUT	ISINACTIVE
@PICTURE	varbinary	INOUT	PICTURE
@LOOKUPID	nvarchar(100)	INOUT	Lookup ID
@DECEASEDDATE	UDT_FUZZYDATE	INOUT	DECEASEDDATE

Definition

Copy



            create  procedure [dbo].[USP_DATAFORMTEMPLATE_VIEW_STUDENTPROFILEINTERACTION]

                @ID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier=null,
                @DATALOADED bit = 0 output,
                @ISCONSTITUENTPROFILE bit = null output,
                @ADDRESS nvarchar(300) = null output,
                @PHONENUMBER nvarchar(100) = null output,
                @PHONETYPE nvarchar(100) = null output,
                @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
                @DONOTMAIL bit = null output,
                @DONOTEMAIL bit = null output,
                @DONOTPHONE bit = null output,
                @WEBADDRESS dbo.UDT_WEBADDRESS = null output,
                @ISINACTIVE bit = null output,
                @PICTURE varbinary(max) = null output,
                @LOOKUPID nvarchar(100) = null output,
                @DECEASEDDATE dbo.UDT_FUZZYDATE = null output
     as
                set nocount on;

                set @DATALOADED = 0;

                Declare @CONSTITUENTID as uniqueidentifier

                select @CONSTITUENTID = CONSTITUENTID from dbo.INTERACTION where ID = @ID

                --CONSTIT FIELDS

                select
                    @DATALOADED = 1,
                    @WEBADDRESS = CONSTITUENT.WEBADDRESS,
                    @PICTURE = CONSTITUENT.PICTURETHUMBNAIL,
                    @ISINACTIVE = CONSTITUENT.ISINACTIVE,
                    @DONOTMAIL = CONSTITUENT.DONOTMAIL,
                    @DONOTEMAIL = CONSTITUENT.DONOTEMAIL,
                    @DONOTPHONE = CONSTITUENT.DONOTPHONE,
                    @LOOKUPID = CONSTITUENT.LOOKUPID,
                    @ISCONSTITUENTPROFILE = 1
                from
                    dbo.CONSTITUENT
                where
                    CONSTITUENT.ID = @CONSTITUENTID;

                --EMAIL

                SELECT @EMAILADDRESS = EMAILADDRESS
                FROM dbo.EMAILADDRESS
                WHERE
                EMAILADDRESS.CONSTITUENTID = @CONSTITUENTID and
                EMAILADDRESS.ISPRIMARY = 1;

                --PHONE

                SELECT
                @PHONENUMBER = PHONE.NUMBER,
                @PHONETYPE = (select DESCRIPTION FROM dbo.PHONETYPECODE WHERE ID = PHONE.PHONETYPECODEID)
                FROM dbo.PHONE
                WHERE 
                PHONE.CONSTITUENTID = @CONSTITUENTID and
                PHONE.ISPRIMARY = 1;

                --ADDRESS

                select 
                    @ADDRESS = dbo.UFN_BUILDFULLADDRESS(ADDRESS.ID, ADDRESS.ADDRESSBLOCK, ADDRESS.CITY, ADDRESS.STATEID, ADDRESS.POSTCODE, ADDRESS.COUNTRYID)
                from
                    dbo.ADDRESS
                where
                    ADDRESS.CONSTITUENTID = @CONSTITUENTID and
                    ADDRESS.ISPRIMARY = 1;

                --DECEASED

                SELECT 
                @DECEASEDDATE=DECEASEDDATE
                FROM
                dbo.DECEASEDCONSTITUENT
                WHERE ID=@CONSTITUENTID;

                return 0;