public ActionResult Create([Bind(Include = "patient_id,admission_date,doctor_assigned,disease,room_assigned")] inpatient inpatient) { try { if (inpatient.admission_date > DateTime.Now) { ModelState.AddModelError("admission_date", "Date should be less than todays date."); } if (db.inpatients.Where(u => u.patient_id == inpatient.patient_id).First() != null) { } if (ModelState.IsValid) { db.inpatients.Add(inpatient); db.rooms.Where(r => r.room_id == inpatient.room_assigned).First().patient_id = inpatient.patient_id; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.roomlist = db.rooms.ToList(); ViewBag.doctors = db.doctors.ToList(); return(View(inpatient)); } catch { ModelState.AddModelError("patient_id", "Patient already inpatient."); ViewBag.roomlist = db.rooms.ToList(); ViewBag.doctors = db.doctors.ToList(); return(View(inpatient)); } }
public ActionResult Edit([Bind(Include = "patient_id,admission_date,doctor_assigned,disease,room_assigned")] inpatient inpatient) { if (ModelState.IsValid) { db.Entry(inpatient).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(inpatient)); }
public ActionResult DeleteConfirmed(int id) { inpatient inpatient = db.inpatients.Find(id); db.inpatients.Remove(inpatient); try { db.rooms.Where(i => i.patient_id == inpatient.patient_id).First().patient_id = null; } catch { } db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: inpatients/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } inpatient inpatient = db.inpatients.Find(id); if (inpatient == null) { return(HttpNotFound()); } return(View(inpatient)); }
public ActionResult Search(FormCollection f) { try { string p = f["searchtextbox"]; int id = Convert.ToInt32(p); inpatient findp = db.inpatients.Where(t => t.patient_id == id).First(); if (findp != null) { int labcost = 0; int roomcharge = 0; List <lab> lablist = db.labs.Where(u => u.patient_id == findp.patient_id).ToList(); foreach (lab g in lablist) { labcost = labcost + g.test_cost; } room r = db.rooms.Where(y => y.patient_id == findp.patient_id).First(); DateTime d = findp.admission_date; double days = (DateTime.Today - d).TotalDays; if (days <= 0) { days = 1; } roomcharge = Convert.ToInt32(days * r.room_charge); Bill b = new Bill(); b.PatientName = db.patients.Where(o => o.patient_Id == findp.patient_id).First().Name; b.Patient_Id = findp.patient_id; b.RoomCharge = roomcharge; b.LabCharge = labcost; b.DoctorName = db.doctors.Where(l => l.doctor_id == findp.doctor_assigned).First().doctor_name; b.DaysAdmitted = days; b.TotalCost = roomcharge + labcost; return(View("Index", b)); } else { ViewBag.Invalid = "No Data Found"; return(View("Index", new Bill())); } } catch { ViewBag.Invalid = "No Data Found"; return(View("Index", new Bill())); } }