public ActionResult CategoryEdit(int?id, string name, int stockId) { if (id != null) { GreenhouseCategory category = _db.GreenhouseCategories.Include(s => s.Stock).FirstOrDefault(c => c.Id == id); Stock categoryStock = _db.Stocks.FirstOrDefault(s => s.Id == stockId); category.Name = name; category.Stock = categoryStock; _db.SaveChanges(); return(RedirectToAction("Categories", "Admin")); } Stock newCategoryStock = _db.Stocks.FirstOrDefault(s => s.Id == stockId); GreenhouseCategory newCategory = new GreenhouseCategory() { Name = name, Stock = newCategoryStock }; _db.GreenhouseCategories.Add(newCategory); _db.SaveChanges(); return(RedirectToAction("Categories", "Admin")); }
public ActionResult CategoryEdit(int?id) { ViewBag.Stocks = _db.Stocks; if (id == null) { return(View()); } GreenhouseCategory category = _db.GreenhouseCategories.Include(s => s.Stock).FirstOrDefault(c => c.Id == id); return(View(category)); }
public ActionResult CategoryDelete(int id) { GreenhouseCategory category = _db.GreenhouseCategories.FirstOrDefault(c => c.Id == id); IEnumerable <Greenhouse> greenhouse = _db.Greenhouses.Where(g => g.GetGreenhouseCategory.Id == category.Id); foreach (var gr in greenhouse) { var green = gr; category.Greenhouses.Remove(green); } _db.GreenhouseCategories.Remove(category); _db.SaveChanges(); return(RedirectToAction("Categories", "Admin")); }
public ActionResult GreenHouse(int?id, Greenhouse model, int getgreenhousecategory) { Greenhouse greenhouse = _db.Greenhouses.Include(g => g.PacksForGH).Include(g => g.GetGreenhouseCategory).FirstOrDefault(g => g.Id == id); GreenhouseCategory category = _db.GreenhouseCategories.FirstOrDefault(c => c.Id == getgreenhousecategory); greenhouse.Name = model.Name; greenhouse.GetGreenhouseCategory = category; greenhouse.Bonus = model.Bonus; greenhouse.CostPrice = model.CostPrice; foreach (var p in greenhouse.PacksForGH) { foreach (var pp in model.PacksForGH) { if (p.Id == pp.Id) { p.Amount = pp.Amount; } } } foreach (var p in model.PacksForGH) { if (p.Amount == 0) { var i = greenhouse.PacksForGH.FirstOrDefault(pf => pf.Id == p.Id); greenhouse.PacksForGH.Remove(i); } } foreach (var p in model.Packs) { if (p.Amount != 0) { Pack pack = _db.Packs.FirstOrDefault(pck => pck.Id == p.Id); greenhouse.PacksForGH.Add(new PackForGH { Name = pack.Name, Cost = pack.Cost, Amount = p.Amount }); } } _db.SaveChanges(); return(RedirectToAction("Index", "Admin")); }
public ActionResult GreenhouseAdd(int?id, Greenhouse model, int?categoryId) { Stock stock = _db.Stocks.FirstOrDefault(s => s.Id == id); GreenhouseCategory category = _db.GreenhouseCategories.FirstOrDefault(c => c.Id == categoryId); List <PackForGH> packsForGH = new List <PackForGH>(); List <Pack> packs = new List <Pack>(); foreach (var p in model.Packs) { if (p.Amount != 0) { Pack pack = _db.Packs.FirstOrDefault(pck => pck.Id == p.Id); packsForGH.Add(new PackForGH { Name = pack.Name, Cost = pack.Cost, Amount = p.Amount }); packs.Add(pack); } } Greenhouse g1 = new Greenhouse() { Name = model.Name, GetGreenhouseCategory = category, Packs = packs, PacksForGH = packsForGH, Bonus = model.Bonus, CostPrice = model.CostPrice }; stock.Greenhouses.Add(g1); _db.SaveChanges(); return(RedirectToAction("GreenhouseList", "Admin", new { id = id })); }