USP_DATAFORMTEMPLATE_ADD_EMAIL_COPYTOHOUSEHOLD_PRELOAD

The load procedure used by the edit dataform template "Email Copy To Household 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_COPYTOHOUSEHOLD_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, 
              @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 top 1
              @CONSTITUENTID = CONSTITUENTHOUSEHOLD.HOUSEHOLDID
            from dbo.EMAILADDRESS
            left join dbo.CONSTITUENTHOUSEHOLD on CONSTITUENTHOUSEHOLD.ID = EMAILADDRESS.CONSTITUENTID
            left join dbo.CONSTITUENT on CONSTITUENTHOUSEHOLD.HOUSEHOLDID = CONSTITUENT.ID
            where 
              EMAILADDRESS.ID = @EMAILADDRESSID and
              CONSTITUENT.ISINACTIVE = 0;

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

            return 0;