public ActionResult DeleteProduct(int id)
{
tbl_Product tb = _db.tbl_Product.Where(u => u.ProductId == id).FirstOrDefault();
ProductViewModel pvm = new ProductViewModel();
pvm.ProductId = tb.ProductId;
pvm.ProductName = tb.ProductName;
pvm.ProductDescription = tb.ProductDescription;
pvm.ProductPackingDate = tb.ProductPackingDate;
pvm.ProductExpireDate = tb.ProductExpireDate;
tbl_Deals td = _db.tbl_Deals.Where(u => u.DealsId == id).FirstOrDefault();
pvm.DealsName = td.DealsName;
tbl_ProductCategory tpc = _db.tbl_ProductCategory.Where(u => u.CategoryId == tb.CategoryId).FirstOrDefault();
pvm.CategoryName = tpc.CategoryName;
tbl_ProductStatus tpss = _db.tbl_ProductStatus.Where(u => u.StatusId == tb.StatusId).FirstOrDefault();
pvm.StatusName = tpss.StatusName;
tbl_ProductStore tps = _db.tbl_ProductStore.Where(u => u.ProductId == tb.ProductId).FirstOrDefault();
tbl_Store ts = _db.tbl_Store.Where(u => u.StoreId == tps.StoreId).FirstOrDefault();
pvm.StoreName = ts.StoreName;
return(View(pvm));
}
public ActionResult InsertProduct(ProductViewModel pvm)
{
InitCommon();
if (ModelState.IsValid)
{
if (pvm.StoreId == 0 || pvm.CategoryId == 0 || pvm.DealsId == 0)
{
ModelState.AddModelError(string.Empty, "you can not leave the empty dropdown please select any of these");
}
try
{
tbl_Product product = new tbl_Product();
tbl_ProductStore store = new tbl_ProductStore();
product.ProductName = pvm.ProductName;
product.ProductDescription = pvm.ProductDescription;
product.ProductPackingDate = pvm.ProductPackingDate;
product.ProductExpireDate = pvm.ProductExpireDate;
if (pvm.DealsId != null)
{
product.DealsId = pvm.DealsId;
}
else
{
product.DealsId = null;
}
if (pvm.CategoryId != null)
{
product.CategoryId = pvm.CategoryId;
}
else
{
product.CategoryId = null;
}
if (pvm.StatusId != null)
{
product.StatusId = pvm.StatusId;
}
else
{
product.StatusId = null;
}
store.StoreId = pvm.StoreId;
store.ProductId = pvm.ProductId;
_db.tbl_Product.Add(product);
_db.tbl_ProductStore.Add(store);
_db.SaveChanges();
ViewBag.Message = "Product Created Successfully.";
return(RedirectToAction("Product"));
}
catch (Exception e)
{
return(View("Error", new HandleErrorInfo(e, "Admin", "CreateProduct")));
}
}
return(View());
}
public ActionResult DeleteProducts(int id)
{
tbl_Product tb = _db.tbl_Product.Where(u => u.ProductId == id).FirstOrDefault();
tbl_ProductStore productstore = _db.tbl_ProductStore.Where(u => u.ProductId == tb.ProductId).FirstOrDefault();
_db.tbl_Product.Remove(tb);
if (productstore != null)
{
_db.tbl_ProductStore.Remove(productstore);
}
_db.SaveChanges();
return(RedirectToAction("Product"));
}
public ActionResult EditProduct(ProductViewModel pvm)
{
tbl_Product product = _db.tbl_Product.Where(p => p.ProductId == pvm.ProductId).FirstOrDefault();
tbl_ProductStore store = _db.tbl_ProductStore.Where(p => p.ProductId == pvm.ProductId).FirstOrDefault();
product.ProductName = pvm.ProductName;
product.ProductDescription = pvm.ProductDescription;
product.DealsId = pvm.DealsId;
product.StatusId = pvm.StatusId;
product.CategoryId = pvm.CategoryId;
product.ProductPackingDate = pvm.ProductPackingDate;
product.ProductExpireDate = pvm.ProductExpireDate;
store.ProductId = pvm.ProductId;
store.StoreId = pvm.StoreId;
_db.SaveChanges();
ViewBag.Message = "Product Updated Successfully.";
return(RedirectToAction("Product"));
}
