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); }