public ActionResult GetCustomersManualPaging(int page, int size)
{
var context = new TelerikDemoDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
var result = context.GetCustomersPaged(page, size).ToList();
var gridModel = new GridModel{
Data = result,
Total = 91
};
return View(gridModel);
}
public ActionResult SearchFormGrid(string customerId, string companyName,string contactName, string postalCode)
{
var context = new TelerikDemoDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
var customers = context.Customers.AsQueryable();
if (!string.IsNullOrEmpty(customerId))
customers = customers.Where(r => r.CustomerID == customerId);
if (!string.IsNullOrEmpty(companyName))
customers = customers.Where(r => r.CompanyName == companyName);
if (!string.IsNullOrEmpty(contactName))
customers = customers.Where(r => r.ContactName == contactName);
if (!string.IsNullOrEmpty(postalCode))
customers = customers.Where(r => r.PostalCode == postalCode);
return View(new GridModel(customers));
}
public ActionResult StaticBinding()
{
var context = new TelerikDemoDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
return View(context.Customers.ToList());
}
public ActionResult GetGridDataForAjaxBinding(int someValue)
{
var context = new TelerikDemoDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
return View(new GridModel(context.Customers));
}
