public ActionResult EditPatient(int id) { HMS_DBEntity db = new HMS_DBEntity(); List <tblPatientBillDetail> list = db.tblPatientBillDetails.ToList(); PatientBillViewModel model = new PatientBillViewModel(); if (id > 0) { tblPatientBillDetail detail = db.tblPatientBillDetails.SingleOrDefault(x => x.ID == id && x.is_active == true); model.ID = detail.ID; model.PatientBillID = detail.PatientBillID; model.Amount = detail.Amount; model.Description = detail.Description; } return(View(model)); }
public ActionResult Edit(PatientBillViewModel model) { string username = ""; HttpCookie cookie = HttpContext.Request.Cookies["AdminCookies"]; if (cookie != null) { username = Convert.ToString(cookie.Values["UserName"]); } if (model.ID > 0) { //update tblPatientBillDetail emp = db.tblPatientBillDetails.SingleOrDefault(x => x.ID == model.ID && x.is_active == true); emp.PatientBillID = model.PatientBillID; emp.Amount = model.Amount; emp.CreatedAt = DateTime.UtcNow; emp.CreatedBy = username; emp.Description = model.Description; db.SaveChanges(); var tblPatientBill2 = db.tblPatientBills.FirstOrDefault(x => x.ID == emp.PatientBillID && x.is_active == true); var tblPatientBill = db.tblPatientBills.Where(x => x.ID == emp.PatientBillID && x.is_active == true).ToList(); if (tblPatientBill.Count != 0) { var lst = db.tblPatientBillDetails .Where(x => x.PatientBillID == tblPatientBill2.ID && x.is_active == true) .ToList(); foreach (var patientBill in tblPatientBill) { patientBill.Amount = lst.Where(b => b.PatientBillID == tblPatientBill2.ID).Select(c => c.Amount).Sum(); } db.SaveChanges(); } return(Redirect("/EditBill?id=" + emp.PatientBillID)); } else { return(View()); } }
public ActionResult Delete(int?id, DeleteViewModel model) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DeleteViewModel deleteViewModel = new DeleteViewModel(); deleteViewModel.billmodel = new PatientsBillViewModel(); deleteViewModel.billdetailmodel = new PatientsBillDetailViewModel(); tblPatientBill bill = db.tblPatientBills.Find(id); tblPatientBillDetail billdetail = db.tblPatientBillDetails.Find(id); if (bill != null) { deleteViewModel.billmodel.ID = bill.ID; deleteViewModel.billmodel.PatientAppointmentID = bill.PatientAppointmentID; deleteViewModel.billmodel.BillNo = bill.BillNo; deleteViewModel.billmodel.Amount = bill.Amount; deleteViewModel.billmodel.Discount = bill.Discount; deleteViewModel.billmodel.CreatedAt = bill.CreatedAt; deleteViewModel.billmodel.CreatedBy = bill.CreatedBy; deleteViewModel.billmodel.Description = bill.Description; } if (billdetail != null) { deleteViewModel.billdetailmodel.ID = billdetail.ID; deleteViewModel.billdetailmodel.PatientBillID = billdetail.PatientBillID; deleteViewModel.billdetailmodel.Amount = billdetail.Amount; deleteViewModel.billdetailmodel.CreatedAt = billdetail.CreatedAt; deleteViewModel.billdetailmodel.CreatedBy = billdetail.CreatedBy; deleteViewModel.billdetailmodel.Description = billdetail.Description; } return(View(deleteViewModel)); }
public ActionResult Create(string nameValueInsert, string nameValueSubmit, CreateBillViewModel model, int?Patient_id) { var button = nameValueInsert ?? nameValueSubmit; if (button == "Insert") { if (Session["templist"] == null) { List <PatientViewModel> lst = new List <PatientViewModel>(); lst.Add(new PatientViewModel() { PatientAppointmentID = Int32.Parse(Request.Form["PatientAppointmentID"]), // BillNo = Request.Form["BillNo"], Amount = double.Parse(Request.Form["Amount"]), Description = Request.Form["Description"] }); Session["templist"] = lst; } else { List <PatientViewModel> lst = (List <PatientViewModel>)Session["templist"]; lst.Add(new PatientViewModel() { PatientAppointmentID = Int32.Parse(Request.Form["PatientAppointmentID"]), // BillNo = Request.Form["BillNo"], Amount = double.Parse(Request.Form["Amount"]), Description = Request.Form["Description"] }); Session["templist"] = lst; } } else { if (ModelState.IsValid) { string username = ""; HttpCookie cookie = HttpContext.Request.Cookies["AdminCookies"]; if (cookie != null) { username = Convert.ToString(cookie.Values["UserName"]); } tblPatientBill patientbill = new tblPatientBill(); patientbill.PatientAppointmentID = model.PatientAppointmentID; // patientbill.BillNo = model.ID; patientbill.Amount = model.AmountTotal; patientbill.Description = model.Note; patientbill.Discount = model.Discount; patientbill.CreatedAt = model.CreatedAt; patientbill.CreatedBy = username; patientbill.is_active = true; db.tblPatientBills.Add(patientbill); db.SaveChanges(); int PatientBill_ID = Convert.ToInt32(patientbill.ID); List <PatientViewModel> lst = (List <PatientViewModel>)Session["templist"]; if (lst != null) { tblPatientBillDetail billdetail = new tblPatientBillDetail(); foreach (var item in lst) { billdetail.PatientBillID = PatientBill_ID; billdetail.Amount = item.Amount; billdetail.CreatedAt = DateTime.UtcNow; billdetail.CreatedBy = username; billdetail.Description = item.Description; billdetail.is_active = true; db.tblPatientBillDetails.Add(billdetail); db.SaveChanges(); } Session.Clear(); } return(RedirectToAction("Print", new { Billid = @PatientBill_ID })); } } model.PatientAppointmentDate = (from p in db.tblPatientAppointments where p.patient_id == Patient_id select new SelectListItem { Text = p.AppointmentDate, Value = p.ID.ToString() }).ToList(); return(View(model)); }