// GET: Sales/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalesObjectclass salesobj = new SalesObjectclass();
Sale sale = db.Sales.Find(id);
salesobj.Sold_Id = sale.Sold_Id;
MedicinePotency medpot = db.MedicinePotencies.FirstOrDefault(mp => mp.MedPot_Id == sale.MedPot_Id);
salesobj.Medicine_Id = medpot.Medicine_Id;
salesobj.Potency_Id = medpot.Potency_Id;
salesobj.NoOfItem = sale.NoOfItem;
salesobj.Staff_Id = sale.Staff_Id;
salesobj.Date = sale.Date;
salesobj.Customer_Id = sale.Customer_Id;
if (sale == null)
{
return(HttpNotFound());
}
ViewBag.Customer_Id = new SelectList(db.Customers, "Customer_Id", "Customer_Name", sale.Customer_Id);
ViewBag.MedPot_Id = new SelectList(db.MedicinePotencies, "MedPot_Id", "MedPot_Id", sale.MedPot_Id);
ViewBag.Medicine_Id = new SelectList(db.Medicines, "Medicine_Id", "Name", sale.MedicinePotency.Medicine.Medicine_Id);
ViewBag.Potency_Id = new SelectList(db.Potencies, "Potency_Id", "Potency_mg", sale.MedicinePotency.Potency.Potency_Id);
//ViewBag.Staff_Id = new SelectList(db.Staffs, "Id", "Name", sale.Staff.Person.Id);
ViewBag.Staff_Id = new SelectList(db.People, "Id", "FirstName", sale.Staff.Person.Id);
return(View(salesobj));
}
public ActionResult Create([Bind(Include = "Sold_Id,NoOfItem,Date,Staff_Id,Customer_Id,Medicine_Id,Potency_Id")] SalesObjectclass salesobj)
{
Sale sale = new Sale();
MedicinePotency medpot = db.MedicinePotencies.FirstOrDefault(u => u.Medicine_Id == salesobj.Medicine_Id && u.Potency_Id == salesobj.Potency_Id);
if (medpot != null)
{
if (medpot.NoOfItem >= salesobj.NoOfItem)
{
if (ModelState.IsValid)
{
sale.MedPot_Id = medpot.MedPot_Id;
sale.NoOfItem = salesobj.NoOfItem;
sale.Staff_Id = salesobj.Staff_Id;
sale.Date = salesobj.Date;
sale.Customer_Id = salesobj.Customer_Id;
db.Sales.Add(sale);
db.SaveChanges();
medpot.NoOfItem = (medpot.NoOfItem) - (salesobj.NoOfItem);
db.Entry(medpot).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ModelState.AddModelError("NoOfItem", "Medicine is out of stock.");
ViewBag.Customer_Id = new SelectList(db.Customers, "Customer_Id", "Customer_Name", salesobj.Customer_Id);
ViewBag.Medicine_Id = new SelectList(db.Medicines, "Medicine_Id", "Name", salesobj.Medicine_Id);
ViewBag.Potency_Id = new SelectList(db.Potencies, "Potency_Id", "Potency_mg", salesobj.Potency_Id);
ViewBag.Staff_Id = new SelectList(db.People, "Id", "FirstName", salesobj.Staff_Id);
return(View(salesobj));
}
}
ViewBag.Customer_Id = new SelectList(db.Customers, "Customer_Id", "Customer_Name", salesobj.Customer_Id);
ViewBag.Medicine_Id = new SelectList(db.Medicines, "Medicine_Id", "Name", salesobj.Medicine_Id);
ViewBag.Potency_Id = new SelectList(db.Potencies, "Potency_Id", "Potency_mg", salesobj.Potency_Id);
ViewBag.Staff_Id = new SelectList(db.People, "Id", "FirstName", salesobj.Staff_Id);
return(View(salesobj));
}
