public IActionResult ConsumeDrug(int id, int quantity)
{
var drugToConsume = _db.Drug.Single(d => d.DrugId == id);
if (drugToConsume.Quantity >= quantity)
{
drugToConsume.Quantity -= quantity;
var drugchanges = new DrugChanges()
{
Date = DateTime.Now,
DrugId = drugToConsume.DrugId,
Drug = drugToConsume,
Increasing = false,
Quantity = quantity,
SupplierName = ""
};
_db.DrugChanges.Add(drugchanges);
_db.Drug.Update(drugToConsume);
_db.SaveChanges();
return(RedirectToAction("DrugsList", "Home"));
}
if (drugToConsume.Quantity < quantity)
{
return(RedirectToAction("ErrorDrugConsuming", "Home", new { consuming = quantity, drugQuantity = drugToConsume.Quantity, drugName = drugToConsume.Name }));
}
return(RedirectToAction("DrugsList", "Home"));
}
public IActionResult SubmitOrder(string[] drug, int[] quantity, int[] price, string supplier)
{
for (int i = 0; i < drug.Length; i++)
{
var newDrug = _db.Drug.Single(d => d.Name == drug[i]);
newDrug.Quantity = quantity[i] * price[i];
_db.Update(newDrug);
var drugchanges = new DrugChanges()
{
DrugId = newDrug.DrugId,
Drug = newDrug,
Increasing = true,
Quantity = newDrug.Quantity,
SupplierName = supplier,
Date = DateTime.Now
};
_db.DrugChanges.Add(drugchanges);
_db.SaveChanges();
}
return(View());
}
public IActionResult AddSupplyStep3(int drugId, int quantity, float price, int supplierId, string command, string prevPrice)
{
var drug = _db.Drug.Single(d => d.DrugId == drugId);
var supply = _db.Supply.OrderByDescending(s => s.SupplyId).FirstOrDefault();
var lot = new Lot()
{
DrugId = drug.DrugId,
Grug = drug,
Quantity = quantity,
Price = price,
Supply = supply,
SupplyId = supply.SupplyId
};
drug.Quantity += quantity;
_db.Drug.Update(drug);
_db.Lot.Add(lot);
var supplier = _db.Supplier.Single(s => s.SupplierId == supplierId);
var drugchanges = new DrugChanges()
{
DrugId = drug.DrugId,
Drug = drug,
Increasing = true,
Quantity = quantity,
SupplierName = supplier.CompanyName
};
_db.DrugChanges.Add(drugchanges);
_db.SaveChanges();
if (command.Equals("Finish"))
{
return(RedirectToAction("AddSupplyStep4", "Home", new { id = supply.SupplyId, price = price * quantity + Convert.ToInt32(prevPrice) }));
}
return(RedirectToAction("AddSupplyStep2", "Home", new { supplierId = supplier.SupplierId, repeat = true, price = price * quantity + prevPrice }));
}
public IActionResult AddDrug(DrugAndHerbViewModel drugAndHerbs, IEnumerable <string> TBoxes)
{
var herbsList = new List <Herb>();
foreach (var str in TBoxes)
{
if (!string.IsNullOrEmpty(str))
{
var herb = new Herb {
Name = str.Trim(), Description = "", Species = ""
};
herbsList.Add(herb);
if (_db.Herb.FirstOrDefault(h => string.Equals(h.Name, herb.Name, StringComparison.CurrentCultureIgnoreCase)) == null)
{
_db.Herb.Add(herb);
}
}
}
var drugToAdd = drugAndHerbs.Drug;
_db.Drug.Add(drugToAdd);
_db.SaveChanges();
var drugToC = _db.Drug.OrderBy(d => d.DrugId).LastOrDefault();
var herbsToC = new List <Herb>();
foreach (var h in herbsList)
{
herbsToC.Add(_db.Herb.Single(p => p.Name == h.Name));
}
if (herbsToC.Count != 0)
{
foreach (var herb in herbsToC)
{
var compound = new Compound()
{
Drug = drugToC, Herb = herb, DrugId = drugToC.DrugId, HerbId = herb.HerbId
};
_db.Compound.Add(compound);
}
}
var drugchanges = new DrugChanges()
{
Date = DateTime.Now,
DrugId = drugToC.DrugId,
Drug = drugToC,
Increasing = false,
Quantity = drugToC.Quantity,
SupplierName = ""
};
_db.DrugChanges.Add(drugchanges);
_db.SaveChanges();
return(RedirectToAction("DrugsList", "Home"));
}