public IActionResult Search(SearchVm ob) { Facility_Reservation FR = new Facility_Reservation(); var Nameexist = _asu.Patients.ToList().Any(f => f.Name == ob.patientName); if (Nameexist) { var ID = _asu.Patients.Where(f => f.Name == ob.patientName).Select(s => s.Id).Single(); var NamePexist = _asu.Facility_Reservations.ToList().Any(f => f.Patient_Id == ID); if (NamePexist) { /* * var Startavailable = _asu.Facility_Reservations.Where(f => f.Patient_Id == ID) * .Select(s => s.Start_Hour).Single(); * var Endavailable = _asu.Facility_Reservations.Where(f => f.Patient_Id == ID) * .Select(s => s.End_Hour).Single(); * * var Endavailable = _asu.Facility_Reservations.Where(f => f.Patient_Id == ID) * .Select(s =>new { s.End_Hour ,s.Start_Hour}).ToList(); * DateTime parse1 = DateTime.Parse(Startavailable); * DateTime parse2 = DateTime.Parse(Endavailable); */ var Endavailable = _asu.Facility_Reservations.Where(f => f.Patient_Id == ID) .Select(s => new { dates = s.Start_Hour, dateE = s.End_Hour, name = s.Id }) .OrderByDescending(w => w.dateE).FirstOrDefault(); //.ToList(); //foreach (var V in Endavailable) //{ DateTime parse3 = DateTime.Parse(Endavailable.dates); DateTime parse4 = DateTime.Parse(Endavailable.dateE); //int i = V.name; if ((parse3 <= ob.Today && ob.Today <= parse4)) { var roomnumber = _asu.Facility_Reservations .Where(F => F.Id == Endavailable.name) .Select(s => s.Hospital_Facility_Id).Single(); TempData["room"] = _asu.Hospital_Facilities.Where(t => t.Id == roomnumber) .Select(S => S.Type).Single(); ViewBag.DD = TempData["room"]; return(View()); // return Redirect("/Front_desk/Searchresult"); } else { ViewBag.Not = "This patient is not in our hospital."; return(View()); //return Redirect("/Front_desk/NotAvailable"); } //} } ViewBag.Not = "This patient is not in our hospital."; return(View()); //return Redirect("/Front_desk/NotAvailable"); } ViewBag.Not = "This patient is not in our hospital."; return(View()); //return Redirect("/Front_desk/NotAvailable"); }
public IActionResult Delete(delete vm, checkVM ch) { var NameExist = _asu.Patients.ToList().Any(u => u.Name == vm.PatientName); if (NameExist) { Facility_Reservation FR = new Facility_Reservation(); var PatientName = _asu.Patients.Where(f => f.Name == vm.PatientName) .Select(s => s.Id).Single(); var NameExistreservation = _asu.Facility_Reservations.ToList().Any(u => u.Patient_Id == PatientName); //var RoomID = _asu.Facility_Reservations.Where(f => f.Patient_Id == PatientName) //.OrderByDescending(d=>d); if (NameExistreservation) { var h = _asu.Facility_Reservations.Where(f => f.Patient_Id == PatientName) .Select(s => new Facility_Reservation { Id = s.Id, Staff_Id = s.Staff_Id }) .OrderByDescending(s => s.Id) .FirstOrDefault(); String ROOMName = HttpContext.Session.GetString("Roomname"); String start = HttpContext.Session.GetString("START"); String end = HttpContext.Session.GetString("END"); var HID = _asu.Hospital_Facilities.Where(f => f.Type == ROOMName).Select(s => s.Id).Single(); FR.Start_Hour = start; //ob.From; FR.End_Hour = end; FR.Hospital_Facility_Id = HID; //FR.Hospital_Facility_Id =no ; FR.Patient_Id = PatientName; FR.Staff_Id = h.Staff_Id; _asu.Add(FR); _asu.SaveChanges(); int x = h.Id; var model = _asu.Facility_Reservations.Find(x); _asu.Remove(model); _asu.SaveChanges(); ViewBag.UserMessage3 = "Patient is transferred successfully"; return(View()); } else { ViewBag.fail = "This Patient doesnt have a reservation"; return(View()); } } else { ViewBag.fail = "This Patient doesnt have a reservation"; return(View()); } }
public IActionResult Event(mainVM m) { Facility_Reservation FR = new Facility_Reservation(); Hospital_Facility H = new Hospital_Facility(); var ID = _asu.Hospital_Facilities.Where(f => f.Type == m.Room_Id).Select(s => s.Id).Single(); var h = _asu.Facility_Reservations.Include(p => p.Patient).Where(f => f.Hospital_Facility_Id == ID) .OrderByDescending(s => s.End_Hour).ToList(); ViewBag.Roomnumber = m.Room_Id; ViewBag.D1 = h; return(View()); }
public IActionResult Roomreservation(roomVM ob, checkVM ch) { String ROOMName = HttpContext.Session.GetString("Roomname"); String start = HttpContext.Session.GetString("START"); String end = HttpContext.Session.GetString("END"); String SURGERYROOMName = HttpContext.Session.GetString("SRoomname"); String surgerystart = HttpContext.Session.GetString("STARTSurgery"); String surgeryend = HttpContext.Session.GetString("ENDSurgery"); Facility_Reservation FR = new Facility_Reservation(); Facility_Reservation F = new Facility_Reservation(); Payment P = new Payment(); Payment P1 = new Payment(); var NamePexist = _asu.Patients.ToList().Any(f => f.Name == ob.PatientName); var NameSexist = _asu.Staff.ToList().Any(F => F.Name == ob.DoctorName); var surgeryprice = _asu.Follow_Ups_Types.Where(f => f.Name == "Surgery").Select(s => s.Price).Single(); var roomprice = _asu.Follow_Ups_Types.Where(f => f.Name == "Room").Select(s => s.Price).Single(); var RoompriceId = _asu.Follow_Ups_Types.Where(f => f.Name == "Room").Select(s => s.Id).Single(); var surgeryId = _asu.Follow_Ups_Types.Where(f => f.Name == "Surgery").Select(s => s.Id).Single(); DateTime parse1 = DateTime.Parse(start); DateTime parse2 = DateTime.Parse(end); var Duration = parse2 - parse1; int days = Duration.Days + 1; int Totalroomprice = days * roomprice; var HID = _asu.Hospital_Facilities.Where(f => f.Type == ROOMName).Select(s => s.Id).Single(); if (NamePexist) { TempData["Patient_Id"] = _asu.Patients.Where(f => f.Name == ob.PatientName).Select(s => s.Id).Single(); if (NameSexist) { //string start = TempData["Start"].ToString(); //string end = TempData["end"].ToString(); //int no = (int)TempData["HID"]; TempData["Staff_Id"] = _asu.Staff.Where(f => f.Name == ob.DoctorName).Select(s => s.Id).Single(); if (SURGERYROOMName == null) { FR.Start_Hour = start; //ob.From; FR.End_Hour = end; FR.Hospital_Facility_Id = HID; //FR.Hospital_Facility_Id =no ; FR.Patient_Id = (int)TempData["Patient_Id"]; FR.Staff_Id = (int)TempData["Staff_Id"]; _asu.Add(FR); P1.Patient_Id = (int)TempData["Patient_Id"]; P1.Money = Totalroomprice; P1.Follow_Up_Type_Id = RoompriceId; _asu.Add(P1); _asu.SaveChanges(); ViewBag.UserMessage2 = "Done"; return(View()); } else { var SHID = _asu.Hospital_Facilities.Where(f => f.Type == SURGERYROOMName).Select(s => s.Id).Single(); F.Start_Hour = surgerystart; //ob.From; F.End_Hour = surgeryend; F.Hospital_Facility_Id = SHID; //FR.Hospital_Facility_Id =no ; F.Patient_Id = (int)TempData["Patient_Id"]; F.Staff_Id = (int)TempData["Staff_Id"]; _asu.Add(F); FR.Start_Hour = start; //ob.From; FR.End_Hour = end; FR.Hospital_Facility_Id = HID; //FR.Hospital_Facility_Id =no ; FR.Patient_Id = (int)TempData["Patient_Id"]; FR.Staff_Id = (int)TempData["Staff_Id"]; _asu.Add(FR); P.Patient_Id = (int)TempData["Patient_Id"]; P.Money = surgeryprice; P.Follow_Up_Type_Id = surgeryId; _asu.Add(P); P1.Patient_Id = (int)TempData["Patient_Id"]; P1.Money = Totalroomprice; P1.Follow_Up_Type_Id = RoompriceId; _asu.Add(P1); _asu.SaveChanges(); ViewBag.UserMessage2 = "Done"; return(View()); } } else { ViewBag.UserMessage1 = "This doctor is not in our hospital"; return(View()); } } else { ViewBag.UserMessage3 = "This doctor is not from the staff."; return(View()); //return Redirect("/Front_desk/PatientMESSAGE"); } }