USP_EXCHANGECONTACTBATCH_ADDBATCHROW

Adds a new batch row to the Exchange contact batch update table.

Parameters

Parameter	Parameter Type	Mode
@BATCHID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@CHANGEDBYAPPUSERID	uniqueidentifier	IN
@BIOLOGICALINFORMATION	xml	IN
@PHONEINFORMATION	xml	IN
@HOMEADDRESSINFORMATION	xml	IN
@BUSINESSADDRESSINFORMATION	xml	IN
@OTHERADDRESSINFORMATION	xml	IN
@EMAILADDRESSINFORMATION	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@INFOSOURCECODEID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_EXCHANGECONTACTBATCH_ADDBATCHROW
            (
                @BATCHID uniqueidentifier = null,
                @CONSTITUENTID uniqueidentifier = null,
                @CHANGEDBYAPPUSERID uniqueidentifier = null,
                @BIOLOGICALINFORMATION xml = null,
                @PHONEINFORMATION xml = null,
                @HOMEADDRESSINFORMATION xml = null,
                @BUSINESSADDRESSINFORMATION xml = null,
                @OTHERADDRESSINFORMATION xml = null,
                @EMAILADDRESSINFORMATION xml = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @INFOSOURCECODEID uniqueidentifier = null
            )
            as            
                declare @CHANGEDATE datetime;
                set @CHANGEDATE = getdate();

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                declare @ID uniqueidentifier;
                set @ID = newid();

                declare @SEQUENCE int
                set @SEQUENCE = coalesce((select max(SEQUENCE) from dbo.EXCHANGECONTACTBATCH where BATCHID = @BATCHID),0) + 1;

                update 
                    dbo.EXCHANGECONTACTBATCH
                set
                    PROCESS = 0,
                    DATECHANGED = @CHANGEDATE,
                    CHANGEDBYID = @CHANGEAGENTID
                where
                    EXCHANGECONTACTBATCH.CONSTITUENTID = @CONSTITUENTID and
                    EXCHANGECONTACTBATCH.CHANGEDBYAPPUSERID = @CHANGEDBYAPPUSERID and
                    EXCHANGECONTACTBATCH.BATCHID = @BATCHID;

                insert into dbo.EXCHANGECONTACTBATCH
                    (ID, PROCESS, BATCHID, CONSTITUENTID, CHANGEDBYAPPUSERID, SEQUENCE, BIOLOGICALINFORMATION, PHONEINFORMATION, HOMEADDRESSINFORMATION, BUSINESSADDRESSINFORMATION, OTHERADDRESSINFORMATION, EMAILADDRESSINFORMATION, INFOSOURCECODEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values
                    (@ID, 1, @BATCHID, @CONSTITUENTID, @CHANGEDBYAPPUSERID, @SEQUENCE, @BIOLOGICALINFORMATION, @PHONEINFORMATION, @HOMEADDRESSINFORMATION, @BUSINESSADDRESSINFORMATION, @OTHERADDRESSINFORMATION, @EMAILADDRESSINFORMATION, @INFOSOURCECODEID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)