React Data Grid - Web API Service

import React from 'react'; import { Column, DataGrid, FilterRow, HeaderFilter, GroupPanel, Scrolling, Editing, Grouping, Lookup, MasterDetail, Summary, RangeRule, RequiredRule, StringLengthRule, GroupItem, TotalItem, ValueFormat, } from 'devextreme-react/data-grid'; import { createStore } from 'devextreme-aspnet-data-nojquery'; import MasterDetailGrid from './MasterDetailGrid.js'; const url = 'https://js.devexpress.com/Demos/NetCore/api/DataGridWebApi'; const dataSource = createStore({ key: 'OrderID', loadUrl: `${url}/Orders`, insertUrl: `${url}/InsertOrder`, updateUrl: `${url}/UpdateOrder`, deleteUrl: `${url}/DeleteOrder`, onBeforeSend: (method, ajaxOptions) => { ajaxOptions.xhrFields = { withCredentials: true }; }, }); const customersData = createStore({ key: 'Value', loadUrl: `${url}/CustomersLookup`, onBeforeSend: (method, ajaxOptions) => { ajaxOptions.xhrFields = { withCredentials: true }; }, }); const shippersData = createStore({ key: 'Value', loadUrl: `${url}/ShippersLookup`, onBeforeSend: (method, ajaxOptions) => { ajaxOptions.xhrFields = { withCredentials: true }; }, }); const App = () => ( <DataGrid dataSource={dataSource} showBorders={true} width="100%" height={600} remoteOperations={true} > <MasterDetail enabled={true} component={MasterDetailGrid} /> <FilterRow visible={true} /> <HeaderFilter visible={true} /> <GroupPanel visible={true} /> <Scrolling mode="virtual" /> <Editing mode="row" allowAdding={true} allowDeleting={true} allowUpdating={true} /> <Grouping autoExpandAll={false} /> <Column dataField="CustomerID" caption="Customer" > <Lookup dataSource={customersData} valueExpr="Value" displayExpr="Text" /> <StringLengthRule max={5} message="The field Customer must be a string with a maximum length of 5." /> </Column> <Column dataField="OrderDate" dataType="date" > <RequiredRule message="The OrderDate field is required." /> </Column> <Column dataField="Freight"> <HeaderFilter groupInterval={100} /> <RangeRule min={0} max={2000} message="The field Freight must be between 0 and 2000." /> </Column> <Column dataField="ShipCountry"> <StringLengthRule max={15} message="The field ShipCountry must be a string with a maximum length of 15." /> </Column> <Column dataField="ShipVia" caption="Shipping Company" dataType="number" > <Lookup dataSource={shippersData} valueExpr="Value" displayExpr="Text" /> </Column> <Summary> <TotalItem column="Freight" summaryType="sum" > <ValueFormat type="decimal" precision={2} /> </TotalItem> <GroupItem column="Freight" summaryType="sum" > <ValueFormat type="decimal" precision={2} /> </GroupItem> <GroupItem summaryType="count" /> </Summary> </DataGrid> ); export default App;

import React, { useEffect, useState } from 'react'; import type { DataSourceOptions } from 'devextreme-react/common/data'; import DataGrid from 'devextreme-react/data-grid'; import type { DataGridTypes } from 'devextreme-react/data-grid'; import { createStore } from 'devextreme-aspnet-data-nojquery'; const url = 'https://js.devexpress.com/Demos/NetCore/api/DataGridWebApi'; const getMasterDetailGridDataSource = (id: number) => ({ store: createStore({ loadUrl: `${url}/OrderDetails`, loadParams: { orderID: id }, onBeforeSend: (method, ajaxOptions) => { ajaxOptions.xhrFields = { withCredentials: true }; }, }), }); const MasterDetailGrid = (props: DataGridTypes.MasterDetailTemplateData) => { const [dataSource, setDataSource] = useState<DataSourceOptions | undefined>(undefined); useEffect(() => { const masterDetailDataSource = getMasterDetailGridDataSource(props.data.key); setDataSource(masterDetailDataSource); }, [props.data.key]); return ( <DataGrid dataSource={dataSource} showBorders={true} /> ); }; export default MasterDetailGrid;

import React from 'react'; import ReactDOM from 'react-dom'; import App from './App.tsx'; // eslint-disable-next-line import/no-unresolved import 'anti-forgery'; ReactDOM.render( <App />, document.getElementById('app'), );

