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