public ActionResult BookRoomToPaitent(TreatmentRoomModel roomModel) { TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var model = roomApi.BookTreatmentRoom(roomModel); return(View("~Views/TreatmentRoom/ViewTreatmentRooms.cshtml", model)); }
public ActionResult UpdateTreatmentRoom(TreatmentRoomModel roomModel) { TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var model = roomApi.UpdateTreatmentRoom(roomModel); return(View("~Views/TreatmentRoom/ViewTreatmentRooms.cshtml", model)); }
public ActionResult viewNewBooking() { if (Convert.ToString(Session["key"]) != "admin") { return(RedirectToAction("Login", "Home")); } Admin_Api adminApi = new Admin_Api(); var patients = adminApi.GetAllPatients(); TreatmentRoomModel trModel = new TreatmentRoomModel(); foreach (var p in patients) { trModel.patientDropDown.Add(new SelectListItem { Text = p.firstName, Value = Convert.ToString(p.pid) }); } TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var bookedRooms = roomApi.GetAllTreatmentRooms().Where(t => t.isBooked == true).Select(t => t.patient_ID); AppointmentTimings timings = new AppointmentTimings(); trModel.appointmentTimings = timings.timingsDropDown; return(View("~/Views/Administrator/AdminBookRoom.cshtml", trModel)); }
public ActionResult GetAllTreatmentRooms() { TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var model = roomApi.GetAllTreatmentRooms(); return(View("~Views/TreatmentRoom/ViewTreatmentRooms.cshtml", model)); }
public ActionResult GetRoomsRecordsByPatID(AccountModel acc) { if (Convert.ToString(Session["key"]) != "admin") { return(RedirectToAction("Login", "Home")); } TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); PatientModel pat = new PatientModel(); pat.pid = acc.patient_ID; var model = roomApi.GetRoomsRecordsByPatID(pat); 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/ViewRoomBooking.cshtml", model.OrderBy(m => m.date))); }
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 IEnumerable <string> AvailableRooms() { TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var model = roomApi.GetAllTreatmentRooms(); var rooms = model.Where(r => r.isBooked == false).Select(r => r.room_ID); return(rooms); }
public JsonResult CheckAvailabilityTreatmentRoom(TreatmentRoomModel roomModel) { TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var roomDetail = roomApi.CheckAvailabilityTreatmentRoom(roomModel); if (roomDetail != null) { return(Json(roomDetail.timings, JsonRequestBehavior.AllowGet)); } return(Json(roomDetail, JsonRequestBehavior.AllowGet)); }
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)); }
//Used to get aptmts for patients with no room booking public List <SelectListItem> GetApptsForRooms(int patientID) { Patient_Api patientApi = new Patient_Api(); Appointment_Api app = new Appointment_Api(); IEnumerable <AppointmentModel> patientAppointments = patientApi.GetAppointmentsForBookedRooms(patientID).Where(a => a.appointment_Date > DateTime.Now && a.cancelled == false); //apts with no rooms IEnumerable <AppointmentModel> patAptsNoBilling = app.GetAppointmentsWithNoBilling().Where(a => (a.paitent_ID == patientID && a.appointment_Date > DateTime.Now && a.cancelled == false)); //not billed apts List <int> aptsInt = new List <int>(); foreach (var a in patientAppointments) { aptsInt.Add(a.appointment_ID); } List <int> aptsIntNoBilling = new List <int>(); foreach (var a in patAptsNoBilling) { aptsIntNoBilling.Add(a.appointment_ID); } PatientModel patModel = new PatientModel(); patModel.pid = patientID; TreatmentRoom_Api trApi = new TreatmentRoom_Api(); var bookedAppointments = trApi.GetBookedRooms(patModel); //apts with room booked List <int> bookedaptsInt = new List <int>(); foreach (var a in bookedAppointments) { bookedaptsInt.Add(a.appointment_ID); } IEnumerable <int> finalApts = aptsIntNoBilling.Concat(aptsInt);//aptsIntNoBilling.Except(bookedaptsInt).ToList(); finalApts = finalApts.Except(bookedaptsInt).ToList(); List <SelectListItem> appts = new List <SelectListItem>(); foreach (var a in finalApts) { appts.Add(new SelectListItem { Text = a.ToString(), Value = a.ToString() }); } return(appts); }
// public ActionResult UpdateRooms(TreatmentRoomModel roomModel) public ActionResult UpdateRooms(TreatmentRoomModel roomModel) { if (Convert.ToString(Session["key"]) != "admin") { return(RedirectToAction("Login", "Home")); } //IEnumerable<TreatmentRoomModel> model = null; TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); TreatmentRoomModel trModel = new TreatmentRoomModel(); trModel.room_ID = roomModel.room_ID; trModel.isBooked = false; roomApi.UpdateTreatmentRoom(roomModel); return(RedirectToAction("ViewRooms")); //model = //return View("~/Views/Administrator/AdminViewRooms.cshtml", model); }
public ActionResult ViewRooms() { if (Convert.ToString(Session["key"]) != "nurse") { return(RedirectToAction("Login", "Home")); } TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); var model = roomApi.GetAllTreatmentRooms(); Patient_Api patientApi = new Patient_Api(); var p = patientApi.GetPaitentsList(); foreach (var m in model) { m.patientList = p; } return(View("~/Views/Nurse/NurseViewRooms.cshtml", model)); }
public JsonResult GetAvailableRooms(string text) { TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); TreatmentRoomModel room = new TreatmentRoomModel(); room.date = DateTime.Parse(text); IEnumerable <string> availableRooms = roomApi.GetAvailableRooms(room).Select(r => r.room_ID); var ra = room.roomList; var displayRooms = new List <RoomValues>(); try { displayRooms = ra.Where(r => availableRooms.Contains(r.Value)).ToList(); } catch (Exception ex) { } return(Json(displayRooms, JsonRequestBehavior.AllowGet)); }
public ActionResult BookRooms(TreatmentRoomModel roomModel) { if (Convert.ToString(Session["key"]) != "admin") { return(RedirectToAction("Login", "Home")); } TreatmentRoom_Api tr_Api = new TreatmentRoom_Api(); roomModel.isBooked = true; roomModel.timings = "09:00"; tr_Api.InsertTreatmentRoomRec(roomModel); TreatmentRoom_Api roomApi = new TreatmentRoom_Api(); PatientModel pat = new PatientModel(); pat.pid = roomModel.patient_ID; var model = roomApi.GetRoomsRecordsByPatID(pat); 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/ViewRoomBooking.cshtml", model)); }
public ActionResult GetAppointmentsWithNoBilling(int patientID) { //int id = (int)Session["UserId"]; Appointment_Api app = new Appointment_Api(); IEnumerable <int> patientAppointments = app.GetAppointmentsWithNoBilling().Where(a => (a.paitent_ID == patientID && a.appointment_Date < DateTime.Now)).Select(a => a.appointment_ID); //apts with no billing TreatmentRoom_Api trApi = new TreatmentRoom_Api(); PatientModel patModel = new PatientModel(); patModel.pid = patientID; var AptWithRoomInFuture = trApi.GetBookedRooms(patModel).Where(t => t.date > DateTime.Now).Select(t => t.appointment_ID); //apts with rooms in future patientAppointments = patientAppointments.Except(AptWithRoomInFuture); List <SelectListItem> appts = new List <SelectListItem>(); foreach (var a in patientAppointments) { appts.Add(new SelectListItem { Text = a.ToString(), Value = a.ToString() }); } return(Json(appts, JsonRequestBehavior.AllowGet)); }