public ActionResult Contact() { using (var context = new MyContext()) { return View(context.Employees.ToList()); } }
public ActionResult Edit(int bundleId) { using (var context = new MyContext()) { Bundle bundle = context.Bundles.Find(bundleId); var products = context.Products.ToList(); return View(new BundleVM { Bundle = bundle, Products = products }); } }
public ActionResult Create() { using (var context = new MyContext()) { var bundle = new Bundle(); bundle.BannerUrl = "~/Content/img/default.jpg"; var products = context.Products.ToList(); return View(new BundleVM { Bundle = bundle, Products = products }); } }
// GET: Bundle public ActionResult Index() { using (var context = new MyContext()) { List<Bundle> bundles = context.Bundles .Include("Products").ToList(); return View(bundles); } }
public ActionResult Reset() { using (var context = new MyContext()) { context.Database.ExecuteSqlCommand("DROP TABLE Products"); context.Database.ExecuteSqlCommand("DROP TABLE Bundles"); context.Database.ExecuteSqlCommand("DROP TABLE Employees"); context.SaveChanges(); return RedirectToAction("Index"); } }
private void SaveBundle(BundleVM bundleVM) { Bundle bundle; using (var context = new MyContext()) { if(bundleVM.Bundle.Id == 0){ bundle = new Bundle(); context.Bundles.Add(bundle); } else{ bundle = context.Bundles.Include("Products") .First(b => b.Id == bundleVM.Bundle.Id); } bundle.Name = bundleVM.Bundle.Name; bundle.Description = bundleVM.Bundle.Description; bundle.RiotPoints = bundleVM.Bundle.RiotPoints; bundle.BannerUrl = bundleVM.Bundle.BannerUrl; bundle.Products = bundleVM.ProductIds.Select(pi => context.Products.Find(pi)).ToList(); context.SaveChanges(); } }