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