public ActionResult Edit([Bind(Include = "instructorRelease_id,instructor_id,semester_id,releaseDescription,totalReleaseHours")] InstructorRelease instructorRelease)
{
// instructorWNumber
instructorRelease.instructorWNumber = (from i in db.Instructors where i.instructor_id == instructorRelease.instructor_id select i.instructorWNumber).ToList().FirstOrDefault();
// semesterType,semesterYear
instructorRelease.semesterType = (from s in db.Semesters where s.semester_id == instructorRelease.semester_id select s.semesterType).ToList().FirstOrDefault();
instructorRelease.semesterYear = (from s in db.Semesters where s.semester_id == instructorRelease.semester_id select s.semesterYear).ToList().FirstOrDefault();
if (ModelState.IsValid)
{
db.Entry(instructorRelease).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.instructor_id = new SelectList(
from i in db.Instructors
orderby i.instructorLastName, i.instructorFirstName
select new { i.instructor_id, i.instructorFirstName, i.instructorLastName, fullName = i.instructorLastName + ", " + i.instructorFirstName },
"instructor_id", "fullName", instructorRelease.instructor_id);
ViewBag.semester_id = new SelectList(
from s in db.Semesters
orderby s.startDate descending
select new { s.semester_id, s.semesterType, s.semesterYear, fullName = s.semesterType + " " + s.semesterYear },
"semester_id", "fullName", instructorRelease.semester_id);
return(View(instructorRelease));
}
public ActionResult DeleteConfirmed(int id)
{
InstructorRelease instructorRelease = db.InstructorReleases.Find(id);
db.InstructorReleases.Remove(instructorRelease);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: InstructorReleases/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InstructorRelease instructorRelease = db.InstructorReleases.Find(id);
if (instructorRelease == null)
{
return(HttpNotFound());
}
return(View(instructorRelease));
}
public ActionResult Create([Bind(Include = "instructorRelease_id,instructor_id,semester_id,releaseDescription,totalReleaseHours")] InstructorRelease instructorRelease)
{
// instructorWNumber
instructorRelease.instructorWNumber = (from i in db.Instructors where i.instructor_id == instructorRelease.instructor_id select i.instructorWNumber).ToList().FirstOrDefault();
// semesterType,semesterYear
instructorRelease.semesterType = (from s in db.Semesters where s.semester_id == instructorRelease.semester_id select s.semesterType).ToList().FirstOrDefault();
instructorRelease.semesterYear = (from s in db.Semesters where s.semester_id == instructorRelease.semester_id select s.semesterYear).ToList().FirstOrDefault();
try {
if (ModelState.IsValid)
{
db.InstructorReleases.Add(instructorRelease);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception e) {
if (e.InnerException.InnerException.Message.Contains("UNIQUE KEY constraint"))
{
ModelState.AddModelError("totalReleaseHours", "The instructor has already been assigned release time for that semester");
}
else
{
ModelState.AddModelError("totalReleaseHours", e.InnerException.InnerException.Message);
}
}
ViewBag.instructor_id = new SelectList(
from i in db.Instructors
orderby i.instructorLastName, i.instructorFirstName
select new { i.instructor_id, i.instructorFirstName, i.instructorLastName, fullName = i.instructorLastName + ", " + i.instructorFirstName },
"instructor_id", "fullName", instructorRelease.instructor_id);
ViewBag.semester_id = new SelectList(
from s in db.Semesters
orderby s.startDate descending
select new { s.semester_id, s.semesterType, s.semesterYear, fullName = s.semesterType + " " + s.semesterYear },
"semester_id", "fullName", instructorRelease.semester_id);
return(View(instructorRelease));
}
// GET: InstructorReleases/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
InstructorRelease instructorRelease = db.InstructorReleases.Find(id);
if (instructorRelease == null)
{
return(HttpNotFound());
}
ViewBag.instructor_id = new SelectList(
from i in db.Instructors
orderby i.instructorLastName, i.instructorFirstName
select new { i.instructor_id, i.instructorFirstName, i.instructorLastName, fullName = i.instructorLastName + ", " + i.instructorFirstName },
"instructor_id", "fullName", instructorRelease.instructor_id);
ViewBag.semester_id = new SelectList(
from s in db.Semesters
orderby s.startDate descending
select new { s.semester_id, s.semesterType, s.semesterYear, fullName = s.semesterType + " " + s.semesterYear },
"semester_id", "fullName", instructorRelease.semester_id);
return(View(instructorRelease));
}
