public ActionResult Student(Account account) { var StudentsDal = new StudentsDal(); var username = account.ID; var StudentsUser = (from x in StudentsDal.Students where x.ID.Equals(username) select x).ToList <Student>(); var StudentCourseDal = new StudentCourseDal(); var studentCourseObj = (from x in StudentCourseDal.StudentCourses where x.StudentID.Equals(username) select x).ToList <StudentCourse>(); var CoursesDal = new CoursesDal(); List <Courses> CourseDetail = new List <Courses>(); Courses t = new Courses(); foreach (StudentCourse y in studentCourseObj) { t = (from x in CoursesDal.Courses where x.CourseName.Equals(y.CourseName) select x).FirstOrDefault <Courses>(); CourseDetail.Add(t); } Student student = new Student() { ID = account.ID, FirstName = StudentsUser[0].FirstName, LastName = StudentsUser[0].LastName, }; StudentViewModel studentViewModel = new StudentViewModel() { student = student, courses = CourseDetail, studentCourses = studentCourseObj }; return(View(studentViewModel)); }
public ActionResult Faculty(Account account) { string id = account.ID; faculy_id = id; var LecturerDal = new LecturerDal(); var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>(); var FacultyDal = new FacultyDal(); var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(id) select x).ToList <Faculty>(); var CourseDal = new CoursesDal(); var CourseObj = (from x in CourseDal.Courses select x).ToList <Courses>(); var StudentsDal = new StudentsDal(); var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>(); Faculty faculty = new Faculty() { ID = account.ID, FirstName = FacultyObj[0].FirstName, LastName = FacultyObj[0].LastName }; FacultyViewModel facultyViewModel = new FacultyViewModel() { faculty = faculty, Coursesdata = CourseObj, Studentsdata = StudentsObj, LecturersData = LecturerObj }; return(View(facultyViewModel)); }
public ActionResult EditStudent(string id, string course, FormCollection collection)//---> gets course name, delete the row of it and add new row with changes from the faculty { DateTime now = DateTime.Now; StudentsDal dal = new StudentsDal(); ExamsDal dalEx = new ExamsDal(); Students sd = dal.students.Find(id, course); List <Exams> ex = (from x in dalEx.exams where x.CourseId.Contains(sd.CourseName) select x).ToList <Exams>(); foreach (Exams e in ex) { DateTime MoedADate = DateTime.Parse(e.MoedADate); DateTime MoedBDate = DateTime.Parse(e.MoedBDate); int resultA = DateTime.Compare(MoedADate, now.Date); if (resultA > 0) { return(RedirectToAction("ErrorPageAddGrade")); } int resultB = DateTime.Compare(MoedBDate, now.Date); if (resultB > 0) { return(RedirectToAction("ErrorPageAddGrade")); } } dal.students.Remove(sd); dal.SaveChanges(); Students stud = new Students() { FirstName = collection["FirstName"], LastName = collection["LastName"], Id = collection["Id"], CourseName = collection["CourseName"], GradeMoedA = collection["GradeMoedA"], GradeMoedB = collection["GradeMoedB"], FinalGrade = collection["FinalGrade"] }; if (ModelState.IsValid) { try { (from s in dal.students where s.Id == id select s).ToList(); dal.students.Add(stud); dal.SaveChanges(); } catch (Exception) { TempData["error"] = "The course already exist!\n"; // print error message return(View()); } } return(View("Home")); }
public JsonResult Get() { if ((string)Session["Power"] != "1") { return(Json("0")); } return(Json(StudentsDal.List(), JsonRequestBehavior.AllowGet)); }
public JsonResult Add(Students s) { if ((string)Session["Power"] != "1") { return(Json("0")); } StudentsDal.Add(s); return(Json(StudentsDal.List())); }
public JsonResult Edit(Students s) { if ((string)Session["Power"] != "1") { return(Json("0")); } StudentsDal.Edit(s, s.Id); return(Json(StudentsDal.List())); }
public JsonResult Delete(int id) { if ((string)Session["Power"] != "1") { return(Json("0")); } StudentsDal.Del(id); return(Json(StudentsDal.List())); }
public ActionResult EditGrade(string id, string course)//---> gets course id and name and return all the info about it { StudentsDal dalS = new StudentsDal(); List <Students> objStudents = (from x in dalS.students where x.Id.Contains(id) && x.CourseName.Contains(course) select x).ToList <Students>(); Students svm = new Students(); svm = objStudents[0]; return(View(svm)); }
public ActionResult StudentToCourse(string StudentID, string CourseName) { var LecturerDal = new LecturerDal(); var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>(); var StudentCourseDal = new StudentCourseDal(); var FacultyDal = new FacultyDal(); var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(faculy_id) select x).ToList <Faculty>(); var CourseDal = new CoursesDal(); var CourseObj = (from x in CourseDal.Courses select x).ToList <Courses>(); var StudentsDal = new StudentsDal(); var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>(); Faculty faculty = new Faculty() { ID = faculy_id, FirstName = FacultyObj[0].FirstName, LastName = FacultyObj[0].LastName }; FacultyViewModel facultyViewModel = new FacultyViewModel() { faculty = faculty, Coursesdata = CourseObj, Studentsdata = StudentsObj, LecturersData = LecturerObj }; StudentCourse sc = new StudentCourse() { CourseName = CourseName, StudentID = StudentID, }; if (StudentCourseDal.StudentCourses.Find(sc.StudentID, sc.CourseName) == null) { StudentCourseDal.StudentCourses.Add(sc); StudentCourseDal.SaveChanges(); } else { ViewBag.ErrorMessage2 = "This student is already assigned to this course!"; return(View("Faculty", facultyViewModel)); } return(View("Faculty", facultyViewModel)); }
public Boolean login(Students students) { StudentsDal studentsHelp = new StudentsDal(); return(studentsHelp.login(students)); }
public ActionResult ChangeLecturer(string CourseName, string LectID) { var LecturerDal = new LecturerDal(); var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>(); var FacultyDal = new FacultyDal(); var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(faculy_id) select x).ToList <Faculty>(); var CourseDal = new CoursesDal(); var CourseObj = (from x in CourseDal.Courses select x).ToList <Courses>(); var StudentsDal = new StudentsDal(); var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>(); Faculty faculty = new Faculty() { ID = faculy_id, FirstName = FacultyObj[0].FirstName, LastName = FacultyObj[0].LastName }; FacultyViewModel facultyViewModel = new FacultyViewModel() { faculty = faculty, Coursesdata = CourseObj, Studentsdata = StudentsObj, LecturersData = LecturerObj }; var CourseObj3 = (from x in CourseDal.Courses where x.LectID.Equals(LectID) select x).ToList <Courses>(); var CourseObj2 = (from x in CourseDal.Courses where x.CourseName.Equals(CourseName) select x).First <Courses>(); if (CourseObj2.LectID != LectID && CourseObj2 != null) { Courses c = new Courses() { CourseName = CourseObj2.CourseName, Classroom = CourseObj2.Classroom, Day = CourseObj2.Day, Hour = CourseObj2.Hour, MoedA = CourseObj2.MoedA, MoedB = CourseObj2.MoedB, LectID = LectID }; int cnt = 0; foreach (Courses c_2 in CourseObj3) { if (c_2.Day == c.Day && c_2.Hour == c.Hour) { cnt++; } } if (cnt == 0) { CourseDal.Courses.Remove(CourseObj2); CourseDal.Courses.Add(c); CourseDal.SaveChanges(); } else { ViewBag.ErrorMessage3 = "The course lecturer is already registered at this time"; return(View("Faculty", facultyViewModel)); } } return(View("Faculty", facultyViewModel)); }
//按照学号查早值 public Students SelectId(Students students) { StudentsDal studentsDal = new StudentsDal(); return(studentsDal.SelectId(students)); }
public ActionResult EditCourse(string CourseName, string MoedA, string MoedB, string Day, string Hour, string Classroom) { var LecturerDal = new LecturerDal(); var LecturerObj = (from x in LecturerDal.Lecturer select x).ToList <Lecturer>(); var CourseDal = new CoursesDal(); var CourseObj2 = (from x in CourseDal.Courses where x.CourseName.Equals(CourseName) select x).First <Courses>(); var FacultyDal = new FacultyDal(); var FacultyObj = (from x in FacultyDal.Faculty where x.ID.Equals(faculy_id) select x).ToList <Faculty>(); var CoursesObj = (from x in CourseDal.Courses select x).ToList <Courses>(); var StudentsDal = new StudentsDal(); var StudentsObj = (from x in StudentsDal.Students select x).ToList <Student>(); Faculty faculty = new Faculty() { ID = faculy_id, FirstName = FacultyObj[0].FirstName, LastName = FacultyObj[0].LastName }; FacultyViewModel facultyViewModel = new FacultyViewModel() { faculty = faculty, Coursesdata = CoursesObj, Studentsdata = StudentsObj, LecturersData = LecturerObj }; Courses CourseObj = new Courses() { CourseName = CourseName, Day = Day, Hour = Hour, Classroom = Classroom, MoedA = MoedA, MoedB = MoedB, LectID = CourseObj2.LectID }; int cnt = 0; foreach (Courses c in CourseDal.Courses) { if (c.Day == CourseObj.Day && c.Hour == CourseObj.Hour && c.Classroom == CourseObj.Classroom) { cnt++; } } if (cnt == 1) { ViewBag.ErrorMessage = "The course lecturer is already registered at this time"; return(View("Faculty", facultyViewModel)); } else { CourseDal.Courses.Remove(CourseObj2); CourseDal.SaveChanges(); CourseDal.Courses.Add(CourseObj); CourseDal.SaveChanges(); } return(View("Faculty", facultyViewModel)); }
public int UpdateM(Students students) { StudentsDal studentsDal = new StudentsDal(); return(studentsDal.UpdateM(students)); }
public List <Students> GetTable() { StudentsDal studentsDal = new StudentsDal(); return(studentsDal.GetTable()); }
public ActionResult Edit(string id, FormCollection collection)//---> gets course id, delete the row of it and add new row with changes from the faculty { CoursesDal dalC = new CoursesDal(); StudentsDal dalS = new StudentsDal(); string x = collection["LecturerId"]; string day = collection["Day"]; string StartHour = collection["StartHour"]; string EndHour = collection["EndHour"]; //list of all the courses List <Courses> CoursesObj = (from c in dalC.courses select c).ToList <Courses>(); List <Courses> LecturersCourses = (from c in dalC.courses where c.LecturerId.Contains(x) select c).ToList <Courses>(); //----------check if the lecturer has another course in this time foreach (Courses lect in LecturersCourses) { List <Courses> Crs = (from c in CoursesObj where c.CourseId.Contains(lect.CourseId) select c).ToList <Courses>(); //Courses crss = dal.courses.Find(obj.CourseName); foreach (Courses c in Crs) { if (c.Day == day) { if (System.Convert.ToDecimal(c.StartHour) >= System.Convert.ToDecimal(StartHour) && System.Convert.ToDecimal(c.StartHour) <= System.Convert.ToDecimal(EndHour) || System.Convert.ToDecimal(c.EndHour) >= System.Convert.ToDecimal(StartHour) && System.Convert.ToDecimal(c.EndHour) <= System.Convert.ToDecimal(EndHour)) { return(RedirectToAction("ErrorPageAddCourse")); } } } } //----------End check //----------check if there is a student with another course in this time List <Students> studentsCourses = (from s in dalS.students select s).ToList <Students>(); foreach (Students std in studentsCourses) { List <Courses> Crs = (from c in CoursesObj where c.CourseId.Contains(std.CourseName) select c).ToList <Courses>(); //Courses oneCourse = dalC.courses.Find(std.CourseName); foreach (Courses c in Crs) { if (c.Day == day) { if (System.Convert.ToDecimal(c.StartHour) >= System.Convert.ToDecimal(StartHour) && System.Convert.ToDecimal(c.StartHour) <= System.Convert.ToDecimal(EndHour) || System.Convert.ToDecimal(c.EndHour) >= System.Convert.ToDecimal(StartHour) && System.Convert.ToDecimal(c.EndHour) <= System.Convert.ToDecimal(EndHour)) { return(RedirectToAction("ErrorPageAddStud")); } } } } //CoursesDal dal = new CoursesDal(); Courses cr = dalC.courses.Find(id); dalC.courses.Remove(cr); dalC.SaveChanges(); Courses course = new Courses() { CourseName = collection["CourseName"], CourseId = collection["CourseId"], LecturerId = collection["LecturerId"], ClassRoom = collection["ClassRoom"], Day = collection["Day"], Hours = collection["Hours"], StartHour = collection["StartHour"], EndHour = collection["EndHour"] }; if (ModelState.IsValid) { try { (from c in dalC.courses where c.CourseName == id select c).ToList(); dalC.courses.Add(course); dalC.SaveChanges(); } catch (Exception) { TempData["error"] = "The course already exist!\n"; // print error message return(View()); } } return(View("Home")); }
public int Add(Students students) { StudentsDal studentsHelp = new StudentsDal(); return(studentsHelp.Add(students)); }
public ActionResult AddStudents(Students obj)//send info to db { StudentsDal dal = new StudentsDal(); CoursesDal dalC = new CoursesDal(); //list of of the same student and his courses List <Students> studentsCourses = (from s in dal.students where s.Id.Contains(obj.Id) select s).ToList <Students>(); //list of all the courses List <Courses> CoursesObj = (from c in dalC.courses select c).ToList <Courses>(); foreach (Students std in studentsCourses) { //only one course List <Courses> Crs = (from c in CoursesObj where c.CourseId.Contains(std.CourseName) select c).ToList <Courses>(); Courses cr = dalC.courses.Find(obj.CourseName); foreach (Courses c in Crs) { if (cr.Day == c.Day) { if (System.Convert.ToDecimal(cr.StartHour) >= System.Convert.ToDecimal(c.StartHour) && System.Convert.ToDecimal(cr.StartHour) <= System.Convert.ToDecimal(c.EndHour) || System.Convert.ToDecimal(cr.EndHour) >= System.Convert.ToDecimal(c.StartHour) && System.Convert.ToDecimal(cr.EndHour) <= System.Convert.ToDecimal(c.EndHour)) { return(RedirectToAction("ErrorPageAddStud")); } } } } Students students = new Students() { FirstName = obj.FirstName, LastName = obj.LastName, Id = obj.Id, CourseName = obj.CourseName, GradeMoedA = obj.GradeMoedA, GradeMoedB = obj.GradeMoedB, FinalGrade = obj.FinalGrade }; //StudentsDal dal = new StudentsDal(); if (ModelState.IsValid) { try { dal.students.Add(obj); dal.SaveChanges(); } catch (Exception) { TempData["error"] = "The course already exist!\n"; // print error message return(View()); } } return(RedirectToAction("Home")); }