public ItemsDTO <Order> GetOrdersGridRows(Action <IGridColumnCollection <Order> > columns,
QueryDictionary <StringValues> query)
{
using (var context = new NorthwindDbContext(_options))
{
var repository = new OrdersRepository(context);
var server = new GridCoreServer <Order>(repository.GetAll(), query, true, "ordersGrid", columns)
.Sortable()
.WithPaging(10)
.Filterable()
.WithMultipleFilters()
.Groupable(true)
.Searchable(true, false, false)
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
// return items to displays
var items = server.ItemsToDisplay;
// uncomment the following lines are to test null responses
//items = null;
//items.Items = null;
//items.Pager = null;
return(items);
}
}
public ItemsDTO <OrderDetail> GetGridRows(QueryDictionary <StringValues> query)
{
var server = new GridCoreServer <OrderDetail>(Items, query, true, "Grid", _columns)
.Sortable()
.WithPaging(10)
.Filterable()
.WithMultipleFilters()
.Searchable(true, false, false);
// return items to displays
var items = server.ItemsToDisplay;
return(items);
}
public ActionResult GetOrdersGridWithSubgrids()
{
var repository = new OrdersRepository(_context);
IGridServer <Order> server = new GridCoreServer <Order>(repository.GetAll(), Request.Query,
true, "ordersGrid", ColumnCollections.OrderColumnsWithSubgrids)
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
var items = server.ItemsToDisplay;
return(Ok(items));
}
public ActionResult GetMinFreight(string clientName)
{
var repository = new OrdersRepository(_context);
var server = new GridCoreServer <Order>(repository.GetForClient(clientName), Request.Query, true, "ordersGrid", null)
.AutoGenerateColumns()
.Sortable()
.Filterable()
.WithMultipleFilters()
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
return(Ok(new Order()
{
Freight = server.ItemsToDisplay.Items.Min(r => r.Freight)
}));
}
public async Task <ItemsDTO <Order> > GetOrdersGridRowsInMemory(Action <IGridColumnCollection <Order> > columns,
QueryDictionary <StringValues> query)
{
var server = new GridCoreServer <Order>(await GetAll(), query, true, "ordersGrid", columns)
.Sortable()
.WithPaging(10)
.Filterable()
.WithMultipleFilters()
.Groupable(true)
.Searchable(true, false, false);
// return items to displays
var items = server.ItemsToDisplay;
return(items);
}
public ItemsDTO <Truck> GetTrucksGridRows(Action <IGridColumnCollection <Truck> > columns,
QueryDictionary <StringValues> query)
{
var server = new GridCoreServer <Truck>(GetAll(), query, true, "trucksGrid", columns)
.Sortable()
.WithPaging(10)
.Filterable()
.WithMultipleFilters()
.Groupable(true)
.Searchable(true, false, false);
// return items to displays
var items = server.ItemsToDisplay;
return(items);
}
public ItemsDTO <Shipper> GetShippersGridRows(Action <IGridColumnCollection <Shipper> > columns, QueryDictionary <StringValues> query)
{
var server = new GridCoreServer <Shipper>(Shippers, query, true, "shippersGrid", columns)
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.WithGridItemsCount()
.Groupable(true)
.Searchable(true, false, false)
.SetRemoveDiacritics <StringUtils>("RemoveDiacritics");
var items = server.ItemsToDisplay;
return(items);
}
public ActionResult GetTrucksGrid()
{
var repository = new EmployeeRepository(_context);
IGridServer <Truck> server = new GridCoreServer <Truck>(GetAllTrucks(), Request.Query,
true, "trucksGrid", Trucks.Columns)
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.WithGridItemsCount()
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
var items = server.ItemsToDisplay;
return(Ok(items));
}
public ActionResult GetOrderDetailsGridAllFeatures(int OrderId)
{
var orderDetails = (new OrderDetailsRepository(_context)).GetForOrder(OrderId);
var server = new GridCoreServer <OrderDetail>(orderDetails, Request.Query,
false, "orderDetailsGrid" + OrderId.ToString(), c => ColumnCollections.OrderDetailColumnsAllFeatures(c, null))
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
var items = server.ItemsToDisplay;
return(Ok(items));
}
public ItemsDTO <Order> GetOrdersGridRows(QueryDictionary <StringValues> query)
{
using (var context = new NorthwindDbContext(_options))
{
var repository = new OrdersRepository(context);
var server = new GridCoreServer <Order>(repository.GetAll(), query, true, "ordersGrid", null)
.AutoGenerateColumns()
.Sortable()
.WithPaging(10)
.Filterable()
.WithMultipleFilters()
.Groupable(true)
.Searchable(true, false, false);
// return items to displays
return(server.ItemsToDisplay);
}
}
public ItemsDTO <Customer> GetCustomersGridRows(Action <IGridColumnCollection <Customer> > columns,
QueryDictionary <StringValues> query)
{
using (var context = new NorthwindDbContext(_options))
{
var repository = new CustomersRepository(context);
var server = new GridCoreServer <Customer>(repository.GetAll(), query, true, "customersGrid", columns)
.Sortable()
.WithPaging(10)
.Filterable()
.WithMultipleFilters()
.Searchable(true, false)
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
// return items to displays
var items = server.ItemsToDisplay;
return(items);
}
}
public ItemsDTO <Order> GetOrdersGridRowsInMemory(Action <IGridColumnCollection <Order> > columns,
QueryDictionary <StringValues> query)
{
using (var context = new NorthwindDbContext(_options))
{
var repository = new OrdersRepository(context);
var server = new GridCoreServer <Order>(repository.GetAll().ToList(), query, true, "ordersGrid", columns)
.Sortable()
.WithPaging(10)
.Filterable()
.WithMultipleFilters()
.Groupable(true)
.Searchable(true, false, false);
// return items to displays
var items = server.ItemsToDisplay;
return(items);
}
}
public ItemsDTO <OrderDetail> GetOrderDetailsGridRows(Action <IGridColumnCollection <OrderDetail> > columns,
object[] keys, QueryDictionary <StringValues> query)
{
using (var context = new NorthwindDbContext(_options))
{
int orderId;
int.TryParse(keys[0].ToString(), out orderId);
var repository = new OrderDetailsRepository(context);
var server = new GridCoreServer <OrderDetail>(repository.GetForOrder(orderId), query, true, "orderDetailssGrid" + keys[0].ToString(), columns)
.Sortable()
.WithPaging(10)
.Filterable()
.WithMultipleFilters()
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
// return items to displays
var items = server.ItemsToDisplay;
return(items);
}
}
public async Task <decimal?> GetMinFreight(string clientName, QueryDictionary <StringValues> query)
{
using (var context = new NorthwindDbContext(_options))
{
try
{
var repository = new OrdersRepository(context);
var server = new GridCoreServer <Order>(repository.GetForClient(clientName), query, true, "ordersGrid", null)
.AutoGenerateColumns()
.Sortable()
.Filterable()
.WithMultipleFilters()
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
return(await Task.FromResult(server.ItemsToDisplay.Items.Min(r => r.Freight)));
}
catch (Exception)
{
throw new GridException("Error etting min freight");
}
}
}
public ActionResult GetOrderColumnsWithErrors()
{
var random = new Random();
if (random.Next(2) == 0)
{
return(BadRequest());
}
var repository = new OrdersRepository(_context);
IGridServer <Order> server = new GridCoreServer <Order>(repository.GetAll(), Request.Query,
true, "ordersGrid", ColumnCollections.OrderColumns)
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.WithGridItemsCount()
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
var items = server.ItemsToDisplay;
return(Ok(items));
}
