public IEnumerable <SubcategoryModel> GetSubcategories(string category)
{
return(this.ExecuteOperationOrHandleExceptions(() =>
{
var context = new Top10AppDbContext();
var categoriesEntities = context.Categories;
IEnumerable <CategoryModel> currentCategory = (from categoryEntity in categoriesEntities
where categoryEntity.Name == category
select new CategoryModel()
{
id = categoryEntity.Id,
name = categoryEntity.Name,
subcategories = (from subcategoryEntity in categoryEntity.Subcategories
select new SubcategoryModel()
{
id = subcategoryEntity.Id,
name = subcategoryEntity.Name
})
});
return currentCategory.FirstOrDefault().subcategories;
}));
}
public IEnumerable <CategoryModel> GetAll()
{
return(this.ExecuteOperationOrHandleExceptions(() =>
{
var context = new Top10AppDbContext();
var categoriesEntities = context.Categories;
var categories = (from categoryEntity in categoriesEntities
select new CategoryModel()
{
id = categoryEntity.Id,
name = categoryEntity.Name,
subcategories = (from subcategoryEntity in categoryEntity.Subcategories
select new SubcategoryModel()
{
id = subcategoryEntity.Id,
name = subcategoryEntity.Name,
subcategories = (from storyEntity in subcategoryEntity.Stories
select new StoryModel()
{
id = storyEntity.Id,
name = storyEntity.Name,
subcategories = (from articleEntity in storyEntity.Articles
select new ArticleModel()
{
id = articleEntity.Id,
name = articleEntity.Name,
info = articleEntity.Info,
image = articleEntity.Image
})
})
})
});
return categories;
}));
}
