public ActionResult DeleteConfirmed(long id) { var modelDP = new DeletedProduct(); //adding product to deletedProduct table modelDP.Product_ID = id; db.DeletedProduct.Add(modelDP); Product product = db.Product.Find(id); //making quantity zero of deleted product product.ProductQuantity = 0; db.Entry(product).State = EntityState.Modified; var modelT = db.Trend.Where(t => t.Product_ID == id).FirstOrDefault(); //remove from trending if (modelT != null) { db.Trend.Remove(modelT); } var modelTR = db.TrendRequest.Where(t => t.Product_ID == id).FirstOrDefault(); //remove from trend Request if (modelTR != null) { db.TrendRequest.Remove(modelTR); } db.SaveChanges(); return(RedirectToAction("Index")); }
public IActionResult Delete(int id, Product product) { try { var item = procuctDb.Products.Find(id); var itemPictures = procuctDb.Pictures.Where(x => x.ProductID == id).ToList(); var properies = procuctDb.Properties.Where(x => x.ProductId == id).ToList(); procuctDb.Properties.RemoveRange(properies); foreach (var itemPicture in itemPictures) { ImageExtension.DeleteImage(itemPicture.PhotoUrl, hostEnvironment); } procuctDb.Pictures.RemoveRange(itemPictures); procuctDb.Products.Remove(item); procuctDb.SaveChanges(); DeletedProduct deleted = new DeletedProduct { DeletedDate = DateTime.Today, Name = item.Name, DeletedId = item.Id }; procuctDb.DeletedProducts.Add(deleted); procuctDb.SaveChanges(); return(RedirectToAction(nameof(Index))); } catch { return(RedirectToAction(nameof(Delete), id)); } }
public void DeleteProductButton(object sender, RoutedEventArgs e) { if (nameProduct.Text.Length == 0) { MessageBox.Show("норм вводи"); return; } else if (!CheckName(nameProduct.Text)) { MessageBox.Show("продукта такого нет"); return; } else { name = nameProduct.Text; } using (var context = new ProductContext()) { var product = context.Products.Where(prod => prod.NameProduct.Contains(name)).FirstOrDefault(); var deletedProduct = new DeletedProduct { ProductId = product.Id, NameProduct = product.NameProduct, PriceProduct = product.PriceProduct }; context.DeletedProducts.Add(deletedProduct); context.SaveChanges(); for (int i = 0; i < context.Products.ToList().Count; i++) { if (context.Products.ToList()[i].NameProduct == name) { context.Products.ToList().RemoveAt(i); break; } } context.SaveChanges(); MessageBox.Show("продукт удален"); } Close(); }
public ActionResult DeleteConfirmed(int id) { var modelDP = new DeletedProduct(); var modelDS = new DeletedSeller(); modelDS.Seller_ID = id; db.DeletedSeller.Add(modelDS); var modelP = db.Product.Where(p => p.Seller_ID == id).ToList(); var modelPR = db.ProductRequest.Where(p => p.Product.Seller_ID == id).Select(p => p.Product).ToList(); foreach (var pro in modelPR) //deleting product which are not approved by admin { modelP.Remove(pro); //var model = db.ProductRequest.Where(p => p.ID == pro.ID).FirstOrDefault(); db.Product.Remove(pro); db.SaveChanges(); } foreach (var pro in modelP) { pro.ProductQuantity = 0; db.Entry(pro).State = EntityState.Modified; modelDP.Product_ID = pro.ID; var modelT = db.Trend.Where(p => p.Product_ID == pro.ID).FirstOrDefault(); //removing product from Trend table if (modelT != null) { db.Trend.Remove(modelT); } var modelTR = db.TrendRequest.Where(p => p.Product_ID == pro.ID).FirstOrDefault(); //removing product from TrendRequest table if (modelTR != null) { db.TrendRequest.Remove(modelTR); } db.DeletedProduct.Add(modelDP); db.SaveChanges(); } db.SaveChanges(); return(RedirectToAction("Index")); }
public RegisteredProduct Delete(DeletedProduct Id) { throw new NotImplementedException(); }