USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTCREDITCARDPROCESSIGNADDRESS

The load procedure used by the view dataform template "Constituent Credit Card Processing Address View From"

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.
@ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@CITY	nvarchar(50)	INOUT	City
@STATE	nvarchar(2)	INOUT	State
@POSTCODE	nvarchar(12)	INOUT	Post code
@COUNTRY	nvarchar(2)	INOUT	Country
@EMAIL	UDT_EMAILADDRESS	INOUT	Email address
@PHONE	nvarchar(100)	INOUT	Phone

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTCREDITCARDPROCESSIGNADDRESS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @ADDRESSBLOCK nvarchar(150) = null output,
                    @CITY nvarchar(50) = null output,
                    @STATE nvarchar(2) = null output,
                    @POSTCODE nvarchar(12) = null output,
                    @COUNTRY nvarchar(2) = null output,
                    @EMAIL UDT_EMAILADDRESS = null output,
                    @PHONE nvarchar(100) = null output
                )
                as
                    set nocount on;

                    -- be sure to set this, in case the select returns no rows
                    set @DATALOADED = 0;

                    select top 1 
                        @DATALOADED = 1,
                        @ADDRESSBLOCK = ADDRESSBLOCK,
                        @CITY = CITY,
                        @STATE = STATE.ABBREVIATION,
                        @POSTCODE = POSTCODE,
                        @COUNTRY = COUNTRY.ISO3166,
                        @EMAIL = (select EMAILADDRESS from dbo.EMAILADDRESS where CONSTITUENTID = @ID and ISPRIMARY = 1),
                        @PHONE = (select NUMBER from dbo.PHONE where CONSTITUENTID = @ID and ISPRIMARY = 1)
                    from dbo.ADDRESS
                    left join dbo.STATE on ADDRESS.STATEID = STATE.ID
                    inner join dbo.COUNTRY on ADDRESS.COUNTRYID = COUNTRY.ID
                    where 
                        ISPRIMARY = 1 and 
                        CONSTITUENTID = @ID;

                    return 0;