// GET: Procedures public ActionResult Index(int?procedureID, int?treatmentID) { //return View(db.Procedures.ToList()); var viewModel = new ProcedureIndexData(); viewModel.Procedure = db.Procedures //.Include(p => p.ProcedureID) .Include(p => p.Treatments.Select(t => t.Procedure)) //.Include(p => p.Treatments.Select(t => t.Owner)) //.Include(p => p.Treatments.Select(t => t.Pet)) .OrderBy(p => p.ProcedureID); if (procedureID != null) { ViewBag.ProcedureID = procedureID.Value; viewModel.Treatments = viewModel.Procedure.Where( p => p.ProcedureID == procedureID.Value).Single().Treatments; } /*if (treatmentID != null) * { * ViewBag.TreatmentID = treatmentID.Value; * viewModel.Treatments = viewModel.Procedure.Where( * x => x.ProcedureID == treatmentID).Single().Treatments; * }*/ return(View(viewModel)); }
// GET: Procedures public ActionResult Index(int?procedureID, int?treatmentID) { var viewModel = new ProcedureIndexData(); viewModel.Procedures = db.Procedures //.Include(p => p.Treatments.Select(t => t.Owner)) .OrderBy(p => p.ProcedureID); if (procedureID != null) { ViewBag.ProcedureID = procedureID.Value; viewModel.Treatments = viewModel.Procedures.Where( p => p.ProcedureID == procedureID.Value).Single().Treatments; } return(View(viewModel)); }