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