public void DeleteProduct(int productId) { Product p = db.Products.Where(x => x.ProductID == productId).FirstOrDefault(); db.Products.Remove(p); db.SaveChanges(); }
public ActionResult Create(Product product) { if (product != null) { context.Products.Add(product); context.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Create(Category category) { if (category.CategoryName == null) { return(Content("You can't add an empty element in database")); } db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(Brand brand) { if (brand == null) { return(Content("You can not save a empty brand in database")); } db.Brands.Add(brand); db.SaveChanges(); return(RedirectToAction("Index", "Brands")); }
public ActionResult Create(Category category) { var Editedcategory = context.Categories.FirstOrDefault(c => c.CategoryID == category.CategoryID); if (Editedcategory != null) { Editedcategory.CategoryID = category.CategoryID; Editedcategory.CategoryName = category.CategoryName; context.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Create(Product p) { if (ModelState.IsValid) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); if (Request.Files.Count >= 1) { var file = Request.Files[0]; var imgBytes = new Byte[file.ContentLength]; file.InputStream.Read(imgBytes, 0, file.ContentLength); var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length); p.Photo = base64String; } db.Products.Add(p); db.SaveChanges(); return(RedirectToAction("Index")); } else { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); ViewBag.Categories = db.Categories.ToList(); ViewBag.Brands = db.Brands.ToList(); return(View()); } }
public ActionResult Create(Product p) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); db.Products.Add(p); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(Brand brand) { var Editedbrand = _context.Brands.FirstOrDefault(b => b.BrandID == brand.BrandID); //left side datebase values and right side form values. //assigning form values to database values. if (Editedbrand != null) { Editedbrand.BrandID = brand.BrandID; Editedbrand.BrandName = brand.BrandName; _context.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Delete(long id, Product p) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); Product existingProduct = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault(); db.Products.Remove(existingProduct); db.SaveChanges(); return(RedirectToAction("Index", "Products")); }
public ActionResult Delete(Product product) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); Product foundProduct = db.Products.Where(p => p.ProductID == product.ProductID).FirstOrDefault(); db.Products.Remove(foundProduct); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(Product p) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); Product existingProduct = db.Products.Where(temp => temp.ProductID == p.ProductID).FirstOrDefault(); existingProduct.ProductName = p.ProductName; existingProduct.Price = p.Price; existingProduct.DateOfPurchase = p.DateOfPurchase; existingProduct.CategoryID = p.CategoryID; existingProduct.BrandID = p.BrandID; existingProduct.AvailabilityStatus = p.AvailabilityStatus; existingProduct.Active = p.Active; db.SaveChanges(); return(RedirectToAction("Index", "Products")); }
public ActionResult Create(Product product) { try { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index", "Products")); } catch (Exception e) { ViewBag.message = e; return(View(ViewBag.message)); } }
public ActionResult Edit(Product product) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); Product foundProduct = db.Products.Where(p => p.ProductID == product.ProductID).FirstOrDefault(); foundProduct.ProductName = product.ProductName; foundProduct.Price = product.Price; foundProduct.DateOfPurchase = product.DateOfPurchase; foundProduct.AvailabilityStatus = product.AvailabilityStatus; foundProduct.CategoryID = product.CategoryID; foundProduct.BrandID = product.BrandID; foundProduct.Active = product.Active; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(Product product) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); if (Request.Files.Count >= 1) { var file = Request.Files[0]; var imgBytes = new Byte[file.ContentLength]; file.InputStream.Read(imgBytes, 0, file.ContentLength); var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length); product.Photo = base64String; } db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult UpdateProduct(Product product) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); Product exstingProduct = db.Products.Where(s => s.ProductID == product.ProductID).FirstOrDefault(); exstingProduct.ProductName = product.ProductName; exstingProduct.Price = product.Price; exstingProduct.DateOfPurchase = product.DateOfPurchase; exstingProduct.AvailabilityStatus = product.AvailabilityStatus; exstingProduct.Active = product.Active; exstingProduct.BrandID = product.BrandID; exstingProduct.CategoryID = product.CategoryID; db.SaveChanges(); return(Redirect("/Products/Index")); }
public ActionResult Create(Product prod) { Product p = new Product() { ProductID = prod.ProductID, ProductName = prod.ProductName, Price = prod.Price, DateOfPurchase = prod.DateOfPurchase, Active = prod.Active, BrandID = prod.BrandID, CategoryID = prod.CategoryID }; EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); db.Products.Add(p); db.SaveChanges(); // List<Product> products = db.Products.ToList(); return(Redirect("/Products/Index")); }
public ActionResult Edit(Product p) { EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities(); if (ModelState.IsValid) { Product existingProduct = db.Products.Where(temp => temp.ProductID == p.ProductID).FirstOrDefault(); existingProduct.ProductName = p.ProductName; existingProduct.Price = p.Price; existingProduct.DateOfPurchase = p.DateOfPurchase; existingProduct.CategoryID = p.CategoryID; existingProduct.BrandID = p.BrandID; existingProduct.AvailabilityStatus = p.AvailabilityStatus; existingProduct.Active = p.Active; db.SaveChanges(); return(RedirectToAction("Index", "Products")); } else { ViewBag.Categories = db.Categories.ToList(); ViewBag.Brands = db.Brands.ToList(); return(View(db.Products.Where(temp => temp.ProductID == p.ProductID).FirstOrDefault())); } }