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());
}
