public async Task <IActionResult> Index(string studentIndex, string searchString) { IQueryable <Student> students = _context.Student.AsQueryable(); IQueryable <string> indexQuery = _context.Student.OrderBy(s => s.studentID).Select(s => s.studentID).Distinct(); if (!string.IsNullOrEmpty(searchString)) { students = students.Where(t => t.firstName.Contains(searchString) || t.lastName.Contains(searchString)); } if (!string.IsNullOrEmpty(studentIndex)) { students = students.Where(x => x.studentID == studentIndex); } students = students.Include(s => s.Enrollments).ThenInclude(e => e.course); var studentNameIndexVM = new StudentNameIndexViewModel { indexVM = new SelectList(await indexQuery.ToListAsync()), studentVM = await students.ToListAsync() }; return(View(studentNameIndexVM)); }
public async Task <IActionResult> Index(string StudentIndex, string SearchString) { IQueryable <Student> students = _context.Student.AsQueryable(); IQueryable <string> IndexQuery = _context.Student.OrderBy(s => s.StudentId).Select(s => s.StudentId).Distinct(); if (!string.IsNullOrEmpty(SearchString)) { students = students.Where(t => t.FirstName.Contains(SearchString) || t.LastName.Contains(SearchString)); } if (!string.IsNullOrEmpty(StudentIndex)) { students = students.Where(x => x.StudentId == StudentIndex); } students = students.Include(s => s.Courses).ThenInclude(e => e.Course); var studentNameIndexVM = new StudentNameIndexViewModel { IndexVm = new SelectList(await IndexQuery.ToListAsync()), StudentVm = await students.ToListAsync() }; return(View(studentNameIndexVM)); }