USP_EXCHANGECALENDARSYNC_ADDCALENDARITEMLINK

Records the link between an interaction and an app user.

Parameters

Parameter	Parameter Type	Mode
@INTERACTIONID	uniqueidentifier	IN
@APPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_EXCHANGECALENDARSYNC_ADDCALENDARITEMLINK
            (
                @INTERACTIONID uniqueidentifier, 
                @APPUSERID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as
                set nocount on;

                declare @CURRENTDATE datetime

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

                set @CURRENTDATE = getdate();

                update 
                    dbo.EXCHANGECALENDARITEM
                set
                    APPUSERID = @APPUSERID,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where
                    INTERACTIONID = @INTERACTIONID;

                if @@ROWCOUNT = 0 begin
                    if not exists(select ID from dbo.EXCHANGECALENDARITEM where EXCHANGECALENDARITEM.INTERACTIONID = @INTERACTIONID and EXCHANGECALENDARITEM.APPUSERID = @APPUSERID) begin
                        insert into dbo.EXCHANGECALENDARITEM
                            (INTERACTIONID, APPUSERID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED) 
                        values 
                            (@INTERACTIONID, @APPUSERID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
                    end;            
                end;