public List <ArticleCategoryViewModel> Seach(ArticleCategorySearchModel searchModel)
{
var query = _context.ArticleCategories.Select(c => new ArticleCategoryViewModel()
{
Id = c.Id,
Name = c.Name,
ShowOrder = c.ShowOrder,
CreationDate = c.CreationDate.ToFarsi(),
Description = c.Description,
ArticleCount = c.Articles.Count
});
if (!string.IsNullOrWhiteSpace(searchModel.Name))
{
query = query.Where(c => c.Name.Contains(searchModel.Name));
}
return(query.OrderByDescending(c => c.Id).ToList());
}
public List <ArticleCategoryViewModel> Search(ArticleCategorySearchModel searchModel)
{
var query = _blogContext.ArticleCategories.Select(x => new ArticleCategoryViewModel()
{
Picture = x.Picture,
ShowOrder = x.ShowOrder,
Description = x.Description,
Id = x.Id,
Name = x.Name,
CreationDate = x.CreationDate.ToFarsi()
});
if (!string.IsNullOrWhiteSpace(searchModel.Name))
{
query = query.Where(x => x.Name.Contains(searchModel.Name));
}
return(query.OrderByDescending(x => x.ShowOrder).ToList());
}
public List <ArticleCategoryViewModel> Search(ArticleCategorySearchModel searchModel)
{
var query = _blogContext.ArticleCategories
.Include(x => x.Articles)
.Select(x => new ArticleCategoryViewModel
{
Id = x.Id,
Name = x.Name,
ShowOrder = x.ShowOrder,
Picture = x.Picture,
ShortDescription = x.ShortDescription.Substring(0, Math.Min(x.ShortDescription.Length, 50)) + "...",
CreationDate = x.CreationDate.ToFarsi(),
ArticlesCount = x.Articles.Count
});
if (!string.IsNullOrWhiteSpace(searchModel.Name))
{
query = query.Where(x => x.Name.Contains(searchModel.Name));
}
return(query.OrderByDescending(x => x.ShowOrder).ToList());
}
public List <ArticleCategoryViewModel> Search(ArticleCategorySearchModel searchModel)
{
//var query = _context.ArticleCategories
// .Include(x => x.Articles)
// .Select(x => new ArticleCategoryViewModel
// {
// Id = x.Id,
// Description = x.Description,
// Name = x.Name,
// Picture = x.Picture,
// ShowOrder = x.ShowOrder,
// CreationDate = x.CreationDate.ToFarsi(),
// ArticlesCount = x.Articles.Count
// });
//if (!string.IsNullOrWhiteSpace(searchModel.Name))
// query = query.Where(x => x.Name.Contains(searchModel.Name));
//return query.OrderByDescending(x => x.ShowOrder).ToList();
var query = _context.ArticleCategories
.Select(x => new ArticleCategoryViewModel
{
Id = x.Id,
Description = x.Description,
Name = x.Name,
Picture = x.Picture,
ShowOrder = x.ShowOrder,
CreationDate = x.CreationDate.ToFarsi()
});
if (!string.IsNullOrWhiteSpace(searchModel.Name))
{
query = query.Where(x => x.Name.Contains(searchModel.Name));
}
return(query.OrderByDescending(x => x.ShowOrder).ToList());
}
public void OnGet(ArticleCategorySearchModel searchModel)
{
ArticleCategories = _articleCategoryApplication.Search(searchModel);
}
public List <ArticleCategoryViewModel> Search(ArticleCategorySearchModel searchModel)
{
return(_articleCategoryRepository.Search(searchModel));
}
