USP_EXCHANGEEMAILBATCH_ADDBATCHROW

Adds a new batch row to the exchange email batch table.

Parameters

Parameter	Parameter Type	Mode
@BATCHID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@USERID	uniqueidentifier	IN
@INTERACTIONTYPECODEID	uniqueidentifier	IN
@DATESENT	datetime	IN
@SUBJECT	nvarchar(256)	IN
@BODY	nvarchar(max)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure [dbo].[USP_EXCHANGEEMAILBATCH_ADDBATCHROW]
            (
                @BATCHID uniqueidentifier = null,
                @CONSTITUENTID uniqueidentifier = null,
                @USERID uniqueidentifier = null,
                @INTERACTIONTYPECODEID uniqueidentifier = null,
                @DATESENT datetime = null,
                @SUBJECT nvarchar(256) = null,
                @BODY nvarchar(max) = null,
                @CHANGEAGENTID uniqueidentifier = null
            )
            as        
                declare @TIME UDT_HOURMINUTE;
                declare @CHANGEDATE datetime;
                set @CHANGEDATE = getdate();

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

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

                set @TIME = dbo.UFN_EXCHANGEINTEGRATION_GETTIMEFROMDATE(@DATESENT);

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

                insert into dbo.EXCHANGEEMAILBATCH
                    (ID, BATCHID, CONSTITUENTID, USERID, SEQUENCE, INTERACTIONTYPECODEID, DATESENT, TIMESENT, SUBJECT, BODY, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values
                    (@ID, @BATCHID, @CONSTITUENTID, @USERID, @SEQUENCE, @INTERACTIONTYPECODEID, @DATESENT, @TIME, case when len(@SUBJECT) > 0 then @SUBJECT else '<no subject>' end, COALESCE(@BODY,''), @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE)