USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDATAREVIEW_EMAILADDRESS_1

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN
@EMAILADDRESS	UDT_EMAILADDRESS	IN
@PRIMARY	bit	IN
@DONOTEMAIL	bit	IN
@UPDATEMATCHINGSPOUSEEMAILADDRESS	bit	IN
@UPDATEMATCHINGHOUSEHOLDEMAILADDRESS	bit	IN
@INFOSOURCECODEID	uniqueidentifier	IN
@INFOSOURCECOMMENTS	nvarchar(256)	IN
@CONSTITUENTDATAREVIEWROLLBACKREASONID	uniqueidentifier	IN
@STARTDATE	date	IN
@ENDDATE	date	IN
@EMAILISCONFIDENTIAL	bit	IN
@DONOTEMAILREASONCODEID	uniqueidentifier	IN

Definition

Copy


                create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTDATAREVIEW_EMAILADDRESS_1
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @EMAILADDRESSTYPECODEID uniqueidentifier,
                    @EMAILADDRESS dbo.UDT_EMAILADDRESS,
                    @PRIMARY bit,
                    @DONOTEMAIL bit,
                    @UPDATEMATCHINGSPOUSEEMAILADDRESS bit,
                    @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS bit,
                    @INFOSOURCECODEID uniqueidentifier,
                    @INFOSOURCECOMMENTS nvarchar(256),
                    @CONSTITUENTDATAREVIEWROLLBACKREASONID uniqueidentifier,
          @STARTDATE date,
          @ENDDATE date,
                    @EMAILISCONFIDENTIAL bit,
                    @DONOTEMAILREASONCODEID uniqueidentifier
                )
                as
                    declare @EMAILADDRESSID uniqueidentifier;

                    select @EMAILADDRESSID = AUDITRECORDID
                    from dbo.EMAILADDRESSAUDIT
                    where AUDITID = @ID;

                    if @EMAILADDRESSID is null
                        raiserror('ERR_COULDNOTFINDAUDIT', 13, 1);

                    exec dbo.USP_DATAFORMTEMPLATE_EDIT_EMAILADDRESS_6
                        @EMAILADDRESSID, @CHANGEAGENTID, @EMAILADDRESSTYPECODEID, @EMAILADDRESS, @PRIMARY,
                        @DONOTEMAIL, @UPDATEMATCHINGSPOUSEEMAILADDRESS,
                        @UPDATEMATCHINGHOUSEHOLDEMAILADDRESS, @INFOSOURCECODEID,
                        @INFOSOURCECOMMENTS, null, @STARTDATE = @STARTDATE, @ENDDATE = @ENDDATE,
                            @EMAILISCONFIDENTIAL = @EMAILISCONFIDENTIAL,
                        @DONOTEMAILREASONCODEID = @DONOTEMAILREASONCODEID;

                    declare @COUNT tinyint;
                    select @COUNT = count(*)
                    from dbo.EMAILADDRESS
                    where ID = @EMAILADDRESSID;

                    if @COUNT = 0
                        raiserror('ERR_RECORDDELETED', 13, 1);

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    declare @EDITAUDITID uniqueidentifier;

                    -- pull the auditid for what is hopefully the edit we just did
                    select top 1 @EDITAUDITID = AUDITID
                    from dbo.EMAILADDRESSAUDIT
                    where AUDITRECORDID = @EMAILADDRESSID
                    and AUDITTYPECODE = 1
                    order by AUDITDATE desc;

                    if @EDITAUDITID is null
                        raiserror('ERR_COULDNOTFINDEDITAUDIT', 13, 1);

                    insert into dbo.CONSTITUENTDATAREVIEWROLLBACK
                        (ID, CONTEXTRECORDID, ROLLBACKAUDITID, SOURCEAUDITID, CONSTITUENTDATAREVIEWROLLBACKREASONID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values
                        (newid(), @EMAILADDRESSID, @EDITAUDITID, @ID, @CONSTITUENTDATAREVIEWROLLBACKREASONID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)