public ActionResult GetRevenueExtendbySalesOrderId(int salesOrderId)
{
var repository = new RevenuesRepository(_context).GetForSalesOrder(salesOrderId);
var server = new GridServer <Revenue>(repository, Request.Query,
true, "revenuesGrid" + salesOrderId.ToString()
, c => ColumnCollections.RevenueColumns(c, null))
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.WithGridItemsCount();
var revenues = server.ItemsToDisplay;
return(Ok(revenues));
}
public ActionResult GetOrdersGridAllFeatures()
{
var repository = new OrdersRepository(_context);
IGridServer <Order> server = new GridServer <Order>(repository.GetAll(), Request.Query,
true, "ordersGrid", c => ColumnCollections.OrderColumnsAllFeatures(c, null, null))
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.Searchable(true, false);
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 ActionResult OrderColumnsWithSubgridCrud()
{
var repository = new OrdersRepository(_context);
IGridServer <Order> server = new GridCoreServer <Order>(repository.GetAll(), Request.Query,
true, "ordersGrid", c => ColumnCollections.OrderColumnsWithNestedCrud(c, null, null))
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.WithGridItemsCount()
.SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics");
var items = server.ItemsToDisplay;
return(Ok(items));
}
public ActionResult GetOrderDetailsGridWithCrud(int OrderId)
{
var orderDetails = (new OrderDetailsRepository(_context)).GetForOrder(OrderId);
var server = new GridServer <OrderDetail>(orderDetails, Request.Query,
false, "orderDetailsGrid" + OrderId.ToString(), c => ColumnCollections.OrderDetailColumnsCrud(c, null))
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters();
var items = server.ItemsToDisplay;
return(Ok(items));
}
public ActionResult GetAllSalesOrder()
{
var repository = new SalesOrdersRepository(_context);
IGridServer <SalesOrder> server = new GridServer <SalesOrder>(repository.GetAll(), Request.Query,
true, "salesOrdersGrid", c => ColumnCollections.SalesOrderColumnsWithCustomer(c, null, null))
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.WithGridItemsCount();
var salesOrders = server.ItemsToDisplay;
return(Ok(salesOrders));
}
public ActionResult GetAllRevenue()
{
var repository = new RevenuesRepository(_context);
IGridServer <Revenue> server = new GridServer <Revenue>(repository.GetAll(), Request.Query,
true, "revenuesGrid", c => ColumnCollections.RevenueColumns(c, null))
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.WithGridItemsCount();
var revenues = server.ItemsToDisplay;
return(Ok(revenues));
}
public ActionResult GetSalesOrderItemExtendbySalesOrderId(int salesOrderId)
{
var repository = new SalesOrderItemsRepository(_context).GetForSalesOrder(salesOrderId);
var server = new GridServer <SalesOrderItem>(repository, Request.Query,
true, "salesOrderItemsGrid" + salesOrderId.ToString(), c => ColumnCollections.SalesOrderItemColumns(c, null, null))
.WithPaging(10)
.Sortable()
.Filterable()
.WithMultipleFilters()
.WithGridItemsCount()
.Searchable(true, false, true);
var salesOrderItems = server.ItemsToDisplay;
return(Ok(salesOrderItems));
}
