public ActionResult DeleteConfirmed(int id) { MedicineTransaction medicineTransaction = db.MedicineTransactions.Find(id); db.MedicineTransactions.Remove(medicineTransaction); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult PostInputHistory(string doctorId, int patientId, VM_inputHistory history) { int id_history; var data = doctorService.scheduleDetail(doctorId, patientId); var historys = new MedicalHistory(); historys.Sickness = history.sick; historys.DoctorID = data.DoctorID; historys.PatientID = data.PatientID; historys.DescriptionInfo = history.descriptionSick; historys.CheckUpPrice = history.price; historys.CheckUpDate = DateTime.Now.Date; db.MedicalHistories.Add(historys); var getId = db.Schedules.Where(e => e.DoctorID == doctorId && e.BookingStatus == "Booking" && e.PatientID == data.PatientID).FirstOrDefault().ID; db.Schedules.Find(getId).BookingStatus = "Completed"; db.SaveChanges(); id_history = historys.ID; try { int leng = history.medicineId.Count(); for (var i = 0; i < leng; i++) { var patientMedic = new PatientMedicine(); decimal price = history.medicineId[i]; patientMedic.MedicalHistoryID = id_history; patientMedic.MedicineID = history.medicineId[i]; patientMedic.Quantity = history.quantity[i]; patientMedic.Description = history.describeMedic[i]; patientMedic.MedicalPrice = db.Medicines.Where(e => e.ID == price).First().Price; db.PatientMedicines.Add(patientMedic); db.SaveChanges(); } for (var j = 0; j < leng; j++) { var medicTrans = new MedicineTransaction(); medicTrans.MedicineID = history.medicineId[j]; medicTrans.DoctorID = data.DoctorID; medicTrans.TransactionDate = DateTime.Now; medicTrans.TransactionStatus = false; medicTrans.Quantity = history.quantity[j]; db.MedicineTransactions.Add(medicTrans); db.SaveChanges(); } } catch (Exception e) { return(RedirectToAction("Index")); } return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,medicineId,doctorId,statusTransaction,quantity")] MedicineTransaction medicineTransaction) { if (ModelState.IsValid) { db.Entry(medicineTransaction).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.doctorId = new SelectList(db.doctors, "id", "name", medicineTransaction.DoctorID); ViewBag.medicineId = new SelectList(db.Medicines, "id", "name", medicineTransaction.MedicineID); return(View(medicineTransaction)); }
// GET: medicineTransactions/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MedicineTransaction medicineTransaction = db.MedicineTransactions.Find(id); if (medicineTransaction == null) { return(HttpNotFound()); } return(View(medicineTransaction)); }
// GET: medicineTransactions/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MedicineTransaction medicineTransaction = db.MedicineTransactions.Find(id); if (medicineTransaction == null) { return(HttpNotFound()); } ViewBag.doctorId = new SelectList(db.doctors, "id", "name", medicineTransaction.DoctorID); ViewBag.medicineId = new SelectList(db.Medicines, "id", "name", medicineTransaction.MedicineID); return(View(medicineTransaction)); }
public ActionResult Create([Bind(Include = "ID,name,price,quantity,dateIn,ExpireDate,UnitOfMedicine,BenefitMedicine,MerkOfMedicine,QuantityOfMedicine")] Medicine medicine, [Bind(Include = "id,medicineId,statusTransaction,quantity")] MedicineTransaction medtrans, string NewProd) { var idLog = User.Identity.GetUserId(); var ids = db.doctors.Where(m => m.userId == idLog).First(); medicine.DateIn = DateTime.Today; ViewBag.getData = db.MedicineTransactions; var DataDB = db.Medicines.Where(e => e.DoctorID == ids.userId); bool result = false; var GetID = 0; if (NewProd.Contains("New")) { result = false; } else { foreach (var item in DataDB) { if (item.ID == medicine.ID) { result = true; break; } } } if (ModelState.IsValid) { if (result) { //medtrans.DoctorID = ids.userId; //medtrans.TransactionStatus = true; //medtrans.TransactionDate = DateTime.Now; //db.MedicineTransactions.Add(medtrans); var dateIn = db.Medicines.Where(m => m.ID == medicine.ID).First(); var getMedTrans = db.MedicineTransactions.Where(e => e.MedicineID == medicine.ID).First(); dateIn.DoctorID = ids.userId; dateIn.Name = medicine.Name; dateIn.Price = medicine.Price; dateIn.MerkOfMedicine = medicine.MerkOfMedicine; dateIn.UnitOfMedicine = medicine.UnitOfMedicine; dateIn.BenefitMedicine = medicine.BenefitMedicine; dateIn.Quantity = medicine.Quantity + dateIn.Quantity; dateIn.QuantityOfMedicine = medicine.QuantityOfMedicine; dateIn.ExpireDate = medicine.ExpireDate; getMedTrans.Quantity = dateIn.Quantity; db.Entry(getMedTrans).State = EntityState.Modified; db.Entry(dateIn).State = EntityState.Modified; db.SaveChanges(); //db.SaveChanges(); return(RedirectToAction("Index")); } else if (!result && medicine.ID != 0) { TempData["IsFromCreate"] = "failed"; return(RedirectToAction("Index")); } else { medtrans.DoctorID = ids.userId; medtrans.TransactionStatus = true; medtrans.TransactionDate = DateTime.Now; db.MedicineTransactions.Add(medtrans); medicine.DoctorID = ids.userId; db.Medicines.Add(medicine); db.SaveChanges(); TempData["IsFromCreate"] = "true"; return(RedirectToAction("Index")); } TempData["IsFromCreate"] = "true"; return(RedirectToAction("Index")); } ViewBag.doctorId = new SelectList(db.doctors, "id", "name", medicine.DoctorID); return(View(medicine)); }