public List <ArticleViewModel> Search(ArticleSeachModel seachModel) { var Query = _context.Articles .Include(article => article.ArticleCategory) .Select(article => new ArticleViewModel() { Id = article.Id, IsRemoved = article.IsRemoved, Picture = article.Picture, CategoryId = article.CategoryId, CategoryName = article.ArticleCategory.Name, PublishDate = article.PublishDate.ToFarsi(), CreationDate = article.CreationDate.ToFarsi(), Title = article.Title }).AsNoTracking(); if (!string.IsNullOrWhiteSpace(seachModel.Title)) { Query = Query.Where(c => c.Title.Contains(seachModel.Title)); } if (seachModel.CategoryId > 0) { Query = Query.Where(c => c.CategoryId == seachModel.CategoryId); } return(Query.OrderByDescending(c => c.Id).ToList()); }
public void OnGet(ArticleSeachModel seachModel) { Articles = _articleApplication.Search(seachModel); ArticleCategory = new SelectList(_articleCategoryApplication.GetArticleCategory(), "Id", "Name"); }
public List <ArticleViewModel> Search(ArticleSeachModel seachModel) { return(_articleRepo.Search(seachModel)); }