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