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