import React, { useEffect, useState } from 'react'; import DataGrid from 'devextreme-react/data-grid'; import { createStore } from 'devextreme-aspnet-data-nojquery'; const url = 'https://js.devexpress.com/Demos/NetCore/api/DataGridWebApi'; const getMasterDetailGridDataSource = (id) => ({ store: createStore({ loadUrl: `${url}/OrderDetails`, loadParams: { orderID: id }, onBeforeSend: (method, ajaxOptions) => { ajaxOptions.xhrFields = { withCredentials: true }; }, }), }); const MasterDetailGrid = (props) => { const [dataSource, setDataSource] = useState(undefined); useEffect(() => { const masterDetailDataSource = getMasterDetailGridDataSource(props.data.key); setDataSource(masterDetailDataSource); }, [props.data.key]); return ( <DataGrid dataSource={dataSource} showBorders={true} /> ); }; export default MasterDetailGrid;

import React from 'react'; import ReactDOM from 'react-dom'; import App from './App.js'; import 'anti-forgery'; ReactDOM.render(<App />, document.getElementById('app'));

<!DOCTYPE html> <html lang="en"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=5.0" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/26.1.5/css/dx.light.css" /> <link rel="stylesheet" type="text/css" href="styles.css" /> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="app"></div> </div> <script src="bundles/vendor/react.vendor.js"></script> <script src="./bundle.js"></script> </body> </html>

using DevExtreme.AspNet.Data; using DevExtreme.AspNet.Mvc; using Newtonsoft.Json; using System; using System.Linq; using System.Net; using System.Net.Http; using System.Net.Http.Formatting; using System.Web.Http; using DevExtreme.MVC.Demos.Models.Northwind; namespace DevExtreme.MVC.Demos.Controllers { [Route("api/DataGridWebApi/{action}", Name = "DataGridWebApi")] public class DataGridWebApiController : ApiController { InMemoryNorthwindContext _nwind = new InMemoryNorthwindContext(); [HttpGet] public HttpResponseMessage Orders(DataSourceLoadOptions loadOptions) { return Request.CreateResponse(DataSourceLoader.Load(_nwind.Orders, loadOptions)); } [HttpPost] public HttpResponseMessage InsertOrder(FormDataCollection form) { var values = form.Get("values"); var newOrder = new Order(); JsonConvert.PopulateObject(values, newOrder); Validate(newOrder); if(!ModelState.IsValid) return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState.GetFullErrorMessage()); _nwind.Orders.Add(newOrder); _nwind.SaveChanges(); return Request.CreateResponse(HttpStatusCode.Created, newOrder); } [HttpPut] public HttpResponseMessage UpdateOrder(FormDataCollection form) { var key = Convert.ToInt32(form.Get("key")); var values = form.Get("values"); var order = _nwind.Orders.First(o => o.OrderID == key); JsonConvert.PopulateObject(values, order); Validate(order); if(!ModelState.IsValid) return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState.GetFullErrorMessage()); _nwind.SaveChanges(); return Request.CreateResponse(HttpStatusCode.OK, order); } [HttpDelete] public void DeleteOrder(FormDataCollection form) { var key = Convert.ToInt32(form.Get("key")); var order = _nwind.Orders.First(o => o.OrderID == key); _nwind.Orders.Remove(order); _nwind.SaveChanges(); } // additional actions [HttpGet] public HttpResponseMessage OrderDetails(int orderID, DataSourceLoadOptions loadOptions) { return Request.CreateResponse(DataSourceLoader.Load( from i in _nwind.Order_Details where i.OrderID == orderID select new { Product = i.Product.ProductName, Price = i.UnitPrice, i.Quantity, Sum = i.UnitPrice * i.Quantity }, loadOptions )); } [HttpGet] public HttpResponseMessage ShippersLookup(DataSourceLoadOptions loadOptions) { var lookup = from i in _nwind.Shippers orderby i.CompanyName select new { Value = i.ShipperID, Text = i.CompanyName }; return Request.CreateResponse(DataSourceLoader.Load(lookup, loadOptions)); } [HttpGet] public HttpResponseMessage CustomersLookup(DataSourceLoadOptions loadOptions) { var lookup = from i in _nwind.Customers let text = i.CompanyName + " (" + i.Country + ")" orderby i.CompanyName select new { Value = i.CustomerID, Text = text }; return Request.CreateResponse(DataSourceLoader.Load(lookup, loadOptions)); } } }

using System; using System.Collections.Generic; using System.Data.Entity; namespace DevExtreme.MVC.Demos.Models.Northwind { public class InMemoryNorthwindContext : InMemoryDataContext<Order> { readonly NorthwindContext _nwind = new NorthwindContext(); public DbSet<Customer> Customers => _nwind.Customers; public DbSet<Order_Detail> Order_Details => _nwind.Order_Details; public ICollection<Order> Orders => ItemsInternal; public DbSet<Shipper> Shippers => _nwind.Shippers; protected override IEnumerable<Order> Source => _nwind.Orders; protected override int GetKey(Order item) => item.OrderID; protected override void SetKey(Order item, int key) => item.OrderID = key; } }