// GET: Teacher
public ActionResult Index(int?id, int?trackID)
{
var viewModel = new TeacherIndexData();
viewModel.Teachers = db.Teachers
.Include(i => i.LocationAssignment)
.Include(i => i.Tracks.Select(c => c.Company))
.OrderBy(i => i.LastName);
if (id != null)
{
ViewBag.TeacherID = id.Value;
viewModel.Tracks = viewModel.Teachers.Where(
i => i.ID == id.Value).Single().Tracks;
}
if (trackID != null)
{
ViewBag.TrackID = trackID.Value;
// Lazy loading
//viewModel.Enrollments = viewModel.Courses.Where(
// x => x.CourseID == courseID).Single().Enrollments;
// Explicit loading
var selectedTrack = viewModel.Tracks.Where(x => x.TrackID == trackID).Single();
db.Entry(selectedTrack).Collection(x => x.Enrollments).Load();
foreach (Enrollment enrollment in selectedTrack.Enrollments)
{
db.Entry(enrollment).Reference(x => x.Car).Load();
}
viewModel.Enrollments = selectedTrack.Enrollments;
}
return(View(viewModel));
}
public ActionResult Edit([Bind(Include = "TrackID,TrackName,TrackLocation")] Track track)
{
if (ModelState.IsValid)
{
db.Entry(track).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(track));
}
public ActionResult Edit([Bind(Include = "ID,LastName,FirstMidName,HireDate")] Driver driver)
{
if (ModelState.IsValid)
{
db.Entry(driver).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(driver));
}
public ActionResult Edit([Bind(Include = "CompanyID,CompanyName,CompanyLocation,StartDate,TeacherID")] Company company)
{
if (ModelState.IsValid)
{
db.Entry(company).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TeacherID = new SelectList(db.Teachers, "ID", "LastName", company.TeacherID);
return(View(company));
}