public ActionResult ListOrders(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var orders = entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
return(TableResult.From(orders).Build <OrderTable>(request));
}
public async Task <TableResponseModel> Edit(Guid id, TableRequestModel tableRequest)
{
Log.Logger = new LoggerConfiguration()
.WriteTo.Console()
.WriteTo.File("C:\\test\\log.txt")
.CreateLogger();
try
{
await _repository.EditAsync(id, new Table { Seats = tableRequest.numberOfSeats });
}
catch (Exception e)
{
Log.Information("Failed to edit table {Id}, info: {Table}", id, tableRequest);
return(new TableResponseModel()
{
ErrorMessage = e.Message, Success = false, Tables = null
});
}
Log.Information("Editet, info: {Table}", tableRequest);
return(new TableResponseModel()
{
ErrorMessage = null, Success = true, Tables = null
});
}
public ActionResult ListShippers(TableRequestModel request)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var shippers = entities.Shippers.ToList();
int rowsNumber = 20;
return(TableResult.From(shippers).Build <ViewConfigedMvcTable <Shipper> >(request, rowsNumber));
}
public ActionResult ListOrders(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var orders = entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
var table = TableResult.From(orders).Build <OrderTable>(request);
table.Overrides.HideColumn(order => order.ShipRegion);
return(table);
}
public async Task <IActionResult> Post([FromBody] TableRequestModel tableRequest)
{
var tableToAdd = await _tableService.Add(tableRequest.numberOfSeats);
if (!tableToAdd.Success)
{
return(BadRequest());
}
return(Ok(tableToAdd));
}
public async Task <ActionResult> Put(Guid id, [FromBody] TableRequestModel tableRequest)
{
var tableToUpdate = await _tableService.Edit(id, tableRequest);
if (!tableToUpdate.Success)
{
return(BadRequest());
}
return(Ok(tableToUpdate));
}
public ActionResult ListParentOrders(TableRequestModel request, string nameFilter)
{
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(nameFilter))
{
orders = orders.Where(o => o.Customer.ContactName.Contains(nameFilter));
}
return(TableResult.From(orders).Build <ParentOrderTable>(request));
}
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 void Render(IEnumerable <TModel> rows, TableRequestModel model, System.IO.TextWriter writer)
{
var columns = new XElement("columns");
columns.Add(_tableDefinition.Columns.Select(x => new XElement("column", x.Name)));
var xrows = new XElement("rows");
xrows.Add(
rows.Select(
r =>
new XElement("row",
_tableDefinition.Columns.Select(
t =>
new XElement("cell", t.GetRawValue(r))))));
var table = new XElement("table", columns, xrows);
table.Save(writer);
}
public void Render(IEnumerable <TModel> rows, TableRequestModel model, ControllerContext context)
{
context.HttpContext.Response.ContentType = "application/xml";
var columns = new XElement("columns");
columns.Add(_tableDefinition.Columns.Select(x => new XElement("column", x.Name)));
var xrows = new XElement("rows");
xrows.Add(
rows.Select(
r =>
new XElement("row",
_tableDefinition.Columns.Select(
t =>
new XElement("cell", t.GetRawValue(r))))));
var table = new XElement("table", columns, xrows);
table.Save(context.HttpContext.Response.OutputStream);
}
public static ITableRender <TModel> Get <TModel>(ITableDefinition <TModel> config,
TableRequestModel model,
ITableUrlManager urlManager)
{
switch (model.Format)
{
case TableRenderFormat.Html:
return(new HtmlTableRender <TModel>(config, urlManager));
case TableRenderFormat.Json:
return(new JsonArrayTableRender <TModel>(config));
case TableRenderFormat.Xml:
return(new XmlTableRender <TModel>(config));
case TableRenderFormat.Csv:
return(new CsvTableRender <TModel>(config));
}
throw new Exception("Unknown table render type");
}
public ActionResult ListParentOrders(TableRequestModel request, string nameFilter)
{
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(nameFilter))
{
orders = orders.Where(o => o.Customer.ContactName.Contains(nameFilter));
}
return TableResult.From(orders).Build<ParentOrderTable>(request);
}
public ActionResult ListOrders(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var orders = entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
var table =TableResult.From(orders).Build<OrderTable>(request);
table.Overrides.HideColumn(order => order.ShipRegion);
return table;
}
public ActionResult ListShippers(TableRequestModel request)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var shippers = entities.Shippers.ToList();
int rowsNumber = 20;
return TableResult.From(shippers).Build<ViewConfigedMvcTable<Shipper>>(request, rowsNumber);
}
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;
}
internal MvcTableHelper(HtmlHelper helper, ITableDefinition tableDefinition, TableRequestModel model)
{
_helper = helper;
_tableDefinition = tableDefinition;
_model = model;
}
public ActionResult ListOrders(TableRequestModel request, FiltersModel model)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
var orders = entities.Orders.Expand(o => o.Customer).Expand(o => o.Shipper).Expand(o => o.Order_Details);
return TableResult.From(orders).Build<OrderTable>(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 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 ReadonlyEmployees(TableRequestModel request, IEnumerable <Employee> employees)
{
var result = TableResult.From(employees).Build <EmployeeTable>(request, employees.Count());
return(result);
}
public ActionResult ListInvoices(TableRequestModel request)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
return(TableResult.From(entities.Invoices).Build <InvoiceTable>(request));
}
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 ListCategoriesDefault(TableRequestModel request)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
return(TableResult.From(entities.Categories).Default(request));
}
public ActionResult ListEmployees(TableRequestModel request, bool readOnly = false)
{
var entities = new NorthwindEntities(NorthwindServiceUrl);
return TableResult.From(entities.Employees).Build<EmployeeTable>(request);
}
public void Render(IEnumerable <TModel> rows, TableRequestModel model, ControllerContext context)
{
var writer = WriterHelper.GetWriter(context);
var myId = _tableDefinition.Id;
using (
new ComplexContentTag("div", new Dictionary <string, object> {
{ "class", HtmlConstants.MvctableContainer }
},
writer))
{
using (new ComplexContentTag("table",
new Dictionary <string, object>
{
{ "class", "mvctable " + _tableDefinition.CssClass },
{ "data-source", _urlManager.SourceUrl },
{ "data-table-id", myId },
{ "data-filter", _tableDefinition.FilterExpression }
}, writer))
{
using (new ComplexContentTag("thead", writer))
{
using (new ComplexContentTag("tr", writer))
{
foreach (var col in _tableDefinition.Columns)
{
var attributes = col.HeaderAttributes.Clone();
if (col.IsSortable)
{
var sortAsc = model.SortAscending;
var isSorted = model.SortColumn == col.SortExpression;
var classMap = new[]
{
new
{
Apply = true,
@class = "sortable"
},
new
{
Apply = isSorted,
@class = sortAsc ? "sorted-asc" : "sorted-desc"
}
};
attributes["class"] = attributes.ContainsKey("class") ? attributes["class"] : "";
foreach (var cm in classMap.Where(cm => cm.Apply))
{
attributes["class"] += (" " + cm.@class);
}
}
if (col.IsHidden)
{
attributes.WithStyle("display", "none");
}
using (new ComplexContentTag("th", attributes, writer))
{
if (col.IsSortable)
{
var sortUrl = _urlManager.GetSortUrl(col.SortExpression);
using (
new ComplexContentTag("a",
new RouteValueDictionary(new { href = sortUrl })
.WithClass(_tableDefinition.FilterExpression),
writer))
{
writer.Write(col.GetHeaderValue(context, writer));
}
}
else
{
writer.Write(col.GetHeaderValue(context, writer));
}
}
}
}
}
using (new ComplexContentTag("tbody", writer))
{
var aRows = rows.ToArray();
for (var i = 0; i < aRows.Length; i++)
{
using (new ComplexContentTag("tr", writer))
{
foreach (var col in _tableDefinition.Columns)
{
if (col.IsHidden)
{
col.CellAttributes.WithStyle("display", "none");
}
using (new ComplexContentTag("td", col.CellAttributes, writer))
{
writer.Write(col.GetCellValue(aRows, i, context, writer));
}
}
}
}
}
using (new ComplexContentTag("tfoot", writer))
{
using (new ComplexContentTag("tr", writer))
{
foreach (var col in _tableDefinition.Columns)
{
if (col.IsHidden)
{
col.FooterAttributes.WithStyle("display", "none");
}
using (new ComplexContentTag("td", col.FooterAttributes, writer))
{
writer.Write(col.GetFooterValue(rows, context, writer));
}
}
}
}
}
}
writer.Flush();
}
