public static ProductPoco ProductToPoco(ShopAroundEntities Dbcontext, PRODUCT product) { ProductPoco poco = new ProductPoco(); poco.Product = product; poco.Brand = Dbcontext.BRANDS.Find(product.FK_Brands); poco.Category = Dbcontext.CATEGORIES.Find(product.Fk_Categories); poco.Type = Dbcontext.TYPES.Find(product.Fk_Type); poco.Vat = Dbcontext.VATs.Find(product.Fk_VAT); return poco; }
public ActionResult Create(ProductPoco prod) { if (ModelState.IsValid) if (prod != null) { var resultProduct = Dbcontext.setProduct(prod.Product.Reference, prod.Product.Availability, prod.Product.Description, prod.Product.Price, prod.Product.Name, prod.Product.Image, prod.Product.Fk_VAT, prod.Product.FK_Brands, prod.Product.Fk_Categories, prod.Product.Fk_Type).FirstOrDefault(); if (resultProduct != 0) return RedirectToAction("Index"); else ModelState.AddModelError("", "Erreur: Les informations sont incorrectes"); } else ModelState.AddModelError("", "Erreur: Le modèle n'est pas valide"); ViewBag.Brands = new SelectList(Dbcontext.BRANDS, "Id", "Name"); ViewBag.Categories = new SelectList(Dbcontext.CATEGORIES, "Id", "Name"); ViewBag.Types = new SelectList(Dbcontext.TYPES, "Id", "Name"); ViewBag.Vats = new SelectList(Dbcontext.VATs, "Id", "Tax"); return View(); }
public ActionResult Edit(int id) { PRODUCT product = Dbcontext.PRODUCTS.Find(id); ProductPoco poco = new ProductPoco(); poco.Product= product; //Le FK_Adresse correspond à l'adresse principal poco.Brand = Dbcontext.BRANDS.Find(product.FK_Brands); poco.Category = Dbcontext.CATEGORIES.Find(product.Fk_Categories); poco.Type = Dbcontext.TYPES.Find(product.Fk_Type); poco.Vat = Dbcontext.VATs.Find(product.Fk_VAT); //Préparation de la vue ViewBag.Brands = new SelectList(Dbcontext.BRANDS, "Id", "Name"); ViewBag.Categories = new SelectList(Dbcontext.CATEGORIES, "Id", "Name"); ViewBag.Types = new SelectList(Dbcontext.TYPES, "Id", "Name"); ViewBag.Vats = new SelectList(Dbcontext.VATs, "Id", "Tax"); ViewBag.Id = id; return View(poco); }
public ActionResult Edit(ProductPoco prod, string mySubmit) { if (mySubmit == "Modifier le produit") { if (ModelState.IsValid) if (prod != null) { Dbcontext.Entry(prod.Product).State = EntityState.Modified; Dbcontext.Entry(Dbcontext.BRANDS.Find(prod.Product.FK_Brands)).State = EntityState.Modified; Dbcontext.Entry(Dbcontext.BRANDS.Find(prod.Product.Fk_Categories)).State = EntityState.Modified; Dbcontext.Entry(Dbcontext.BRANDS.Find(prod.Product.Fk_Type)).State = EntityState.Modified; Dbcontext.Entry(Dbcontext.BRANDS.Find(prod.Product.Fk_VAT)).State = EntityState.Modified; if (Dbcontext.SaveChanges() > 0) return RedirectToAction("Index"); else ModelState.AddModelError("", "Erreur: Les informations sont incorrectes"); } else ModelState.AddModelError("", "Erreur: Le modèle n'est pas valide"); } else if (mySubmit == "Supprimer le produit") { Dbcontext.Entry(prod.Product).State = EntityState.Deleted; Dbcontext.SaveChanges(); return RedirectToAction("Index"); } ViewBag.Brands = new SelectList(Dbcontext.BRANDS, "Id", "Name"); ViewBag.Categories = new SelectList(Dbcontext.CATEGORIES, "Id", "Name"); ViewBag.Types = new SelectList(Dbcontext.TYPES, "Id", "Name"); ViewBag.Vats = new SelectList(Dbcontext.VATs, "Id", "Tax"); return View(prod); }