public ActionResult AddPicture(PRODUCTPICTURE model)
{
if (ModelState.IsValid)
{
model.ProductId = Convert.ToInt32(Session["ID"]);
_db.PRODUCTPICTUREs.Add(model);
_db.SaveChanges();
return(RedirectToAction("AddPicture", "AdminHome"));
}
return(View(model));
}
public ActionResult DeleteConfirmed(long id)
{
SELLER seller = db.SELLERs.Find(id);
while (true) //To delete the product related to the seller
{
var product = db.PRODUCTs.Where(p => p.ProductSellerId == seller.SellerId).FirstOrDefault();
if (product == null)
{
break;
}
//return Redirect("/AdminProductView/Delete/" + product.ProductId);
PRODUCTDESCRIPTION productDescrption = db.PRODUCTDESCRIPTIONs.Where(d => d.ProductId == product.ProductId).FirstOrDefault();
if (productDescrption != null)
{
db.PRODUCTDESCRIPTIONs.Remove(productDescrption);
}
while (true)
{
PRODUCTPICTURE productPicture = db.PRODUCTPICTUREs.Where(d => d.ProductId == product.ProductId).FirstOrDefault();
if (productPicture == null)
{
break;
}
db.PRODUCTPICTUREs.Remove(productPicture);
db.SaveChanges();
}
db.PRODUCTs.Remove(product);
db.SaveChanges();
//finish
}
var count = db.SELLERs.Where(a => a.SellerAddressId == seller.SellerAddressId).Count(); //To check if the multiple seller beelong to that address
if (count == 1) //if only on seller belong to that address then delete the address with the seller
{
ADDRESS address = db.ADDRESSes.Where(a => a.AddressId == seller.SellerAddressId).FirstOrDefault();
db.ADDRESSes.Remove(address);
}
db.SELLERs.Remove(seller);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(long id)
{
PRODUCT product = db.PRODUCTs.Find(id);
PRODUCTDESCRIPTION productDescrption = db.PRODUCTDESCRIPTIONs.Where(d => d.ProductId == id).FirstOrDefault();
if (productDescrption != null)
{
db.PRODUCTDESCRIPTIONs.Remove(productDescrption);
}
db.PRODUCTs.Remove(product);
while (true)
{
PRODUCTPICTURE productPicture = db.PRODUCTPICTUREs.Where(d => d.ProductId == id).FirstOrDefault();
if (productPicture is null)
{
break;
}
db.PRODUCTPICTUREs.Remove(productPicture);
db.SaveChanges();
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
