How to send an Id (DiagramaId) to the Datatable to filter the data

How to send an Id (DiagramaId) to the Datatable to filter the data

LuisGeritaLuisGerita Posts: 5Questions: 2Answers: 0

I apologize, but I don't know how to put a test case

$(document).ready(function () {
    tableBase = $('#tableGridDetail').DataTable({
        dom: "lfrtip",                      // DOM 
        filter: true,                       // Filtrado de datos
        info: true,                         // Resultado de busquedas
        processing: true,                   // Muestra/Oculta la leyenda procesando
        scrollX: true,                      // Scroll Horizontal
        select: true,                       // Permite seleccionar el renglon
        ordering: true,                     // Activa el ordenamiento
        autoWidth: true,                   // Apaga el ancho automatico
        lengthMenu: [[10, 50, 100, 150, -1], [10, 50, 100, 150, "Todos"]],

        responsivePriority: 1,

        scroller: { "loadingIndicator": true },     
        serverSide: true,                           
        deferRender: true,                        

        responsivePriority: 1,
        data: null,

       // Here I call the controller, but I don't know how to send the DiagramId so that it only retrieves the records of that ID
       // Aqui llamo al controlador, pero no se como mandar el DiagramaId para que me recupere solo los registros de ese ID
        ajax: {
            url: "/DiagramaDetail/LoadDataGrid/",
            type: "POST",
            datatype: "json",
        },
    });
});

There is no error message, I just don't know how to send the DiagramaId parameter, note, the detail table has 63 fields and can return up to 600 rows

I am designing a system with Net Core 5 MVC, I have to show a Master-Detail, I already have the Master view that contains a Datatable, I would like that when clicking on the ID field (DiagramaId), the view with the detail would be displayed , but I don't know how to call the Detail view.

// This is the controller LoadDataGrid
[HttpPost]
public IActionResult LoadDataGrid(int id)
{
    var draw = Request.Form["draw"].FirstOrDefault();
    var start = Request.Form["start"].FirstOrDefault();
    var length = Request.Form["length"].FirstOrDefault();
    var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault();
    var sortColumnDir = Request.Form["order[0][dir]"].FirstOrDefault();
    var searchValue = Request.Form["search[value]"].FirstOrDefault().ToUpper();

    pageSize = length != null ? Convert.ToInt32(length) : 0;
    skip = start != null ? Convert.ToInt32(start) : 0;
    recordsTotal = 0;

    List<VDiagramaDetailModel> ListVDiagramaDetailModel = Singleton.Instance.EntityManager.GetEntities<VDiagramaDetailModel>($"Diagrama_Id = {id}");
    ListVDiagramaDetailModel = (from d in ListVDiagramaDetailModel select d).ToList();

    /* Si tenemos una cadena de busqueda */
    if (searchValue != "")
        ListVDiagramaDetailModel = ListVDiagramaDetailModel.Where(x => x.DiagramaDetailId.ToString().Contains(searchValue)).ToList();

    recordsTotal = ListVDiagramaDetailModel.Count;

    /* Reordenar segun lo solicitado en el Grid */
    switch (sortColumn)
    {
        case "diagramaDetailId":
            if (sortColumnDir == "asc")
                ListVDiagramaDetailModel = ListVDiagramaDetailModel.OrderBy(x => x.DiagramaDetailId).Skip(skip).Take(pageSize).ToList();
            else
                ListVDiagramaDetailModel = ListVDiagramaDetailModel.OrderByDescending(x => x.DiagramaDetailId).Skip(skip).Take(pageSize).ToList();
            break;

        default:
            break;
    }

    return Json(new { draw, recordsFiltered = recordsTotal, recordsTotal, data = ListVDiagramaDetailModel });
}

Thanks for the help

Answers

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin

    Do you mean something along these lines?

    Allan

  • LuisGeritaLuisGerita Posts: 5Questions: 2Answers: 0
    edited April 2022

    It is not the best solution, but it works and it will give me time to analyze.

    In a static class, save the ID when entering the controller that shows the detail, then when the Datatable enters, since the ID is zero, I assign the one that I previously saved and that's it, everything works perfectly.

    This's my static class

    using System;
    
    namespace WebProcesoTela.Classes
    {
        public class AppEnvironment
        {
            public static int appDiagramaId  = 0;
    
            public int SetDiagramaId(int nValue)
            {
                appDiagramaId = nValue;
                return appDiagramaId;
            }
    
            public int GetDiagramaId()
            {
                return appDiagramaId;
            }
        }
    }
    

    Here I save the ID (Controller to load the Detail with an ID)

    // GET: DiagramaDetailController/Details/5
    public IActionResult Details(int id)
    {
        _appEnv.SetDiagramaId(id); //<= Here I save the ID
    
        List<VDiagramaDetailModel> ListVDiagramaDetailModel = Singleton.Instance.EntityManager.GetEntities<VDiagramaDetailModel>($"Diagrama_Id = {id}");
    
        return View(ListVDiagramaDetailModel);
    }
    

    Here I retrieve the ID (Controller to load the Datatable)

    [HttpPost]
    public IActionResult LoadDataGrid(int id)   
    {
        if (id == 0)
            id = _appEnv.GetDiagramaId();  // <= Here I retrieve the ID
    
        var draw = Request.Form["draw"].FirstOrDefault();
        var start = Request.Form["start"].FirstOrDefault();
        var length = Request.Form["length"].FirstOrDefault();
        var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault();
        var sortColumnDir = Request.Form["order[0][dir]"].FirstOrDefault();
        var searchValue = Request.Form["search[value]"].FirstOrDefault().ToUpper();
    
        pageSize = length != null ? Convert.ToInt32(length) : 0;
        skip = start != null ? Convert.ToInt32(start) : 0;
        recordsTotal = 0;
    
        List<VDiagramaDetailModel> ListVDiagramaDetailModel = Singleton.Instance.EntityManager.GetEntities<VDiagramaDetailModel>($"Diagrama_Id = {id}");
        ListVDiagramaDetailModel = (from d in ListVDiagramaDetailModel select d).ToList();
    
        /* Si tenemos una cadena de busqueda */
        if (searchValue != "")
        {
            ListVDiagramaDetailModel = ListVDiagramaDetailModel.Where(x => x.DiagramaDetailId.ToString().Contains(searchValue)).ToList();
        }
    
        recordsTotal = ListVDiagramaDetailModel.Count;
    
        /* Reordenar segun lo solicitado en el Grid */
        switch (sortColumn)
        {
            case "diagramaDetailId":
                if (sortColumnDir == "asc")
                    ListVDiagramaDetailModel = ListVDiagramaDetailModel.OrderBy(x => x.DiagramaDetailId).Skip(skip).Take(pageSize).ToList();
                else
                    ListVDiagramaDetailModel = ListVDiagramaDetailModel.OrderByDescending(x => x.DiagramaDetailId).Skip(skip).Take(pageSize).ToList();
                break;
    
            default:
                break;
        }
    
        return Json(new { draw, recordsFiltered = recordsTotal, recordsTotal, data = ListVDiagramaDetailModel });
    }
    

    Tanks for all, gracias por la ayuda

Sign In or Register to comment.