USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTADDRESS

The load procedure used by the view dataform template "Constituent Primary Address 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.
@HASADDRESS	bit	INOUT	HASADDRESS
@POSTCODE	nvarchar(20)	INOUT	Postcode
@ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@CITY	nvarchar(50)	INOUT	City
@STATEID	uniqueidentifier	INOUT	State
@COUNTRYID	uniqueidentifier	INOUT	Country
@ISUSADDRESS	bit	INOUT	ISUSADDRESS

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTADDRESS
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @HASADDRESS bit = null output,
                @POSTCODE nvarchar(20) = null output,
                @ADDRESSBLOCK nvarchar(150) = null output,
                @CITY nvarchar(50) = null output,
                @STATEID uniqueidentifier = null output,
                @COUNTRYID uniqueidentifier = null output,
                @ISUSADDRESS bit = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                declare @USCOUNTRYID uniqueidentifier = (select top(1) ID from dbo.COUNTRY where DESCRIPTION like '%united%state%')

                select 
                    @DATALOADED = 1,
                    @HASADDRESS = 1,
                    @POSTCODE = POSTCODE,
                    @ADDRESSBLOCK = ADDRESSBLOCK,
                    @CITY = CITY,
                    @STATEID = STATEID,
                    @COUNTRYID = COUNTRYID
                from dbo.ADDRESS
                where CONSTITUENTID = @ID
                and ISPRIMARY = 1

                if @COUNTRYID = @USCOUNTRYID set @ISUSADDRESS = 1
                else set @ISUSADDRESS = 0


                return 0;