//ToDo: Add edit delete feature shoule be added.
public JsonResult SimpleCrudJsonData(JqGridPost post)
{
using (var ctx = new AdventureWorksLTEntities())
{
//var customer = ctx.Customer.OrderBy(m => m.CustomerID).Skip(postModel.page * postModel.rows).Take(postModel.rows).ToList();
var customer = new PagedList<Customer>(ctx.Customer.OrderBy(m => m.CustomerID), post.page, post.rows);
var jqRows = new List<JqGridRow>();
foreach (var item in customer)
{
jqRows.Add(new JqGridRow
{
id = item.CustomerID.ToString(),
cell = { item.CustomerID, item.FirstName, item.LastName, item.EmailAddress, item.Phone }
});
}
var json = new JqGridData
{
page = post.page,
records = customer.TotalCount,
total = customer.TotalPages,
rows = jqRows
};
return Json(json, JsonRequestBehavior.AllowGet);
}
}
public ActionResult OtherInputBoxes()
{
using (var ctx = new AdventureWorksLTEntities())
{
var category = ctx.ProductCategory.ToList().ToDictionary(item => item.ProductCategoryID.ToString(), item => item.Name);
ViewBag.ProductCategory = category;
return View();
}
}
//ToDo: Add edit delete features with different input boxes
public ActionResult OtherInputBoxesJsonData(JqGridPost post)
{
//var productList = _productRepository.Table.ToList();
using (var ctx = new AdventureWorksLTEntities())
{
var product = new PagedList<Product>(
ctx.Product.OrderBy(m => m.ProductID), post.page, post.rows);
var jqRows = product.Select(item => new GridRow
{
Id = item.ProductID.ToString(),
Cell = {item.ProductID, item.Name, item.Size, item.ProductCategory.Name, item.ListPrice}
}).ToList();
var json = product.ToJqGridData(post.page, jqRows);
return Json(json.ToData(), JsonRequestBehavior.AllowGet);
//return new XmlResult(json);
}
}
public ActionResult InputJsonData(JqGridPost post)
{
using (var ctx = new AdventureWorksLTEntities())
{
//var customer = ctx.Customer.OrderBy(m => m.CustomerID).Skip(postModel.page * postModel.rows).Take(postModel.rows).ToList();
var product = new PagedList<Product>(
ctx.Product.OrderBy(m => m.ProductID), post.page, post.rows);
var jqRows = new List<GridRow>();
foreach (var item in product)
{
jqRows.Add(new GridRow
{
Id = item.ProductID.ToString(),
Cell = new List<object> { item.ProductID, item.Name, item.Size, item.ProductCategory.Name, item.ListPrice }
});
}
var json = new GridData
{
Page = post.page,
Records = product.TotalCount,
Total = product.TotalPages,
Rows = jqRows
};
//var json = product.ToJqGridData(jqRows);
return Json(json, JsonRequestBehavior.AllowGet);
//return new XmlResult(json);
}
}