public ActionResult ViewRooms() { if (Convert.ToString(Session["key"]) != "admin") { return(RedirectToAction("Login", "Home")); } TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var model = roomApi.GetAllTreatmentRoomRecs(); Patient_Api patientApi = new Patient_Api(); var p = patientApi.GetPaitentsList(); foreach (var r in model) { if (r.date > DateTime.Now) { r.canEdit = true; } } foreach (var m in model) { m.patientList = p; } return(View("~/Views/Administrator/AdminViewRooms.cshtml", model)); }
public JsonResult fillPatientList(string text) { Appointment_Api app = new Appointment_Api(); TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var model = roomApi.GetAllTreatmentRoomRecs().Where(t => (t.date == DateTime.Parse(text) && t.isBooked == true)).GroupBy(g => g.patient_ID).Select(s => s.First()).ToList(); var allAptmts = app.GetAllAppointments(); var apps = allAptmts.Where(a => a.appointment_Date > DateTime.Now).GroupBy(g => g.paitent_ID).Select(s => s.First()).ToList(); TreatmentRoomModel trModelPats = new TreatmentRoomModel(); TreatmentRoomModel trModel = new TreatmentRoomModel(); //var allApts = app.GetAllAppointments(); foreach (var p in model) { trModelPats.patientDropDown.Add(new SelectListItem { Text = p.patientFirstName, Value = Convert.ToString(p.patient_ID) }); } foreach (var p in apps) { trModel.patientDropDown.Add(new SelectListItem { Text = p.patientName, Value = Convert.ToString(p.paitent_ID) }); } trModel.patientDropDown = (from t in trModel.patientDropDown where trModelPats.patientDropDown.All(o => o.Text != t.Text) select t).ToList(); List <SelectListItem> patientList = new List <SelectListItem>(); foreach (var p in trModel.patientDropDown) { patientList.Add(p); } foreach (var t in trModel.patientDropDown) { if ((GetApptsForRooms(Convert.ToInt32(t.Value))).Count() == 0) { patientList.Remove(t); } } return(Json(patientList, JsonRequestBehavior.AllowGet)); }