public IActionResult DetailsDrug(int id) { var drug = _db.Drug.Single(d => d.DrugId == id); var compound = _db.Compound.Include(c => c.Herb).Include(c => c.Drug).Where(c => c.DrugId == id).ToList(); var model = new DrugAndHerbViewModel { Compound = compound, Drug = drug }; return(View(model)); }
public IActionResult EditDrug(int id) { var drug = _db.Drug.Single(d => d.DrugId == id); //var compound = _db.Compound.Where(c => c.DrugId == id).ToList(); var comp = new List <Compound>(); var compList = _db.Compound.Include(c => c.Drug).Include(c => c.Herb).ToList(); foreach (var compound in compList) { if (compound.DrugId == id) { comp.Add(compound); } } var model = new DrugAndHerbViewModel { Compound = comp, Drug = drug }; return(View(model)); }
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")); }