public ActionResult ListOrdersForFilters(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
IQueryable <Order> orders =
entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
if (!String.IsNullOrEmpty(model.SelectedCustomerId))
{
orders = orders.Where(o => o.CustomerID == model.SelectedCustomerId);
}
return(TableResult.From(orders).Build <OrderFilterTable>(request));
}
public ActionResult ListChildOrderDetails(TableRequestModel request, int?orderId)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
IQueryable <Order_Detail> orderDetails = entities.Order_Details.Expand(o => o.Product);
if (orderId == null)
{
orderDetails = orderDetails.Where(o => false);
}
else
{
orderDetails = orderDetails.Where(o => o.OrderID == orderId.Value);
}
return(TableResult.From(orderDetails).Build <ChildOrderDetailTable>(request));
}
public ActionResult ListEmployees(TableRequestModel request, bool readOnly = false)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
return(TableResult.From(entities.Employees).Build <EmployeeTable>(request));
}
public ActionResult ListCategoriesDefault(TableRequestModel request)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
return(TableResult.From(entities.Categories).Default(request));
}
public ActionResult ListInvoices(TableRequestModel request)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
return(TableResult.From(entities.Invoices).Build <InvoiceTable>(request));
}
public ActionResult ReadonlyEmployees(TableRequestModel request, IEnumerable <Employee> employees)
{
var result = TableResult.From(employees).Build <EmployeeTable>(request, employees.Count());
return(result);
}
