// GET: Students public async Task <IActionResult> Index(string studentName, string searchString) { // Use LINQ to get list of genres. IQueryable <string> nameQuery = from m in _context.Student orderby m.Name select m.Name; var students = from m in _context.Student select m; if (!string.IsNullOrEmpty(searchString)) { students = students.Where(s => s.Name.Contains(searchString)); } if (!string.IsNullOrEmpty(studentName)) { students = students.Where(x => x.Name == studentName); } var studentNameVM = new StudentNameViewModel { Names = new SelectList(await nameQuery.Distinct().ToListAsync()), Students = await students.ToListAsync() }; return(View(studentNameVM)); }
public async Task <IActionResult> SelectEnrollment(StudentNameViewModel student) { var enrollments = _context.Enrollment.Where(e => e.StudentId == student.id); List <EnrollmentDisplayViewModel> ens = enrollments.Select(e => new EnrollmentDisplayViewModel { id = e.EnrollmentId, enrollment = e.Instrument.Instrument1 + " (Grade " + e.Grade + ")" }).ToList(); ViewData["Enrollment"] = new SelectList(ens, "id", "enrollment"); return(View()); }