Bootstrap Editable Table

This example shows how to configure editable table row with Bootstrap 4.

<!DOCTYPE html>
<html>
<head>
    <title>jQuery Grid Inline Editing</title>
    <meta charset="utf-8" />
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
    <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
    <script src="https://unpkg.com/gijgo@1.9.14/js/gijgo.js" type="text/javascript"></script>
    <link href="https://unpkg.com/gijgo@1.9.14/css/gijgo.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <div class="container-fluid">
        <div class="row">
            <div class="col-xs-12">
                <table id="grid"></table>
            </div>
        </div>
    </div>
    <script type="text/javascript">
        $(document).ready(function () {
            var grid, countries;
            grid = $('#grid').grid({
                dataSource: '/Players/Get',
                uiLibrary: 'bootstrap4',
                primaryKey: 'ID',
                inlineEditing: { mode: 'command' },
                columns: [
                    { field: 'ID', width: 44 },
                    { field: 'Name', editor: true },
                    { field: 'CountryName', title: 'Nationality', type: 'dropdown', editField: 'CountryID', editor: { dataSource: '/Locations/GetCountries', valueField: 'id' } },
                    { field: 'DateOfBirth', type: 'date', editor: true },
                    { field: 'IsActive', title: 'Active?', type: 'checkbox', editor: true, width: 90, align: 'center' }
                ],
                pager: { limit: 5 }
            });
            grid.on('rowDataChanged', function (e, id, record) {
                // Clone the record in new object where you can format the data to format that is supported by the backend.
                var data = $.extend(true, {}, record);
                // Format the date to format that is supported by the backend.
                data.DateOfBirth = gj.core.parseDate(record.DateOfBirth, 'mm/dd/yyyy').toISOString();
                // Post the data to the server
                $.ajax({ url: '/Players/Save', data: { record: data }, method: 'POST' })
                    .fail(function () {
                        alert('Failed to save.');
                    });
            });
            grid.on('rowRemoving', function (e, $row, id, record) {            
                if (confirm('Are you sure?')) {
                    $.ajax({ url: '/Players/Delete', data: { id: id }, method: 'POST' })
                        .done(function () {
                            grid.reload();
                        })
                        .fail(function () {
                            alert('Failed to delete.');
                        });
                }
            });
        });
    </script>
</body>
</html>

using Gijgo.Asp.NET.Examples.Models.Entities;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web.Mvc;

namespace Gijgo.Asp.NET.Examples.Controllers
{
    public class PlayersController : Controller
    {
        public JsonResult Get(int? page, int? limit, string sortBy, string direction, string name, string nationality, string placeOfBirth)
        {
            List<Models.DTO.Player> records;
            int total;
            using (ApplicationDbContext context = new ApplicationDbContext())
            {
                var query = context.Players.Select(p => new Models.DTO.Player
                {
                    ID = p.ID,
                    Name = p.Name,
                    PlaceOfBirth = p.PlaceOfBirth,
                    DateOfBirth = p.DateOfBirth,
                    CountryID = p.CountryID,
                    CountryName = p.Country != null ? p.Country.Name : "",
                    IsActive = p.IsActive,
                    OrderNumber = p.OrderNumber
                });

if (!string.IsNullOrWhiteSpace(name))
                {
                    query = query.Where(q => q.Name.Contains(name));
                }

if (!string.IsNullOrWhiteSpace(nationality))
                {
                    query = query.Where(q => q.CountryName != null && q.CountryName.Contains(nationality));
                }

if (!string.IsNullOrWhiteSpace(placeOfBirth))
                {
                    query = query.Where(q => q.PlaceOfBirth != null && q.PlaceOfBirth.Contains(placeOfBirth));
                }

if (!string.IsNullOrEmpty(sortBy) && !string.IsNullOrEmpty(direction))
                {
                    if (direction.Trim().ToLower() == "asc")
                    {
                        switch (sortBy.Trim().ToLower())
                        {
                            case "name":
                                query = query.OrderBy(q => q.Name);
                                break;
                            case "countryname":
                                query = query.OrderBy(q => q.CountryName);
                                break;
                            case "placeOfBirth":
                                query = query.OrderBy(q => q.PlaceOfBirth);
                                break;
                            case "dateofbirth":
                                query = query.OrderBy(q => q.DateOfBirth);
                                break;
                        }
                    }
                    else
                    {
                        switch (sortBy.Trim().ToLower())
                        {
                            case "name":
                                query = query.OrderByDescending(q => q.Name);
                                break;
                            case "countryname":
                                query = query.OrderByDescending(q => q.CountryName);
                                break;
                            case "placeOfBirth":
                                query = query.OrderByDescending(q => q.PlaceOfBirth);
                                break;
                            case "dateofbirth":
                                query = query.OrderByDescending(q => q.DateOfBirth);
                                break;
                        }
                    }
                }
                else
                {
                    query = query.OrderBy(q => q.OrderNumber);
                }

total = query.Count();
                if (page.HasValue && limit.HasValue)
                {
                    int start = (page.Value - 1) * limit.Value;
                    records = query.Skip(start).Take(limit.Value).ToList();
                }
                else
                {
                    records = query.ToList();
                }
            }

return this.Json(new { records, total }, JsonRequestBehavior.AllowGet);
        }

[HttpPost]
        public JsonResult Save(Models.DTO.Player record)
        {
            Player entity;
            using (ApplicationDbContext context = new ApplicationDbContext())
            {
                if (record.ID > 0)
                {
                    entity = context.Players.First(p => p.ID == record.ID);
                    entity.Name = record.Name;
                    entity.PlaceOfBirth = record.PlaceOfBirth;
                    entity.DateOfBirth = record.DateOfBirth;
                    entity.CountryID = record.CountryID;
                    entity.Country = context.Locations.FirstOrDefault(l => l.ID == record.CountryID);
                    entity.IsActive = record.IsActive;
                }
                else
                {
                    context.Players.Add(new Player
                    {
                        Name = record.Name,
                        PlaceOfBirth = record.PlaceOfBirth,
                        DateOfBirth = record.DateOfBirth,
                        CountryID = record.CountryID,
                        Country = context.Locations.FirstOrDefault(l => l.ID == record.CountryID),
                        IsActive = record.IsActive
                    });
                }
                context.SaveChanges();
            }
            return Json(new { result = true });
        }

[HttpPost]
        public JsonResult Delete(int id)
        {
            using (ApplicationDbContext context = new ApplicationDbContext())
            {
                Player entity = context.Players.First(p => p.ID == id);
                context.Players.Remove(entity);
                context.SaveChanges();
            }
            return Json(new { result = true });
        }

public JsonResult GetTeams(int playerId, int? page, int? limit)
        {
            List<Models.DTO.PlayerTeam> records;
            int total;
            using (ApplicationDbContext context = new ApplicationDbContext())
            {
                var query = context.PlayerTeams.Where(pt => pt.PlayerID == playerId).Select(pt => new Models.DTO.PlayerTeam
                {
                    ID = pt.ID,
                    PlayerID = pt.PlayerID,
                    FromYear = pt.FromYear,
                    ToYear = pt.ToYear,
                    Team = pt.Team,
                    Apps = pt.Apps,
                    Goals = pt.Goals
                });

total = query.Count();
                if (page.HasValue && limit.HasValue)
                {
                    int start = (page.Value - 1) * limit.Value;
                    records = query.OrderBy(pt => pt.FromYear).Skip(start).Take(limit.Value).ToList();
                }
                else
                {
                    records = query.ToList();
                }
            }

return this.Json(new { records, total }, JsonRequestBehavior.AllowGet);
        }
    }
}