/// <summary>
/// Auto-Complete companies
/// </summary>
public IActionResult AcCompany([FromServices] SamplesDbContext context, string value = "", int take = 12)
{
var model = context.Customers.Where(c => c.CompanyName.Contains(value)).Take(take).Select(c => c.CompanyName).Distinct().OrderBy(s => s).ToList();
if (model.Count == 1 && model[0] == value)
{
model.Clear();
}
return(View("AcCompany", model));
}
public IActionResult DataTableSelection([FromServices] SamplesDbContext context, int[] selection = null)
{
selection = selection ?? Array.Empty <int>();
var model = new DataTable <Customer>();
var query = context.Customers
.Where(c => c.Id < 11)
.Where(c => selection.Contains(c.Id));
model.Items = query.OrderBy(c => c.Id).ToArray();
return(View("DataTableSelection", model));
}
public IActionResult InfiniteScroll([FromServices] SamplesDbContext context, int toskip = 0)
{
var model = new DataTable <Customer>();
model.Page = toskip;
model.PageSize = 4;
var query = context.Customers
.Where(c => c.Id <= 120)
.OrderBy(c => c.Id)
.Skip(toskip).Take(model.PageSize);
model.Items = query.ToArray();
return(View(model));
}
public IActionResult DataTableWithSelection([FromServices] SamplesDbContext context, int page = 1, int pagesize = 3, string q = null)
{
var model = new DataTable <Customer>();
model.Page = page;
model.PageSize = pagesize;
model.Query = q;
var query = context.Customers
.Where(c => c.Id < 11)
.Where(c => q == null || c.CompanyName.Contains(q));
model.LastPage = (query.Count() + pagesize - 1) / pagesize;
model.Items = query.OrderBy(c => c.Id).Skip((page - 1) * pagesize).Take(pagesize).ToArray();
return(View(model));
}
