Utilizing LINQ with a list of AJAX elements for seamless integration with DataTable

Question

Utilizing LINQ with a list of AJAX elements for seamless integration with DataTable

Trying to execute a LINQ query to populate an AJAX list, which will then be used in a DataTable within my View.

This was previously working without any issues when I wasn't using AJAX. The data was directly placed in the model and each row was rendered in a loop. However, this method was very resource-intensive and resulted in slow rendering times for larger queries.

Switching to AJAX, the LINQ query started returning NULL. I have confirmed that data retrieval works fine by implementing a test case with a small sample of AJAX. Nevertheless, the data table does not get populated for some reason.

In short, what I need: Fix the LINQ to List conversion and use it to fill the DataTable.

Below is the controller code:

(controller code here)

And here is the JavaScript code in the View:

(JavaScript code here)

and here is the DataTable section in the View:

(DataTable code here)

Some functions that are not essential for understanding have been omitted.

Thank you for your assistance.

EDIT: Another important point is that the success or failure functions of my datatable are not being executed.

EDIT: I removed the ViewData implementation, and now everything works (tested in POSTMAN)! However, when trying to fetch all data, it exceeds the maximum JSON limit: 2147483644.

Attempting a smaller query, which displays correctly in POSTMAN but doesn't show up in the table, resulting in an error:

http://localhost:51326/Table/Index?draw=1&columns%5B0%5D%5Bdata%5D=0&column…art=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1480633376897 Failed to load resource: the server responded with a status of 404 (Not Found)

Currently working on resolving this issue.

javascript c#asp.net ajax linq

Answer 1

Answer №1

Modified function (excluding dropdown population and DataView operations, which are part of a separate function):

public List<stockAJAX> getList(string selectedGroupType, string selectedList, string selectedAmount)
{
    using (TableEntities context = new TableEntities())
    {
        // Initialize base query
        IQueryable<stock> stocks = context.stocks.AsQueryable();

        // Filtering logic
        if (selectedList == null && selectedGroupType == null)
        {
          // Return all records
        }
        else if (selectedGroupType == "grouptype=Select+GroupType" || selectedGroupType == null || selectedGroupType == "") 
        {
            if (selectedList == null || selectedList == "")
            {
              // Return all records
            }
            else
            {
                stocks = stocks.Where(c=>c.ProductGroup == selectedList);
            }
        }
        else if (selectedList == "list=Select+Company" || selectedList == null || selectedList == "")       
        {
            stocks = stocks.Where(c=>c.GroupType == selectedGroupType);
        }
        else
        {
            stocks = stocks
              .Where(c=>c.ProductGroup == selectedList)
              .Where(c=>c.GroupType == selectedGroupType);
        }

      // Limit data results
      if (selectedAmount != "true") 
      {
        stocks = stocks
          .OrderByDescending(c=>c.DateArrived)
          .Take(1000);
      }

      // Project to DTO
      var result = stocks.Select(c=>new stockAJAX
      {
        StockId = c.StockId,
        ProductGroup = c.ProductGroup,
        GroupType = c.GroupType,
        ItemType = c.ItemType,
        Model = c.Model,
        SerialNo = c.SerialNo,
        NR = c.NR,
        Status = c.Status.ToString(),
        Description = c.Description,
        DateArrived = c.DateArrived.ToString(),
        CurrentLocation = c.CurrentLocation,
        TerminalId = c.TerminalId,
      }).ToList();
    }

    // Return values for DataTable use
    return result;
}

Answer 2

Modified function (excluding dropdown population and DataView operations, which are part of a separate function):

