Advertisement
Guest User

Untitled

a guest
Jun 27th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.74 KB | None | 0 0
  1. var keywords = query.Split(new char[] {' '}, StringSplitOptions.RemoveEmptyEntries).ToList();
  2.  
  3. IQueryable<News> searchQuery;
  4. if (categoryId == null)
  5. {
  6.       searchQuery = from n in dbEntities.News.Include("Category")
  7.                     where keywords.Any(w => n.Title.IndexOf(w, StringComparison.InvariantCultureIgnoreCase) > -1)
  8.                     select n;
  9. }
  10. else
  11. {
  12.       searchQuery = from n in dbEntities.News.Include("Category")
  13.                     where n.Category.CategoryId == categoryId &&
  14.                           keywords.Any(w => n.Title.IndexOf(w, StringComparison.InvariantCultureIgnoreCase) > -1)
  15.                     select n;
  16. }
  17.  
  18. resultPagesCount = (int)(Math.Ceiling(1.0 * searchQuery.Count() / NewsRepository.PAGE_SIZE));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement