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