Передача строк не работает между таблицами данных jQuery, которые используют вызов ajax

У вас нет полного маршрута публикации данных, и есть некоторые ошибки. Вот образец, которому вы можете следовать.

DoorService.cs для отправки данных

public interface IDoorService
{
    List<DoorDetails> ExcludeDoors { get; }
    List<DoorDetails> IncludeDoors { get; }
    void MoveToInclude(List<int> ids);
    void MoveToExclude(List<int> ids);
}

public class DoorService : IDoorService
{
    public List<DoorDetails> ExcludeDoors { get; private set; }
    public List<DoorDetails> IncludeDoors { get; private set; }

    public DoorService()
    {
        // Initialize data as you want
        ExcludeDoors = new List<DoorDetails>
        {
            new DoorDetails { SiteCode = 11, LegacyDoor = 43443, BuyingGroup = "BuyingGroup1", SettingName = "Setting1" },
            new DoorDetails { SiteCode = 22, LegacyDoor = 23123, BuyingGroup = "BuyingGroup2", SettingName = "Setting2" }
        };

        IncludeDoors = new List<DoorDetails>
        {
            new DoorDetails { SiteCode = 33, LegacyDoor = 54483, BuyingGroup = "BuyingGroup3", SettingName = "Setting3" },
            new DoorDetails { SiteCode = 44, LegacyDoor = 66543, BuyingGroup = "BuyingGroup4", SettingName = "Setting4" }
        };
    }

    public void MoveToInclude(List<int> ids)
    {
        var doorsToMove = ExcludeDoors.Where(d => ids.Contains(d.SiteCode)).ToList();
        foreach (var door in doorsToMove)
        {
            ExcludeDoors.Remove(door);
            IncludeDoors.Add(door);
        }
    }

    public void MoveToExclude(List<int> ids)
    {
        var doorsToMove = IncludeDoors.Where(d => ids.Contains(d.SiteCode)).ToList();
        foreach (var door in doorsToMove)
        {
            IncludeDoors.Remove(door);
            ExcludeDoors.Add(door);
        }
    }
}

Зарегистрировать услугу

builder.Services.AddSingleton<IDoorService, DoorService>();

Контроллер.cs

public class HomeController : Controller
{
    
    private readonly IDoorService _doorService;

    public HomeController(IDoorService doorService)
    {
        _doorService = doorService;
    }

    public IActionResult LoadExclude(int draw = 1, int start = 0, int length = 10)
    {
        var data = _doorService.ExcludeDoors.Skip(start).Take(length).ToList(); // Pagination logic
        var recordsTotal = _doorService.ExcludeDoors.Count;

        var jsonData = new
        {
            draw = draw,
            recordsFiltered = recordsTotal,
            recordsTotal = recordsTotal,
            data = data
        };

        return Json(jsonData);
    }

    public IActionResult LoadInclude(int draw = 1, int start = 0, int length = 10)
    {
        var data = _doorService.IncludeDoors.Skip(start).Take(length).ToList(); // Pagination logic
        var recordsTotal = _doorService.IncludeDoors.Count;

        var jsonData = new
        {
            draw = draw,
            recordsFiltered = recordsTotal,
            recordsTotal = recordsTotal,
            data = data
        };

        return Json(jsonData);
    }

    [HttpPost]
    public IActionResult MoveToInclude([FromBody] List<int> ids)
    {
        _doorService.MoveToInclude(ids);
        return Ok();
    }

    [HttpPost]
    public IActionResult MoveToExclude([FromBody] List<int> ids)
    {
        _doorService.MoveToExclude(ids);
        return Ok();
    }

    public IActionResult Index()
    {
        return View();
    }

}

Индекс.cshtml

Согласно моему тесту, свойства в столбцах и строках должны быть в нижнем регистре, иначе возникнут ошибки.

