Tree GetItems

CREATE PROCEDURE [dbo].[tree_tst-catalog_getItems]
    @parameters DictionaryParameter READONLY,
    @username nvarchar(128 )='',
    @itemID nvarchar(128)=''
as
begin

    declare @langID int
    select @langID = try_cast(Value as int) from @parameters where [Key] = 'langID'


    -- SELECT 1
    select 1 Result, '' Msg,
        1 CanRename, 1 CanAdd, 1 canDelete,
        '' PlusIcon, '' MinusIcon, 0 ShowIcon, 1 ShowTags,
        '0' ParentIDRootValue,
        '' EmptyIcon,
        '' NodeIcon

    -- SELECT 2
    select c.id Id,
        c.name as title,
        isnull(c.parentID, 0) ParentID,
        c.ord Ord,
        '' Icon, -- fa fa-cube
        'form' [Type],  -- // form, redirect, refreshContainer
         '<a class="as-form-modal" data-code="tst-editCategory" data-itemid="'+cast(c.id as nvarchar)+'" href="#" data-btntext="'+iif(@langID=1, 'Save', 'Сохранить')+'" data-big="0" data-title="'+c.name+'" data-slideout="1"><i class="fas fa-edit"></i></a>' Value,
        --'refreshContainer' [Type],
        --'body' Value,
        0 Expanded,
        0 Selected,
        'fa fa-stop' selectedIcon,
        '#555' color,
        '#eee' backColor,
        '#' href,
        1 selectable,
        case when (select count(*) from tst_categoryProducts where categoryID = c.id) > 0
             then '<span class="text-danger font-weight-bold">'+cast((select count(*) from tst_categoryProducts where categoryID = c.id) as nvarchar) + ' '+iif(@langID=1, 'cnt', 'тов.')+'</span>'
             else '<span class="text-secondary font-weight-bold">'+cast((select count(*) from tst_categoryProducts where categoryID = c.id) as nvarchar) + ' '+iif(@langID=1, 'cnt', 'тов.')+'</span>'
             end + '|' +
        case when (select count(*) from tst_categories c1 where c1.parentID = c.id) > 3
             then '+'+cast((select count(*) from tst_categories c1 where c1.parentID = c.id)-3 as nvarchar)+'...'
             else '' end  + '|' +
        isnull(STUFF((SELECT top 3 '|' +  CAST(name as nvarchar(64)) as [text()]
                      FROM tst_categories c1 WHERE c1.parentID = c.id ORDER BY c1.ord
                FOR XML PATH(''), TYPE).value('.', 'VARCHAR(MAX)'), 1, 1, ''), '') AS  info
    from tst_categories c
end