public ActionResult GradesForStudent(int?id)
{
if (id == null)
{
return(null);
}
var student = db.Students.Find(id);
var grades = db.Grades.Where(g => g.StudentId == id).ToList();
var classesForStudent = new ClassesForStudent();
classesForStudent.Student = student;
classesForStudent.Grades = grades;
return(View(classesForStudent));
}
public ActionResult ClassesForStudent(int?id)
{
ClassesForStudent cfs = new ClassesForStudent();
cfs.student = db.Students.Find(id);
var classes = new List <Class>();
var enrolleds = db.Enrolleds.Where(e => e.StudentId == id).ToArray();
foreach (var enrolled in enrolleds)
{
classes.Add(db.Classes.Find(enrolled.ClassId));
}
cfs.classes = from s in db.Students
join e in db.Enrolleds
on s.Id equals e.StudentId
join c in db.Classes
on e.ClassId equals c.Id
select c;
cfs.classes = classes;
return(View(cfs));
}
