Implement portal.Navigation usage in side nav menu about crude-asp HOT 4 CLOSED

ALTER FUNCTION portal.GetNavigationRecursive(@ParentNavId INT)
RETURNS NVARCHAR(MAX)
AS
BEGIN
DECLARE
	@Json NVARCHAR(MAX)

;WITH Nav AS (SELECT TOP 100 PERCENT * FROM portal.Navigation ORDER BY NavOrder ASC)
SELECT @Json = ISNULL(@Json + N', ', N'[ ') + N' { "NavId": ' + CONVERT(nvarchar(max), NavId) + N',
"NavLabel": "' + portal.FormatValueForJson(NavLabel) + N'",
"NavOrder": ' + CONVERT(nvarchar(max), NavOrder) + N',
"NavUri": "' + ISNULL(portal.FormatValueForJson(NavUri), N'') + N'",
"NavGlyph": "' + portal.FormatValueForJson(NavGlyph) + N'",
"NavTooltip": "' + portal.FormatValueForJson(NavTooltip) + N'",
"ViewID": "' + portal.FormatValueForJson(CONVERT(nvarchar(max), ViewID)) + N'",
"ChildItems":' + ISNULL(portal.GetNavigationRecursive(ISNULL(NavId, -1)), N'[ ]') + N' }'
FROM Nav
WHERE NavParentId = @ParentNavId
OR (@ParentNavId IS NULL AND NavParentId IS NULL)

SET @Json = ISNULL(@Json, N'[ ') + N']'
RETURN @Json

END

var segments = window.location.pathname.split('/');
var toDelete = [];
for (var i = 0; i < segments.length; i++) {
    if (segments[i].length < 1) {
        toDelete.push(i);
    }
}
for (var i = 0; i < toDelete.length; i++) {
    segments.splice(i, 1);
}
var currFileName= segments[segments.length - 1];
console.log(currFileName);

$('.menu a').each(function() { //li a?
    if ($(this).attr('href') == currFileName){ $(this).addClass('active'); }
});