@section Scripts {
    <script>
            $(document).ready(function () {
                var excludeTable = LoadGridExclude();
                var includeTable = LoadGridInclude();

                $('#btnRight').click(function () {
                    var selectedRows = excludeTable.rows({ selected: true }).data().toArray();
                    var ids = selectedRows.map(row => row.siteCode);

                    if (ids.length === 0) {
                        alert("Please select rows to move.");
                        return;
                    }

                    $.ajax({
                        url: '/Home/MoveToInclude',
                        type: 'POST',
                        contentType: 'application/json',
                        data: JSON.stringify(ids),
                        success: function () {
                            excludeTable.ajax.reload();
                            includeTable.ajax.reload();
                        }
                    });
                });

                $('#btnLeft').click(function () {
                    var selectedRows = includeTable.rows({ selected: true }).data().toArray();
                    var ids = selectedRows.map(row => row.siteCode);

                    if (ids.length === 0) {
                        alert("Please select rows to move.");
                        return;
                    }

                    $.ajax({
                        url: '/Home/MoveToExclude',
                        type: 'POST',
                        contentType: 'application/json',
                        data: JSON.stringify(ids),
                        success: function () {
                            excludeTable.ajax.reload();
                            includeTable.ajax.reload();
                        }
                    });
                });
            });

            function LoadGridExclude() {
                return $('#excludeTable').DataTable({
                    ajax: {
                        url: '/Home/LoadExclude',
                        type: 'GET',
                        datatype: 'json'
                    },
                    columns: [
                        { data: 'siteCode', title: 'SiteCode', autoWidth: true },
                        { data: 'legacyDoor', title: 'Legacy Door', autoWidth: true },
                        { data: 'buyingGroup', title: 'Buying Group', autoWidth: true },
                        { data: 'settingName', title: 'Setting Name', autoWidth: true }
                    ],
                    select: {
                        style: 'multi'
                    },
                    paging: false
                });
            }

            function LoadGridInclude() {
                return $('#includeTable').DataTable({
                    ajax: {
                        url: '/Home/LoadInclude',
                        type: 'GET',
                        datatype: 'json'
                    },
                    columns: [
                        { data: 'siteCode', title: 'SiteCode', autoWidth: true },
                        { data: 'legacyDoor', title: 'Legacy Door', autoWidth: true },
                        { data: 'buyingGroup', title: 'Buying Group', autoWidth: true },
                        { data: 'settingName', title: 'Setting Name', autoWidth: true }
                    ],
                    select: {
                        style: 'multi'
                    },
                    paging: false
                });
            }
    </script>
}

<div style = "vertical-align:top;">
    <table id = "excludeInclude" width = "100%" style = "vertical-align:top;">
        <tr style = "vertical-align:top;">
            <td valign = "top">
                
                <table id = "excludeTable" class = "display" style = "width:100%; height:30%; float:left; clear:both; vertical-align:top; border:1px solid;">
                    <thead>
                        <tr>
                            <th>SiteCode</th>
                            <th>Legacy Door</th>
                            <th>Buying Group</th>
                            <th>Setting Name</th>
                        </tr>
                    </thead>
                    <tbody>
                        
                    </tbody>
                </table>
            </td>
            <td valign = "top" style = "width:5%; float:left; clear:both; margin-left:5px; margin-right:5px; margin-top:95px;">
                <div id = "btnPanel">
                    <button id = "btnRight" class = "btn-logic"><b> >> </b></button>
                    <button id = "btnLeft" class = "btn-logic"><b> << </b></button>
                </div>
            </td>
            <td valign = "top">
                
                <table id = "includeTable" class = "display" style = "width:100%; height:30%; float:left; clear:both; vertical-align:top; border:1px solid;">
                    <thead>
                        <tr>
                            <th>SiteCode</th>
                            <th>Legacy Door</th>
                            <th>Buying Group</th>
                            <th>Setting Name</th>
                        </tr>
                    </thead>
                    <tbody>
                        
                    </tbody>
                </table>
            </td>
        </tr>
    </table>
</div>