public List<stockAJAX> getList(string selectedGroupType, string selectedList, string selectedAmount)
{
    using (TableEntities context = new TableEntities())
    {
        // Initialize base query
        IQueryable<stock> stocks = context.stocks.AsQueryable();

        // Filtering logic
        if (selectedList == null && selectedGroupType == null)
        {
          // Return all records
        }
        else if (selectedGroupType == "grouptype=Select+GroupType" || selectedGroupType == null || selectedGroupType == "") 
        {
            if (selectedList == null || selectedList == "")
            {
              // Return all records
            }
            else
            {
                stocks = stocks.Where(c=>c.ProductGroup == selectedList);
            }
        }
        else if (selectedList == "list=Select+Company" || selectedList == null || selectedList == "")       
        {
            stocks = stocks.Where(c=>c.GroupType == selectedGroupType);
        }
        else
        {
            stocks = stocks
              .Where(c=>c.ProductGroup == selectedList)
              .Where(c=>c.GroupType == selectedGroupType);
        }

      // Limit data results
      if (selectedAmount != "true") 
      {
        stocks = stocks
          .OrderByDescending(c=>c.DateArrived)
          .Take(1000);
      }

      // Project to DTO
      var result = stocks.Select(c=>new stockAJAX
      {
        StockId = c.StockId,
        ProductGroup = c.ProductGroup,
        GroupType = c.GroupType,
        ItemType = c.ItemType,
        Model = c.Model,
        SerialNo = c.SerialNo,
        NR = c.NR,
        Status = c.Status.ToString(),
        Description = c.Description,
        DateArrived = c.DateArrived.ToString(),
        CurrentLocation = c.CurrentLocation,
        TerminalId = c.TerminalId,
      }).ToList();
    }

    // Return values for DataTable use
    return result;
}

Answer 3

Answer №2

I was able to resolve the issue by following the suggestion to remove references to the ViewData.

[AcceptVerbs(HttpVerbs.Get | HttpVerbs.Post)]
        public JsonResult getAJAX()
        {
            using (TableEntities context = new TableEntities())
            {
                stock = (from c in context.stocks
                         select new stockAJAX
                         {
                             StockId = c.StockId,
                             ProductGroup = c.ProductGroup,
                             GroupType = c.GroupType,
                             ItemType = c.ItemType,
                             Model = c.Model,
                             SerialNo = c.SerialNo,
                             NR = c.NR,
                             Status = c.Status.ToString(),
                             Description = c.Description,
                             DateArrived = c.DateArrived.ToString(),
                             CurrentLocation = c.CurrentLocation,
                             TerminalId = c.TerminalId,
                         }
                                    ).Take(1000).ToList();
            }

            return Json(stock, JsonRequestBehavior.AllowGet);
        }

However, I encountered a new issue where the DataTable is now stuck on "Processing". For more details, please refer to the question posted here: Datatable stuck on "Processing" on initial load

Answer 4

I was able to resolve the issue by following the suggestion to remove references to the ViewData.

[AcceptVerbs(HttpVerbs.Get | HttpVerbs.Post)]
        public JsonResult getAJAX()
        {
            using (TableEntities context = new TableEntities())
            {
                stock = (from c in context.stocks
                         select new stockAJAX
                         {
                             StockId = c.StockId,
                             ProductGroup = c.ProductGroup,
                             GroupType = c.GroupType,
                             ItemType = c.ItemType,
                             Model = c.Model,
                             SerialNo = c.SerialNo,
                             NR = c.NR,
                             Status = c.Status.ToString(),
                             Description = c.Description,
                             DateArrived = c.DateArrived.ToString(),
                             CurrentLocation = c.CurrentLocation,
                             TerminalId = c.TerminalId,
                         }
                                    ).Take(1000).ToList();
            }

            return Json(stock, JsonRequestBehavior.AllowGet);
        }

However, I encountered a new issue where the DataTable is now stuck on "Processing". For more details, please refer to the question posted here: Datatable stuck on "Processing" on initial load

Utilizing LINQ with a list of AJAX elements for seamless integration with DataTable

Answer №1

Answer №2

Similar questions

What could be causing my jQuery to not retrieve the value of the <select> element?

Best practices for setting an array as a state value in ReactJS

Creating a semi-circle donut chart with Highcharts using the Highcharts-ng library

tips on locating the next immediate downloadable cell in a table

Leveraging the power of BigCommerce API with PHP AJAX to enhance cart functionality for accurate

Import a file using Selenium and manipulate its contents

HTML table containing radio buttons styled with Font Awesome icons

Challenges faced with Vuetify's vertical and non-linear stepper components

What is the reason behind a PHP page refresh causing a session variable to be released

What is the best way to extend the page load timeout for the Selenium Chrome driver?

Issue encountered while serializing data in next.js when utilizing getServerSideProps function

What methods can be used to troubleshoot an issue of an AngularJS function not being called

streaming a silverlight video on the webpage

Animate or resize with a focal point

The functionality of jQuery's checked length is not operating as expected

Top approach for receiving real-time json data in laravel

Having trouble getting PHP Ajax File Upload to function properly?

"Successfully making AJAX calls on localhost, but encountering issues when trying to make them online

The XML content fails to display after initiating an AJAX request

Codeigniter 3 - Troubleshooting Ajax Image Upload Issue