public IActionResult AddNewStudent(Student S) { ORM.Student.Add(S); ORM.SaveChanges(); return(RedirectToAction(nameof(StudentController.ShowAllStudents))); }
public ActionResult Create([Bind(Include = "Id,Name,Code,CreditHours,Discription")] Course course) { if (ModelState.IsValid) { db.Courses.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(course)); }
public ActionResult Create([Bind(Include = "StudentId,CourseId")] AssignCourse assignCourse) { if (ModelState.IsValid) { db.AssignCourses.Add(assignCourse); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(assignCourse)); }
public IActionResult DeleteCourse([FromBody] int CID) { try { using (StudentManagementSystemContext db = new StudentManagementSystemContext()) { var c = db.CourseMsts.Where(cu => cu.Cid == CID).FirstOrDefault(); if (c != null) { db.CourseMsts.Remove(c); db.SaveChanges(); var ret = new ObjectResult(new { Value = 0, Err = "" }); return(ret); } else { var ret = new ObjectResult(new { Value = 0, Err = "Course couldnt found!" }); return(ret); } } } catch (System.Exception ex) { if (ex.InnerException != null && ex.InnerException.Message.ToLowerInvariant().Contains("reference constraint")) { var ret = new ObjectResult(new { Value = 0, Err = "Error! This course is referenced to other records!" }); return(ret); } else { var ret = new ObjectResult(new { Value = 0, Err = "Error! " + ex.Message }); return(ret); } } }
public IActionResult SaveCourse([FromBody] CourseMst c) { try { using (StudentManagementSystemContext db = new StudentManagementSystemContext()) { db.CourseMsts.Add(c); db.SaveChanges(); } var ret = new ObjectResult(new { Value = 0, Err = "" }); return(ret); } catch (System.Exception ex) { var ret = new ObjectResult(new { Value = 0, Err = "Error! " + ex.Message }); return(ret); } }
public IActionResult DeleteCourse([FromBody] TeacherCourse tc) { try { using (StudentManagementSystemContext db = new StudentManagementSystemContext()) { var lst = db.TeacherCourses.Where(d => d.Tid == tc.Tid && d.Cid == tc.Cid).ToList(); db.TeacherCourses.RemoveRange(lst.ToArray()); db.SaveChanges(); lst.Clear(); lst = null; } var ret = new ObjectResult(new { Value = 0, Err = "" }); return(ret); } catch (System.Exception ex) { var ret = new ObjectResult(new { Value = 0, Err = "Error! " + ex.Message }); return(ret); } }