USP_DATAFORMTEMPLATE_ADD_EMAIL_COPYTOSPOUSE_PRELOAD

The load procedure used by the edit dataform template "Email Copy To Spouse Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@EMAILADDRESSID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTID	uniqueidentifier	INOUT	Spouse ID
@EMAILADDRESSTYPECODEID	uniqueidentifier	INOUT	Type
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@PRIMARY	bit	INOUT	Set as primary email address
@DONOTEMAIL	bit	INOUT	Do not send email to this address
@INFOSOURCECODEID	uniqueidentifier	INOUT	Information source
@INFOSOURCECOMMENTS	nvarchar(256)	INOUT	Comments
@CONSTITUENTDATAREVIEWROLLBACKREASONID	uniqueidentifier	INOUT	Reason
@FORCEDPRIMARY	bit	INOUT
@CANEDITPRIMARY	bit	INOUT
@INVALIDFIELDS	nvarchar(256)	INOUT
@STARTDATE	date	INOUT	Start date
@ENDDATE	date	INOUT	End date

Definition

Copy



                  CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EMAIL_COPYTOSPOUSE_PRELOAD (
                    @EMAILADDRESSID uniqueidentifier,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @EMAILADDRESSTYPECODEID uniqueidentifier = null output,
                    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
                    @PRIMARY bit = null output,
                    @DONOTEMAIL bit = null output,
                    @INFOSOURCECODEID uniqueidentifier = null output,
                    @INFOSOURCECOMMENTS nvarchar(256) = null output,
                    @CONSTITUENTDATAREVIEWROLLBACKREASONID uniqueidentifier = null output,    -- used by constituent data review

                    @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

                    @STARTDATE date = null output,
                    @ENDDATE date = null output
                )
                as
                    set nocount on;

                    exec dbo.USP_EMAILADDRESS_UPDATE_LOAD 
                      @EMAILADDRESSID, 
                      @EMAILADDRESSTYPECODEID = @EMAILADDRESSTYPECODEID output,
                      @EMAILADDRESS = @EMAILADDRESS output, 
                      @PRIMARY = @PRIMARY output, 
                      @DONOTEMAIL = @DONOTEMAIL output,
                      @INFOSOURCECODEID = @INFOSOURCECODEID output, 
                      @INFOSOURCECOMMENTS = @INFOSOURCECOMMENTS output,
                      @STARTDATE = @STARTDATE output,
                      @ENDDATE = @ENDDATE output;

                    declare @CURRENTDATE datetime;
                    set @CURRENTDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                    select 
                      @CONSTITUENTID = SPOUSE.ID
                    from dbo.EMAILADDRESS
                    inner join dbo.CONSTITUENT on EMAILADDRESS.CONSTITUENTID = CONSTITUENT.ID
                    inner join dbo.RELATIONSHIP on CONSTITUENT.ID = RELATIONSHIP.RELATIONSHIPCONSTITUENTID
                    inner join dbo.CONSTITUENT SPOUSE on RELATIONSHIP.RECIPROCALCONSTITUENTID = SPOUSE.ID
                    where
                      EMAILADDRESS.ID = @EMAILADDRESSID and
                      RELATIONSHIP.ISSPOUSE = 1;

                  if not exists(select ID from dbo.EMAILADDRESS where CONSTITUENTID = @CONSTITUENTID and ISPRIMARY = 1)
                  begin
                    set @PRIMARY = 1;
                  end

                    return 0;