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();
}
