public ActionResult ViewClassRosters() { int id = (int)Session["User"]; List<Class> classes = db.Classes.Where(m => m.ProfessorID == id).ToList(); List<int> classSize = new List<int>(); List<ClassStudent> Cstudents = new List<ClassStudent>(); foreach (Class c in classes) { IEnumerable<ClassStudent> these = db.ClassStudents.Where(m => m.ClassID == c.Id); classSize.Add(these.Count()); Cstudents.AddRange(these); } List<StudentInfo> students = new List<StudentInfo>(); foreach (ClassStudent cs in Cstudents) { students.Add(db.StudentInfoes.Find(cs.StudentID)); } ViewBag.classSize = classSize; ViewRostersViewModel model = new ViewRostersViewModel(); model.classes = classes; model.students = students; return View(model); }
public ActionResult AddStudentToClass() { int num = (int)Session["User"]; List<StudentInfo> students = db.StudentInfoes.Where(m => m.AdvisorID == num).ToList(); int id = db.Semesters.FirstOrDefault(m => (bool)m.Active).Id; List<Class> classes = db.Classes.Where(m => m.SemesterID == id).ToList(); ViewBag.classesSL = new SelectList(classes, "Id", "Name"); ViewBag.studentsSL = new SelectList(students, "Id", "Name"); ViewRostersViewModel model = new ViewRostersViewModel(); model.classes = classes; model.students = students; return View(model); }
public ActionResult ViewClassRosters() { int id = db.Semesters.FirstOrDefault(m => (bool)m.Active).Id; List<Class> classes = db.Classes.Where(m => m.SemesterID == id).ToList(); List<int> classSize = new List<int>(); List<ClassStudent> Cstudents = new List<ClassStudent>(); foreach (Class c in classes) { IEnumerable<ClassStudent> these = db.ClassStudents.Where(m => m.ClassID == c.Id); classSize.Add(these.Count()); Cstudents.AddRange(these); } List<StudentInfo> students = new List<StudentInfo>(); foreach (ClassStudent cs in Cstudents) { students.Add(db.StudentInfoes.Find(cs.StudentID)); } ViewRostersViewModel model = new ViewRostersViewModel(); model.classes = classes; model.students = students; ViewBag.classSize = classSize; return View(model); }