// Checkbox public ActionResult Checkbox() { using (EntityContext db = new EntityContext()) { return View(db.Product.ToList()); } }
public string GetData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest param) { using (EntityContext db = new EntityContext()) { IQueryable<Company> company = db.Company; var count = company.Count(); return DataTablesHelper.GetQuery(param, count, company); } }
// Delete Category public ActionResult Delete(FormCollection form) { using (EntityContext db = new EntityContext()) { try { Category category = db.Category.Find(Convert.ToInt32(form["Id"])); db.Category.Remove(category); db.SaveChanges(); return Json(new { msg = "success" }); } catch (Exception ex) { return Json(new { msg = "Fail!" + ex.Message }); } } }
public string DeleteData(int id) { using (EntityContext db = new EntityContext()) { try { var company = db.Company.FirstOrDefault(c => c.ID == id); if (company == null) return "Company cannot be found"; db.Company.Remove(company); return "ok"; } catch (Exception ex) { return ex.Message; } } }
// Batch Delete(use checkbox) public ActionResult BatchDelete(string ids) { using (var db = new EntityContext()) { try { var myIds=ids.Split(',').Select(x => Int32.Parse(x)); var query=from c in db.Category where myIds.Contains(c.Id) select c; db.Category.RemoveRange(query); db.SaveChanges(); return Json(new { msg = "success" }); } catch (Exception ex) { return Json(new { msg = "Fail!" + ex.Message }); } } }
// Add new Category public ActionResult Add(FormCollection form) { using (EntityContext db = new EntityContext()) { if (ModelState.IsValid) { try { Category category = new Category(); category.Name = form["categoryName"].Trim(); db.Category.Add(category); db.SaveChanges(); return Json(new { msg = "success" }); } catch (Exception ex) { return Json(new { msg = "Fail!" + ex.Message }); } } return Content(""); } }
// Edit Category public ActionResult Edit(FormCollection form) { using (EntityContext db = new EntityContext()) { if (ModelState.IsValid) { try { Category category = db.Category.Find(Convert.ToInt32(form["Id"])); category.Name = form["Name"].Trim(); db.SaveChanges(); return Json(new { msg = "success" }); } catch (Exception ex) { return Json(new { msg = "Fail!" + ex.Message }); } } return Content(""); } }
public ActionResult SubGridDetail(int id) { using (EntityContext db=new EntityContext()) { var model = db.Product.Where(i => i.CategoryId.Equals(id)); return PartialView(model.ToList()); } }
// Show subGrid public ActionResult SubGrid() { using (EntityContext db=new EntityContext()) { return View(db.Category.ToList()); } }
public string GetMasterData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest param) { using (EntityContext db = new EntityContext()) { IQueryable<Category> category = db.Category; var count = category.Count(); return DataTablesHelper.GetQuery(param, count, category); } }
public string GetDetailsData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest param) { using (EntityContext db = new EntityContext()) { IQueryable<Product> product = db.Product; var totalRecords = product.Count(); var id = Convert.ToInt32(Request.QueryString["id"]); product = product.Where(c => c.Category.Id.Equals(id)); return DataTablesHelper.GetQuery(param, totalRecords, product); } }