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