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