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