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 DeleteProductStatuss(int id)
{
tbl_ProductStatus tb = _db.tbl_ProductStatus.Where(u => u.StatusId == id).FirstOrDefault();
_db.tbl_ProductStatus.Remove(tb);
_db.SaveChanges();
return(RedirectToAction("ProductStatus"));
}
public ActionResult EditProductStatus(int id)
{
tbl_ProductStatus tb = _db.tbl_ProductStatus.Where(p => p.StatusId == id).FirstOrDefault();
StatusViewModel svm = new StatusViewModel();
svm.StatusId = tb.StatusId;
svm.StatusName = tb.StatusName;
return(View(svm));
}
public ActionResult EditProductStatuss(StatusViewModel svm)
{
if (ModelState.IsValid)
{
try
{
tbl_ProductStatus status = _db.tbl_ProductStatus.Where(p => p.StatusId == svm.StatusId).FirstOrDefault();
status.StatusId = svm.StatusId;
status.StatusName = svm.StatusName;
_db.SaveChanges();
ViewBag.Message = "ProductStatus Updated Successfully.";
return(RedirectToAction("ProductStatus"));
}
catch (Exception e)
{
return(View("Error", new HandleErrorInfo(e, "Admin", "EditProductStatus")));
}
}
return(RedirectToAction("ProductStatus"));
}
public ActionResult InsertProductStatus(StatusViewModel svm)
{
if (ModelState.IsValid)
{
try
{
tbl_ProductStatus status = new tbl_ProductStatus();
status.StatusId = svm.StatusId;
status.StatusName = svm.StatusName;
_db.tbl_ProductStatus.Add(status);
_db.SaveChanges();
ViewBag.Message = "Status Created Successfully.";
return(RedirectToAction("ProductStatus"));
}
catch (Exception e)
{
return(View("Error", new HandleErrorInfo(e, "Admin", "InsertProductStatus")));
}
}
return(View());
}
