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 DeleteCategories(int id) { tbl_ProductCategory tb = _db.tbl_ProductCategory.Where(u => u.CategoryId == id).FirstOrDefault(); _db.tbl_ProductCategory.Remove(tb); _db.SaveChanges(); return(RedirectToAction("Category")); }
public ActionResult DeleteConfirmed(short id) { tbl_ProductCategory tbl_ProductCategory = db.tbl_ProductCategory.Find(id); db.tbl_ProductCategory.Remove(tbl_ProductCategory); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult EditCategory(int id) { tbl_ProductCategory tb = _db.tbl_ProductCategory.Where(p => p.CategoryId == id).FirstOrDefault(); CategoryViewModel cvm = new CategoryViewModel(); cvm.CategoryId = tb.CategoryId; cvm.CategoryName = tb.CategoryName; return(View(cvm)); }
public ActionResult Edit([Bind(Include = "id,name,description,createTime,updatedTime,createdBy,updatedBy")] tbl_ProductCategory tbl_ProductCategory) { if (ModelState.IsValid) { db.Entry(tbl_ProductCategory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_ProductCategory)); }
public ActionResult Create([Bind(Include = "id,name,description,createTime,updatedTime,createdBy,updatedBy")] tbl_ProductCategory tbl_ProductCategory) { if (ModelState.IsValid) { db.tbl_ProductCategory.Add(tbl_ProductCategory); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_ProductCategory)); }
/// <summary> /// Gets the level. /// </summary> /// <param name="category">The category.</param> /// <returns></returns> public int GetLevel(tbl_ProductCategory category) { var level = 0; while (category != null) { level++; category = category.tbl_ProductCategory2; } return(level); }
// GET: tbl_ProductCategory/Edit/5 public ActionResult Edit(short?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_ProductCategory tbl_ProductCategory = db.tbl_ProductCategory.Find(id); if (tbl_ProductCategory == null) { return(HttpNotFound()); } return(View(tbl_ProductCategory)); }
/// <summary> /// Gets the full name of the category. /// </summary> /// <param name="category">The category.</param> /// <param name="delimetr">The delimetr.</param> /// <returns></returns> public string GetCategoryFullName(tbl_ProductCategory category, string delimetr) { var result = string.Empty; while (category != null) { if (String.IsNullOrEmpty(result)) { result = category.Title; } else { result = delimetr + result; } category = category.tbl_ProductCategory2; } return(result); }
public ActionResult EditCategories(CategoryViewModel cvm) { if (ModelState.IsValid) { try { tbl_ProductCategory category = _db.tbl_ProductCategory.Where(p => p.CategoryId == cvm.CategoryId).FirstOrDefault(); category.CategoryId = cvm.CategoryId; category.CategoryName = cvm.CategoryName; _db.SaveChanges(); ViewBag.Message = "Category Updated Successfully."; return(RedirectToAction("category")); } catch (Exception e) { return(View("Error", new HandleErrorInfo(e, "Admin", "EditCategory"))); } } return(RedirectToAction("Category")); }
public ActionResult InsertCategory(CategoryViewModel cvm) { if (ModelState.IsValid) { try { tbl_ProductCategory category = new tbl_ProductCategory(); category.CategoryId = cvm.CategoryId; category.CategoryName = cvm.CategoryName; _db.tbl_ProductCategory.Add(category); _db.SaveChanges(); ViewBag.Message = "Category Created Successfully."; return(RedirectToAction("Category")); } catch (Exception e) { return(View("Error", new HandleErrorInfo(e, "Admin", "InsertCategory"))); } } return(View()); }