USP_DATAFORMTEMPLATE_ADD_EXCHANGEDOWNLOADPROCESS

The save procedure used by the add dataform template "Exchange Download Process Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@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
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DEFAULTINFOSOURCECODEID	uniqueidentifier	IN	Default source

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EXCHANGEDOWNLOADPROCESS
                    (
                        @ID uniqueidentifier output,
                        @CHANGEAGENTID uniqueidentifier,
                        @EXCLUDEPERSONAL bit = 0,
                        @EXCLUDEPRIVATE bit = 0,
                        @EXCLUDECONFIDENTIAL bit = 0,
                        @EXCLUDEAUTOREPLY bit = 1,
                        @CONTACTBATCHASSIGNMENTS xml = null,
                        @CONTACTBATCHAPPUSERID uniqueidentifier = null,
                        @EMAILBATCHASSIGNMENTS xml = null,
                        @EMAILBATCHAPPUSERID uniqueidentifier = null,
                        @CALENDARITEMBATCHASSIGNMENTS xml = null,
                        @CALENDARITEMBATCHAPPUSERID uniqueidentifier = null,                     
                        @MAXEMAILBATCHROWCOUNT int = 100,
                        @MAXCONTACTBATCHROWCOUNT int = 100,
                        @MAXCALENDARITEMBATCHROWCOUNT int = 100,                                          
                        @DEFAULTCOUNTRYID uniqueidentifier = null,
                        @DEFAULTINTERACTIONTYPECODEID uniqueidentifier = null,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @DEFAULTINFOSOURCECODEID uniqueidentifier = null
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime                                        

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

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

                        set @CURRENTDATE = getdate()

                        begin try
                            insert into dbo.EXCHANGEDOWNLOADPROCESS
                                (ID, NAME, EXCLUDEPERSONAL, EXCLUDEPRIVATE, EXCLUDECONFIDENTIAL, EXCLUDEAUTOREPLY, CONTACTBATCHAPPUSERID, EMAILBATCHAPPUSERID, CALENDARITEMBATCHAPPUSERID, MAXEMAILBATCHROWCOUNT, MAXCONTACTBATCHROWCOUNT, MAXCALENDARITEMBATCHROWCOUNT, DEFAULTCOUNTRYID, DATEADDED, DATECHANGED, ADDEDBYID, CHANGEDBYID, DEFAULTINTERACTIONTYPECODEID, DEFAULTINFOSOURCECODEID)
                            values
                                (@ID, 'Exchange download process', @EXCLUDEPERSONAL, @EXCLUDEPRIVATE, @EXCLUDECONFIDENTIAL, @EXCLUDEAUTOREPLY, @CONTACTBATCHAPPUSERID, @EMAILBATCHAPPUSERID, @CALENDARITEMBATCHAPPUSERID, @MAXEMAILBATCHROWCOUNT, @MAXCONTACTBATCHROWCOUNT, @MAXCALENDARITEMBATCHROWCOUNT, @DEFAULTCOUNTRYID, @CURRENTDATE, @CURRENTDATE, @CHANGEAGENTID, @CHANGEAGENTID, @DEFAULTINTERACTIONTYPECODEID, @DEFAULTINFOSOURCECODEID)

                            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;                                                 

                            exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD 
                                @CHANGEAGENTID = @CHANGEAGENTID, 
                                @BUSINESSPROCESSCATALOGID = '60C090D3-5A0E-49E9-8CFB-8C89719B5281', 
                                @BUSINESSPROCESSPARAMETERSETID = @ID, 
                                @OWNERID = @CURRENTAPPUSERID;
                        end try

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

                        return 0;