USP_RECORDOPERATION_USERSETTINGSINFORMATIONLIBRARYHIERARCHY_UPDATE

CREATE procedure dbo.USP_RECORDOPERATION_USERSETTINGSINFORMATIONLIBRARYHIERARCHY_UPDATE
(
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTAPPUSERID uniqueidentifier,
    @SELECTEDFOLDERID nvarchar(50) = '00000000-0000-0000-0000-000000000000',
    @ISCOLLAPSED bit,
    @SOURCEID uniqueidentifier
)
as begin
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
        set @CURRENTDATE = getdate()

    update 
        dbo.[USERSETTINGSINFORMATIONLIBRARYHIERARCHY]
    set 
        [SELECTEDFOLDERID] = @SELECTEDFOLDERID, 
        [ISCOLLAPSED] = @ISCOLLAPSED,
        [DATECHANGED] = @CURRENTDATE,
        [CHANGEDBYID] = @CHANGEAGENTID
    where
        [APPUSERID] = @CURRENTAPPUSERID
        and [SOURCEID] = @SOURCEID

    if @@rowcount = 0
        insert into dbo.[USERSETTINGSINFORMATIONLIBRARYHIERARCHY]
        (
            [APPUSERID],
            [SELECTEDFOLDERID],
            [ISCOLLAPSED],
            [SOURCEID],
            [DATEADDED],
            [DATECHANGED],
            [ADDEDBYID],
            [CHANGEDBYID]
        )    
        values(
            @CURRENTAPPUSERID,
            @SELECTEDFOLDERID,
            @ISCOLLAPSED,
            @SOURCEID,
            @CURRENTDATE,
            @CURRENTDATE,
            @CHANGEAGENTID,
            @CHANGEAGENTID
        )

end