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