USP_DATAFORMTEMPLATE_EDITSAVE_EXCHANGEEMAILBATCHROW

Edit dataform template for Exchange Email batch records.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@ADDASINTERACTION	bit	IN	Add as interaction
@SEQUENCE	int	IN	Sequence
@SITES	xml	IN	Sites

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_EXCHANGEEMAILBATCHROW
            (
                @ID uniqueidentifier, 
                @CHANGEAGENTID uniqueidentifier,
                @ADDASINTERACTION bit,
                @SEQUENCE int,
                @SITES xml
            )
            as 
            set nocount on;

            declare @CHANGEDATE datetime

            if @ID is null
                set @ID = NewID();

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

            set @CHANGEDATE = getdate();

            declare @CONSTITUENTID uniqueidentifier = null;
            declare @USERID uniqueidentifier = null;
            declare @DATESENT datetime = null;
            declare @TIMESENT UDT_HOURMINUTE = null;
            declare @SUBJECT nvarchar(256) = null;
            declare @BODY nvarchar(max) = null;
            declare @INTERACTIONTYPECODEID uniqueidentifier = null;

            begin try
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGEEMAILBATCHROW        
                        @ID = @ID,
                        @CONSTITUENTID = @CONSTITUENTID output,
                        @USERID = @USERID output,                  
                        @DATESENT = @DATESENT output,
                        @TIMESENT = @TIMESENT output,
                        @SUBJECT = @SUBJECT output,   
                        @BODY = @BODY output,                  
                        @INTERACTIONTYPECODEID = @INTERACTIONTYPECODEID output;

                exec dbo.USP_DATAFORMTEMPLATE_EDITSAVE_EXCHANGEEMAILBATCHROW_2
                        @ID, 
                        @CHANGEAGENTID,
                        @ADDASINTERACTION,
                        @SEQUENCE,
                        @SITES,
                        @CONSTITUENTID,
                        @USERID,
                        @DATESENT,
                        @TIMESENT,
                        @SUBJECT, 
                        @BODY,                
                        @INTERACTIONTYPECODEID;

            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;