public ActionResult Create([Bind(Include = "EnrollmentID,ID,CourseID,Grade")] Enrollment enrollment) { if (ModelState.IsValid) { db.Enrollments.Add(enrollment); db.SaveChanges(); return(RedirectToAction("Index")); //var dataCheck = db.Enrollments.Where(e => e.StudentID == enrollment.StudentID && e.CourseID == enrollment.CourseID ); //if (dataCheck == null) //{ // db.Enrollments.Add(enrollment); // db.SaveChanges(); // return RedirectToAction("Index"); //} //else //{ // ViewBag.flag = 1; // return RedirectToAction("Index"); //} } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", enrollment.CourseID); ViewBag.StudentID = new SelectList(db.Students, "ID", "LastName", enrollment.StudentID); return(View(enrollment)); }
public ActionResult Create([Bind(Include = "InstructorID,Location")] OfficeAssignment officeAssignment) { if (ModelState.IsValid) { db.OfficeAssignments.Add(officeAssignment); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.InstructorID = new SelectList(db.Instructors, "InstructorID", "LastName", officeAssignment.InstructorID); return(View(officeAssignment)); }
public ActionResult Create([Bind(Include = "DepartmentID,DepartmentName,Budget,StartDate,InstructorID")] Department department) { if (ModelState.IsValid) { db.Departments.Add(department); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.InstructorID = new SelectList(db.Instructors, "InstructorID", "LastName", department.InstructorID); return(View(department)); }
public ActionResult Create([Bind(Include = "InstructorID,LastName,FirstMidName,HireDate")] Instructor instructor) { if (ModelState.IsValid) { db.Instructors.Add(instructor); db.SaveChanges(); return(RedirectToAction("Index")); } //ViewBag.OfficeAssignment = new SelectList(db.OfficeAssignments, "InstructorID", "Location", instructor.InstructorID); return(View(instructor)); }
public ActionResult Create([Bind(Include = "CourseInstructorID,CourseID,InstructorID,CourseAssignDate")] CourseInstructor courseInstructor) { if (ModelState.IsValid) { db.CourseInstructors.Add(courseInstructor); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", courseInstructor.CourseID); ViewBag.InstructorID = new SelectList(db.Instructors, "InstructorID", "LastName", courseInstructor.InstructorID); return(View(courseInstructor)); }
public ActionResult Create([Bind(Include = "LastName,FirstMidName,EnrollmentDate")] Student student) { try { if (ModelState.IsValid) { db.Students.Add(student); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { ModelState.AddModelError("abcError", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return(View(student)); }
public ActionResult Create([Bind(Include = "CourseID,Title,Credits,DepartmentID")] Course course) { try { if (ModelState.IsValid) { db.Courses.Add(course); db.SaveChanges(); return(RedirectToAction("Index")); } } catch (RetryLimitExceededException ex) { ModelState.AddModelError("", "Unable to save changes. Try again ! If the problem persists then contact to your administrator."); } var listOfDepartments = from d in db.Departments orderby d.DepartmentName select d; ViewBag.DepartmentID = new SelectList(listOfDepartments, "DepartmentID", "DepartmentName", course.Department.DepartmentID); return(View()); }