private async Task <List <ExamSession> > Search( ExamSessionSearchFilterDto search) { var examSessions = from e in _context.ExamSessions select e; var examSites = from e in _context.ExamSessions select e; examSessions = examSessions.Where(e => (string.IsNullOrEmpty(search.Name) || e.Name.Contains(search.Name)) && (search.StartDate == null || (e.StartDate > search.StartDate)) && (search.EndDate == null || (e.EndDate < search.EndDate)) && (string.IsNullOrEmpty(search.ExamSiteName) || e.ExamSite.Name.Contains(search.ExamSiteName))); examSessions = examSessions.OrderBy(e => e.Name.ToLower()); return(await examSessions.Include(e => e.ExamSite).ToListAsync()); }
// GET: ExamSessions public async Task <IActionResult> Index(ExamSessionSearchFilterDto search) { return(View(await _examSessionService .ExamSessionsAllOrSearchedListVM(search))); }
public async Task <ExamSessionAllOrSearchedListVM> ExamSessionsAllOrSearchedListVM(ExamSessionSearchFilterDto search) { var examSessionAllOrSearchFilteredListVM = new ExamSessionAllOrSearchedListVM { ExamSessions = await Search(search), Search = search }; return(examSessionAllOrSearchFilteredListVM); }