public ActionResult EditingFaculties(int id, string facultyName) { SISEntities db = new SISEntities(); var model = db.Faculties.Where(r => r.TableID == id).FirstOrDefault(); model.f_Name = facultyName; db.SaveChanges(); return(RedirectToAction("ListingFaculties", "Faculty")); }
public ActionResult EditingDepartments(int id, string deptName, int facultyID) { SISEntities db = new SISEntities(); var model = db.Deparments.Where(r => r.TableID == id).FirstOrDefault(); model.d_Name = deptName; model.d_Faculties_TableID = facultyID; db.SaveChanges(); return(RedirectToAction("ListingDepartments", "Department")); }
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////\\ public ActionResult DeletingDepartments(int ID) { SISEntities db = new SISEntities(); if (db.Deparments.Where(r => r.TableID == ID).Any()) { db.Deparments.Remove(db.Deparments.Where(r => r.TableID == ID).FirstOrDefault()); db.SaveChanges(); } return(RedirectToAction("ListingDepartments", "Department")); }
//\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\////////////////////////////////////////////////\\ //Deleting Users public ActionResult DeletingUsers(int ID) { SISEntities db = new SISEntities(); if (db.Users.Where(r => r.TableID == ID).Any()) //LINQ usage { db.Users.Remove(db.Users.Where(r => r.TableID == ID).FirstOrDefault()); db.SaveChanges(); } return(RedirectToAction("ListingUsers", "User")); }
public ActionResult AddNewFaculty(string facultyName) { SISEntities db = new SISEntities(); Faculties faculty = new Faculties { f_Name = facultyName, }; db.Faculties.Add(faculty); db.SaveChanges(); return(View()); }
public ActionResult AddNewDepartment(string deptName, int facultyID) { SISEntities db = new SISEntities(); Deparments deparment = new Deparments { d_Name = deptName, d_Faculties_TableID = facultyID, }; db.Deparments.Add(deparment); db.SaveChanges(); return(View()); }
public ActionResult EditingCourses(int id, string courseName, int courseEcts, string courseTerm, int deptID) { SISEntities db = new SISEntities(); var model = db.Courses.Where(r => r.TableID == id).FirstOrDefault(); model.c_Name = courseName; model.c_ECTS = courseEcts; model.c_Term = courseTerm; model.c_Departments_TableID = deptID; db.SaveChanges(); return(RedirectToAction("ListingCourses", "Course")); }
public ActionResult AssigningCourse(int id, int CourseID) { SISEntities db = new SISEntities(); Lecturers_Courses lecturer = new Lecturers_Courses { lc_Users_TableID = id, lc_Courses_TableID = CourseID }; db.Lecturers_Courses.Add(lecturer); db.SaveChanges(); return(View()); }
public ActionResult OpenNewCourse(string courseName, int courseEcts, string courseTerm, int deptID) { SISEntities db = new SISEntities(); Courses course = new Courses(); course.c_Name = courseName; course.c_ECTS = courseEcts; course.c_Term = courseTerm; course.c_Departments_TableID = deptID; db.Courses.Add(course); db.SaveChanges(); return(View()); }
public ActionResult CourseSelection(int courseID) { var userID = ((Users)Session["LoggedUser"]).TableID; SISEntities db = new SISEntities(); Students_Courses choosenCourse = new Students_Courses { sc_Users_TableID = userID, sc_Courses_TableID = courseID }; db.Students_Courses.Add(choosenCourse); db.SaveChanges(); return(View()); }
public ActionResult AddNewUser(string citNum, string logNum, string fulName, string password, string email, string phnNum, string address, string title, int groupID, string pic, int depID, HttpPostedFileBase uploadImages) { SISEntities db = new SISEntities(); Users user = new Users(); user.u_Citizen_Number = citNum; user.u_Login_Number = logNum; user.u_Name = fulName; user.u_Password = password; user.u_eMail = email; user.u_Phone_Number = phnNum; user.u_Address = address; user.u_Registration_Date = DateTime.Now; user.u_Title = title; user.u_Groups_TableID = groupID; //Picture section if (uploadImages != null || uploadImages.ContentLength > 0) { var name = Path.GetExtension(uploadImages.FileName); var fullname = logNum + name; var path = Path.Combine(Server.MapPath("~/images/pp"), fullname); uploadImages.SaveAs(path); user.u_Picture = fullname; } else if (uploadImages == null) { user.u_Picture = fulName; } else { user.u_Picture = "user.png"; } //Department Selection if (groupID == 1) { //admin } else if (groupID == 2 || groupID == 3) { user.u_Departments_TableID = depID; } db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("AddNewUser", "User")); }
public ActionResult EditingUsers(int id, string citNum, string logNum, string fulName, string password, string email, string phnNum, string address, string title, int groupID, int depID) { SISEntities db = new SISEntities(); var model = db.Users.Where(r => r.TableID == id).FirstOrDefault(); model.u_Citizen_Number = citNum; model.u_Login_Number = logNum; model.u_Name = fulName; model.u_Password = password; model.u_eMail = email; model.u_Phone_Number = phnNum; model.u_Address = address; model.u_Title = title; model.u_Groups_TableID = groupID; model.u_Departments_TableID = depID; db.SaveChanges(); return(RedirectToAction("ListingUsers", "User")); }
public ActionResult SetNotes(int id, int midterm, int final, int?resit, double?courseGPA = 0.0) { SISEntities db = new SISEntities(); var std_course = db.Students_Courses.Where(r => r.TableID == id).FirstOrDefault(); std_course.sc_Midterm_Grade = midterm; std_course.sc_Final_Grade = final; std_course.sc_Resit_Grade = resit; if (resit == null || resit == 0) { courseGPA = midterm * 0.4 + final * 0.6; std_course.sc_Grade = courseGPA; } else { courseGPA = midterm * 0.5 + resit * 0.5; std_course.sc_Grade = courseGPA; } db.SaveChanges(); return(RedirectToAction("GradeEntry1", "Course", new { courseID = std_course.sc_Courses_TableID })); }