USP_DATAFORMTEMPLATE_EDIT_EXCHANGEDOWNLOADPROCESS_2

The save procedure used by the edit dataform template "Exchange Download Process Edit Form".

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.
@EXCLUDEPERSONAL	bit	IN	Exclude email messages marked as personal
@EXCLUDEPRIVATE	bit	IN	Exclude email messages marked as private
@EXCLUDECONFIDENTIAL	bit	IN	Exclude email messages marked as confidential
@EXCLUDEAUTOREPLY	bit	IN	Exclude auto-reply email messages
@CONTACTBATCHASSIGNMENTS	xml	IN
@CONTACTBATCHAPPUSERID	uniqueidentifier	IN	Default owner
@EMAILBATCHASSIGNMENTS	xml	IN
@EMAILBATCHAPPUSERID	uniqueidentifier	IN	Default owner
@CALENDARITEMBATCHASSIGNMENTS	xml	IN
@CALENDARITEMBATCHAPPUSERID	uniqueidentifier	IN	Default owner
@MAXEMAILBATCHROWCOUNT	int	IN	Maximum number of records per batch
@MAXCONTACTBATCHROWCOUNT	int	IN	Maximum number of records per batch
@MAXCALENDARITEMBATCHROWCOUNT	int	IN	Maximum number of records per batch
@DEFAULTCOUNTRYID	uniqueidentifier	IN	Default country
@DEFAULTINTERACTIONTYPECODEID	uniqueidentifier	IN	Default interaction type
@DEFAULTINFOSOURCECODEID	uniqueidentifier	IN	Default source

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EXCHANGEDOWNLOADPROCESS_2
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @EXCLUDEPERSONAL bit,
                        @EXCLUDEPRIVATE bit,
                        @EXCLUDECONFIDENTIAL bit,
                        @EXCLUDEAUTOREPLY bit,
                        @CONTACTBATCHASSIGNMENTS xml,
                        @CONTACTBATCHAPPUSERID uniqueidentifier,
                        @EMAILBATCHASSIGNMENTS xml,
                        @EMAILBATCHAPPUSERID uniqueidentifier,
                        @CALENDARITEMBATCHASSIGNMENTS xml,
                        @CALENDARITEMBATCHAPPUSERID uniqueidentifier,
                        @MAXEMAILBATCHROWCOUNT int,
                        @MAXCONTACTBATCHROWCOUNT int,
                        @MAXCALENDARITEMBATCHROWCOUNT int,                                          
                        @DEFAULTCOUNTRYID uniqueidentifier,
                        @DEFAULTINTERACTIONTYPECODEID uniqueidentifier,
                        @DEFAULTINFOSOURCECODEID uniqueidentifier
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime                                        

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

                        set @CURRENTDATE = getdate()

                        begin try
                            update
                                dbo.EXCHANGEDOWNLOADPROCESS
                            set
                                EXCLUDEPERSONAL = @EXCLUDEPERSONAL,
                                EXCLUDEPRIVATE = @EXCLUDEPRIVATE,
                                EXCLUDECONFIDENTIAL = @EXCLUDECONFIDENTIAL,
                                EXCLUDEAUTOREPLY  = @EXCLUDEAUTOREPLY,
                                DATECHANGED = @CURRENTDATE, 
                                CHANGEDBYID = @CHANGEAGENTID,
                                CONTACTBATCHAPPUSERID = @CONTACTBATCHAPPUSERID,
                                EMAILBATCHAPPUSERID = @EMAILBATCHAPPUSERID,
                                CALENDARITEMBATCHAPPUSERID = @CALENDARITEMBATCHAPPUSERID,                                                        
                                MAXEMAILBATCHROWCOUNT = @MAXEMAILBATCHROWCOUNT, 
                                MAXCONTACTBATCHROWCOUNT = @MAXCONTACTBATCHROWCOUNT,
                                MAXCALENDARITEMBATCHROWCOUNT = @MAXCALENDARITEMBATCHROWCOUNT,                                                        
                                DEFAULTCOUNTRYID = @DEFAULTCOUNTRYID,
                                DEFAULTINTERACTIONTYPECODEID = @DEFAULTINTERACTIONTYPECODEID,
                                DEFAULTINFOSOURCECODEID = @DEFAULTINFOSOURCECODEID
                            where
                                EXCHANGEDOWNLOADPROCESS.ID = @ID;        

                            exec dbo.USP_EXCHANGEEMAILBATCHASSIGNMENT_GETASSIGNMENTS_UPDATEFROMXML @ID, @EMAILBATCHASSIGNMENTS, @CHANGEAGENTID;
                            exec dbo.USP_EXCHANGECONTACTBATCHASSIGNMENT_GETASSIGNMENTS_UPDATEFROMXML @ID, @CONTACTBATCHASSIGNMENTS, @CHANGEAGENTID;
                            exec dbo.USP_EXCHANGECALENDARITEMBATCHASSIGNMENT_GETASSIGNMENTS_UPDATEFROMXML @ID, @CALENDARITEMBATCHASSIGNMENTS, @CHANGEAGENTID;                                                 
                        end try

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

                        return 0;