public ActionResult ShowStudents(string cid) { // cid = "1"; //string cid = "1"; LearnDal learnDal = new LearnDal(); StudentDal studentDal = new StudentDal(); StudentViewModel viewModel = new StudentViewModel(); List <string> usernames = new List <string>(); foreach (Learn learn in learnDal.learns) { if (learn.cid.Equals(cid)) { usernames.Add(learn.Susername); } } viewModel.students = new List <Student>(); foreach (Student student in studentDal.Dalstudents) { if (usernames.Contains(student.username)) { viewModel.students.Add(student); } } return(View(viewModel.students)); }
// GET: Lecturer public ActionResult ShowSchedule() { // Session["username"] = "******"; ScheduleDal sheduleDal = new ScheduleDal(); LearnDal learnDal = new LearnDal(); CourseDal courseDal = new CourseDal(); ScheduleViewModel scheduleViewModel = new ScheduleViewModel(); scheduleViewModel.learns = new List <Learn>(); scheduleViewModel.courses = new List <Course>(); List <string> shids = new List <string>(); List <string> cids = new List <string>(); foreach (Course course in courseDal.courses.ToList <Course>()) { if (course.Lecturer.Equals(Session["username"].ToString())) { cids.Add(course.cid); scheduleViewModel.courses.Add(course); } } foreach (Learn learn in learnDal.learns.ToList <Learn>()) { if (cids.Contains(learn.cid)) { shids.Add(learn.shid); scheduleViewModel.learns.Add(learn); } } scheduleViewModel.schedules = new List <Shedule>(); foreach (Shedule shedule in sheduleDal.schedules.ToList <Shedule>()) { if (shids.Contains(shedule.shid)) { scheduleViewModel.schedules.Add(shedule); } } List <ScheduleViewModel> models = new List <ScheduleViewModel>(); ScheduleViewModel model; for (int i = 0; i < scheduleViewModel.courses.Count && i < scheduleViewModel.learns.Count && i < scheduleViewModel.schedules.Count; i++) { model = new ScheduleViewModel(); model.schedule = scheduleViewModel.schedules.ElementAt(i); model.Learn = scheduleViewModel.learns.ElementAt(i); model.course = scheduleViewModel.courses.ElementAt(i); models.Add(model); } return(View(models)); }
public ActionResult add() { string username = Request.Form["username"]; string cid = Request.Form["cid"]; if (ModelState.IsValid) { CourseDal c = new CourseDal(); Course course = c.courses.Find(cid); StudentDal s = new StudentDal(); Student student = s.Dalstudents.Find(username); if (student == null) { ModelState.AddModelError(string.Empty, "Student Name not exists."); return(View("addStudent")); } if (course == null) { ModelState.AddModelError(string.Empty, "Course cid not exists."); return(View("addStudent")); } LearnDal learn = new LearnDal(); Learn l = new Learn(); l.cid = course.cid; l.Susername = student.username; l.shid = course.shid; learn.learns.Add(l); try { learn.SaveChanges(); } catch (Exception) { ModelState.AddModelError(string.Empty, "this student already not exists."); } } return(View("Homepage")); }
public ActionResult ShowExams() { LearnDal learnDal = new LearnDal(); CourseDal courseDal = new CourseDal(); Session["username"] = "******"; ScheduleViewModel scheduleViewModel = new ScheduleViewModel(); scheduleViewModel.learns = new List <Learn>(); foreach (Learn learn in learnDal.learns.ToList <Learn>()) { if (learn.Susername.Equals(Session["username"])) { scheduleViewModel.learns.Add(learn); } } List <string> cids = new List <string>(); foreach (Learn learn in scheduleViewModel.learns) { if (!cids.Contains(learn.cid)) { cids.Add(learn.cid); } } //scheduleViewModel.schedules = sheduleDal.schedules.ToList<Shedule>(); scheduleViewModel.courses = new List <Course>(); foreach (Course course in courseDal.courses.ToList <Course>()) { if (cids.Contains(course.cid)) { scheduleViewModel.courses.Add(course); } } return(View(scheduleViewModel.courses)); }
public ActionResult update() { //CourseDal c = new CourseDal(); // StudentDal st = new StudentDal(); LearnDal l = new LearnDal(); Grade g = new Grade(); g.cid = Request.Form["cid"]; g.username = Request.Form["username"]; g.grade1 = Request.Form["grade"]; string a1 = Request.Form["update"]; if (a1 == null) { a1 = "i"; } Gradedal dal = new Gradedal(); List <Grade> s = dal.grade.ToList <Grade>(); if (l.learns.Find(g.username, g.cid) == null) { ModelState.AddModelError(string.Empty, "Student Name not exists."); return(View("editGrade")); } if (a1.Equals("u")) { Grade a = dal.grade.Find(g.username, g.cid); if (a == null) { ModelState.AddModelError(string.Empty, " this Student didnt have grade in this course to update."); return(View("editGrade")); } a.grade1 = g.grade1; try { dal.SaveChanges(); } catch (SqlException) { ModelState.AddModelError(string.Empty, "The Student have grade in this course you can do update."); } } if (a1.Equals("i")) { dal.grade.Add(g); dal.SaveChanges(); } return(View("editGrade")); }