private List <TagModel> GetChildrenInner(Guid id, string parentPath) { using (var context = new NewsContext()) { var results = context .Tags .Where(x => x.ParentId == id) .Select(x => new TagModel { Id = x.Id, Title = x.Title, ShowInNav = x.ShowInNav, SortOrder = x.SortOrder }) .ToList(); results = GetChildren(results); results = _tagPathService.SetPaths(results); results = TagListExtensions.Order(results); return(results); } }
private List <TagModel> GetTags() { using (var context = new NewsContext()) { var results = context .Tags .Select(x => new TagModel { Id = x.Id, ParentId = x.ParentId, Title = x.Title, ShowInNav = x.ShowInNav, SortOrder = x.SortOrder, Path = x.Title.Replace(" ", "-") }) .ToList(); results = TagListExtensions.Order(results); results = _tagPathService.SetPaths(results); return(results); } }
private List <TagModel> GetTags(Guid articleId) { using (var context = new NewsContext()) { var results = context .Tags .Include(x => x.ArticleTags) .Where(x => x.ArticleTags.Any(x => x.ArticleId == articleId)) .Select(x => new TagModel { Id = x.Id, Title = x.Title, ShowInNav = x.ShowInNav, SortOrder = x.SortOrder, }) .ToList(); results = _tagPathService.SetPaths(results); results = TagListExtensions.Order(results); return(results); } }