USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECALENDARSYNC

The load procedure used by the edit dataform template "Exchange Calendar Synchronization Process Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(250)	INOUT	Description
@APPUSERIDSETREGISTERID	uniqueidentifier	INOUT	Selection
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@APPUSERRECORDTYPEID	uniqueidentifier	INOUT
@APPLYTOCODE	tinyint	INOUT	Apply to
@CREATEITEMOPTIONCODE	tinyint	INOUT
@INTERACTIONFILTERCODE	tinyint	INOUT	Create for
@EXPECTEDDATEINTERVALCODE	tinyint	INOUT
@SPECIFICAPPUSERID	uniqueidentifier	INOUT	User
@PAGEDEFINITIONCATALOGID	uniqueidentifier	INOUT	Add link to
@DEFAULTREMINDERAMOUNT	int	INOUT	Reminder

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECALENDARSYNC
                        (
                            @ID uniqueidentifier,
                            @DATALOADED bit = 0 output,
                            @NAME nvarchar(100) = null output,
                            @DESCRIPTION nvarchar(250) = null output,
                            @APPUSERIDSETREGISTERID uniqueidentifier = null output,
                            @TSLONG bigint = 0 output,
                            @APPUSERRECORDTYPEID uniqueidentifier = null output,
                            @APPLYTOCODE tinyint = null output,
                            @CREATEITEMOPTIONCODE tinyint = null output,                                                 
                            @INTERACTIONFILTERCODE tinyint = null output,
                            @EXPECTEDDATEINTERVALCODE tinyint = null output,                                                 
                            @SPECIFICAPPUSERID uniqueidentifier = null output,
                            @PAGEDEFINITIONCATALOGID uniqueidentifier = null output,
                            @DEFAULTREMINDERAMOUNT int = null output
                        )
                        as
                        begin
                            set nocount on;                                                        

                            -- Stewardship Phase II Breaking change

                            --    Translate InteractionFilterCode into new filter bits

                            declare @INCLUDEPENDINGINTERACTIONS bit;
                            declare @INCLUDEPROSPECTPLANSTEPS bit;
                            declare @INCLUDEPENDINGSTEWARDSHIPSTEPS bit;

                            begin try
                                select
                                    @NAME = EXCHANGECALENDARSYNC.NAME,
                                    @DESCRIPTION = EXCHANGECALENDARSYNC.DESCRIPTION,
                                    @APPUSERIDSETREGISTERID = EXCHANGECALENDARSYNC.APPUSERIDSETREGISTERID,
                                    @TSLONG = EXCHANGECALENDARSYNC.TSLONG, 
                                    @DATALOADED = 1,
                                    @APPUSERRECORDTYPEID = dbo.UFN_RECORDTYPE_GETIDBYNAME('Application User'),
                                    @APPLYTOCODE = EXCHANGECALENDARSYNC.APPLYTOCODE,
                                    @CREATEITEMOPTIONCODE = EXCHANGECALENDARSYNC.CREATEITEMOPTIONCODE,                                                                                                        
                                    @INCLUDEPENDINGINTERACTIONS = EXCHANGECALENDARSYNC.INCLUDEPENDINGINTERACTIONS,
                                    @INCLUDEPROSPECTPLANSTEPS = EXCHANGECALENDARSYNC.INCLUDEPROSPECTPLANSTEPS,
                                    @INCLUDEPENDINGSTEWARDSHIPSTEPS = EXCHANGECALENDARSYNC.INCLUDEPENDINGSTEWARDSHIPSTEPS,
                                    @EXPECTEDDATEINTERVALCODE = EXCHANGECALENDARSYNC.EXPECTEDDATEINTERVALCODE,
                                    @SPECIFICAPPUSERID = EXCHANGECALENDARSYNC.SPECIFICAPPUSERID,
                                    @PAGEDEFINITIONCATALOGID = EXCHANGECALENDARSYNC.PAGEDEFINITIONCATALOGID,
                                    @DEFAULTREMINDERAMOUNT = EXCHANGECALENDARSYNC.DEFAULTREMINDERAMOUNT
                                from
                                    dbo.EXCHANGECALENDARSYNC
                                where
                                    EXCHANGECALENDARSYNC.ID = @ID;    

                                if @INCLUDEPENDINGINTERACTIONS = 1 and @INCLUDEPROSPECTPLANSTEPS = 1
                                    set @INTERACTIONFILTERCODE = 2

                                else if @INCLUDEPENDINGINTERACTIONS = 1 
                                    set @INTERACTIONFILTERCODE = 0                                    

                                else if @INCLUDEPROSPECTPLANSTEPS = 1
                                    set @INTERACTIONFILTERCODE = 1

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

                            return 0;
                        end