USP_DATAFORMTEMPLATE_ADD_ADDRESS_2_PRELOAD

The load procedure used by the edit dataform template "Address Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PRIMARY	bit	INOUT	Set as primary address
@COUNTRYID	uniqueidentifier	INOUT	Country
@SPOUSENAME	nvarchar(154)	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@ISHOUSEHOLD	bit	INOUT
@ISHOUSEHOLDMEMBER	bit	INOUT
@FORCEDPRIMARY	bit	INOUT
@CANEDITPRIMARY	bit	INOUT
@INVALIDFIELDS	nvarchar(256)	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ADDRESS_2_PRELOAD (
                        @CONSTITUENTID uniqueidentifier,
                        @PRIMARY bit = null output,
                        @COUNTRYID uniqueidentifier = null output,
                        @SPOUSENAME nvarchar(154) = null output,
                        @VALIDATIONCOUNTRIES xml = null output,
                        @ZIPLOOKUPCOUNTRIES xml = null output,
                        @ISHOUSEHOLD bit = null output,
                        @ISHOUSEHOLDMEMBER bit = null output,
                        @FORCEDPRIMARY bit = null output,            -- used by constituent data review

                        @CANEDITPRIMARY bit = null output,            -- used by constituent data review

                        @INVALIDFIELDS nvarchar(256) = null output    -- used by constituent data review

                    ) as 
                        exec dbo.USP_ADDRESS_CREATE_PRELOAD    @CONSTITUENTID,    @PRIMARY output, @COUNTRYID output,    @SPOUSENAME  output,
                            @VALIDATIONCOUNTRIES output, @ZIPLOOKUPCOUNTRIES output

                        declare @CURRENTDATE date;
                        set @CURRENTDATE = getdate();

                        set @ISHOUSEHOLD = dbo.UFN_CONSTITUENT_ISHOUSEHOLD(@CONSTITUENTID);
                        set @ISHOUSEHOLDMEMBER = case when exists (
                            select 1 
                            from dbo.GROUPMEMBER GM 
                            left outer join dbo.GROUPMEMBERDATERANGE GMDR on GMDR.GROUPMEMBERID = GM.ID
                            left outer join dbo.GROUPDATA GD on GD.ID = GM.GROUPID
                            where GM.MEMBERID = @CONSTITUENTID 
                            and GD.GROUPTYPECODE = 0
                            and ((GMDR.DATEFROM is null and (GMDR.DATETO is null or GMDR.DATETO > @CURRENTDATE))
                                or (GMDR.DATETO is null and (GMDR.DATEFROM is null or GMDR.DATEFROM <= @CURRENTDATE)) 
                                or (GMDR.DATEFROM <= @CURRENTDATE and GMDR.DATETO > @CURRENTDATE))
                        ) then 1 else 0 end;
                        return 0;