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);
}
