public ActionResult ChooseProcedure() { ViewModel vm = new ViewModel(); vm.Doctors = docdb.Doctors.OrderBy(a => a.DoctorName).ToList(); vm.Setups = setupdb.Setups.OrderBy(a => a.Doctor).ToList(); vm.Procedures = procdb.Procedures.OrderBy(a => a.ProcedureName).ToList(); return View(vm); }
public ActionResult ChooseDoctor() { ViewModel vm = new ViewModel(); vm.Doctors = docdb.Doctors.GroupBy(d => d.DoctorName).Select(d => d.FirstOrDefault()).OrderBy(a => a.DoctorName).ToList(); vm.Setups = setupdb.Setups.GroupBy(d => d.Doctor).Select(d => d.FirstOrDefault()).OrderBy(a => a.Doctor).ToList(); vm.Procedures = procdb.Procedures.GroupBy(d => d.ProcedureName).Select(d => d.FirstOrDefault()).OrderBy(a => a.ProcedureName).ToList(); return View(vm); }
public ActionResult ChooseProcedure(int? id) { var proc = Request["Procedure"]; Procedure procQuery = procdb.Procedures.Where(p => p.ProcedureName == proc).FirstOrDefault(); ViewModel vm = new ViewModel(); if (ModelState.IsValid) { return RedirectToAction("DisplayProcDocs/" + procQuery.ID); } return View(vm); }
public ActionResult ChooseDoctor(int? id) { var doc = Request["Doctor"]; Doctor docQuery = docdb.Doctors.Where(d => d.DoctorName == doc).FirstOrDefault(); ViewModel vm = new ViewModel(); if (ModelState.IsValid) { return RedirectToAction("DisplayDocsProcs/" + docQuery.ID); } return View(vm); }
public ActionResult DisplayDocsProcs(int? id) { Doctor doctor = docdb.Doctors.Find(id); ViewModel vm = new ViewModel(); vm.Doctors = docdb.Doctors.Where(s => s.DoctorName == doctor.DoctorName).ToList(); if (doctor == null) { return Content("doctor none"); } else { vm.Setups = setupdb.Setups.Where(s => s.Doctor == doctor.DoctorName).OrderBy(s => s.Procedure).ToList(); } if (vm == null) { return Content("vm None"); } else { return View(vm); } }
public ActionResult Result(int? id) { Setup setup = setupdb.Setups.Find(id); ViewModel vm = new ViewModel(); vm.Doctors = docdb.Doctors.Where(s => s.DoctorName == setup.Doctor).ToList(); if (setup == null) { return Content("None"); } else { vm.Setups = setupdb.Setups .Where(s => s.Doctor == setup.Doctor && s.Procedure == setup.Procedure) .ToList(); } if (vm == null) { return Content("None"); } else { return View(vm); } }
public ActionResult Index() { ViewModel vm = new ViewModel(); vm.Doctors = docdb.Doctors.ToList(); vm.Procedures = procdb.Procedures.ToList(); vm.Setups = setupdb.Setups.ToList(); return View(vm); }
public ActionResult DisplayProcDocs(int? id) { Procedure proc = procdb.Procedures.Find(id); ViewModel vm = new ViewModel(); vm.Procedures = procdb.Procedures.Where(p => p.ProcedureName == proc.ProcedureName).ToList(); if (proc == null) { return Content("doctor none"); } else { vm.Setups = setupdb.Setups.Where(p => p.Procedure == proc.ProcedureName).OrderBy(s => s.Doctor).ToList(); } if (vm == null) { return Content("vm None"); } else { return View(vm); } }