Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.38 KB | None | 0 0
  1. sessions = sessions.Where(y => y.session.SESSION_DIVISION.Any(x => x.DIVISION.ToUpper().Contains(SearchContent)) ||
  2. y.session.ROOM.ToUpper().Contains(SearchContent) ||
  3. y.session.COURSE.ToUpper().Contains(SearchContent));
  4.  
  5. if (!String.IsNullOrEmpty(Division)) {
  6. sessions = sessions.Where(y => y.session.SESSION_DIVISION.Any(x => x.DIVISION.ToUpper().Contains(SearchContent)));
  7. }
  8.  
  9. if (!String.IsNullOrEmpty(Room)) {
  10.  
  11. // this shoudl be OR
  12. sessions = sessions.Where(y => y.session.ROOM.ToUpper().Contains(SearchContent));
  13. }
  14.  
  15. if (!String.IsNullOrEmpty(course)) {
  16.  
  17. // this shoudl be OR
  18. sessions = sessions.Where(y => y.session.COURSE.ToUpper().Contains(SearchContent));
  19. }
  20.  
  21. var queries = new List<IQueryable<Session>>();
  22. if (!String.IsNullOrEmpty(Division)) {
  23. queries.Add(sessions.Where(y => y.session.SESSION_DIVISION.Any(x => x.DIVISION.ToUpper().Contains(SearchContent))));
  24. }
  25.  
  26. if (!String.IsNullOrEmpty(Room)) {
  27.  
  28. // this shoudl be OR
  29. queries.Add(sessions.Where(y => y.session.ROOM.ToUpper().Contains(SearchContent)));
  30. }
  31.  
  32. if (!String.IsNullOrEmpty(course)) {
  33.  
  34. // this shoudl be OR
  35. queries.Add(sessions.Where(y => y.session.COURSE.ToUpper().Contains(SearchContent)));
  36. }
  37.  
  38. sessions = queries.Aggregate(sessions.Where(y => false), (q1, q2) => q1.Union(q2));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement