USP_EXCHANGECALENDARSYNC_ADDSTEWARDSHIPCALENDARITEMLINK

Records the link between a stewardship step and an app user.

Parameters

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

Definition

Copy



create procedure dbo.USP_EXCHANGECALENDARSYNC_ADDSTEWARDSHIPCALENDARITEMLINK
(
    @STEPID 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.STEWARDSHIPEXCHANGECALENDARITEM
    set
        APPUSERID = @APPUSERID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where
        STEPID = @STEPID;

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