USP_DATAFORMTEMPLATE_PRELOAD_ADD_ORGTOIND_CONTACTRELATIONSHIP

The load procedure used by the edit dataform template "Contact Relationship Organization to Individual Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTNAME	nvarchar(154)	INOUT
@ORGPRIMARYADDRESSID	uniqueidentifier	INOUT
@PRIMARY	bit	INOUT	Set as primary address
@COUNTRYID	uniqueidentifier	INOUT	Country
@SPOUSENAME	nvarchar(154)	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@CONSTITUENTTYPE	int	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_ORGTOIND_CONTACTRELATIONSHIP
                    ( 
                        @CONSTITUENTID uniqueidentifier,
                        @CONSTITUENTNAME nvarchar(154) = null output,
                        @ORGPRIMARYADDRESSID uniqueidentifier = null output,
                        @PRIMARY bit = null output,
                        @COUNTRYID uniqueidentifier = null output,
                        @SPOUSENAME nvarchar(154) = null output,
                        @VALIDATIONCOUNTRIES xml = null output,
                        @ZIPLOOKUPCOUNTRIES xml = null output,
                        @CONSTITUENTTYPE int = null output
                    )
                    as
                        set nocount on;

                        select
                            @CONSTITUENTNAME = CONSTITUENT.NAME,
                            @ORGPRIMARYADDRESSID = ADDRESS.ID
                        from
                            dbo.CONSTITUENT
                        left outer join
                            dbo.ADDRESS on CONSTITUENT.ID = ADDRESS.CONSTITUENTID and ADDRESS.ISPRIMARY = 1
                        where
                            CONSTITUENT.ID = @CONSTITUENTID;

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

                        set @CONSTITUENTTYPE = 1

                        return 0;