/Javascript/jQuery/Jquery datatable server side pagination asp.net core

Jquery datatable server side pagination asp.net core

using DatatableDemo.Data;
 using Microsoft.AspNetCore.Http;
 using Microsoft.AspNetCore.Mvc;
 using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Threading.Tasks;
  
 namespace DatatableDemo.Controllers
 {
     [Route("api/[controller]")]
     [ApiController]
     public class UsersController : ControllerBase
     {
         private readonly AppDBContext _context;
  
         public UsersController(AppDBContext context)
         {
             _context = context;
         }
         [HttpPost("GetUsers")]
         public IActionResult GetUsers()
        {
             try
             {
                 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 sortColumnDirection = Request.Form["order[0][dir]"].FirstOrDefault();
                 var searchValue = Request.Form["search[value]"].FirstOrDefault();
                 int pageSize = length != null ? Convert.ToInt32(length) : 0;
                 int skip = start != null ? Convert.ToInt32(start) : 0;
                 int recordsTotal = 0;
                 var userData = (from tempuser in _context.users select tempuser);
                 if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDirection)))
                 {
                     userData = userData.OrderBy(s => sortColumn + " " + sortColumnDirection);
                 }
                 if (!string.IsNullOrEmpty(searchValue))
                 {
                     userData = userData.Where(m => m.FirstName.Contains(searchValue)
                                                 || m.LastName.Contains(searchValue)
                                                 || m.Contact.Contains(searchValue)
                                                 || m.Email.Contains(searchValue)
                                                 || m.Address.Contains(searchValue));
                 }
                 recordsTotal = userData.Count();
                 var data = userData.Skip(skip).Take(pageSize).ToList();
                 var jsonData = new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data };
                 return Ok(jsonData);
             }
             catch (Exception ex)
             {
                 throw;
             }
         }
     }
 }

Source: freecodespot.com

Similar codes

0 vote163 views1 answer
Jquery rotate
Javascript jQuery
16 votes145 views2 answers
Disable input field from jquery
Javascript jQuery
0 vote158 views1 answer
Js require jquery
Javascript jQuery
6 votes181 views3 answers
How to validate the radio button using jquery
Javascript jQuery
0 vote190 views1 answer
Add on click to div using jquery
Javascript jQuery
3 votes166 views2 answers
Jquery form serialize object
Javascript jQuery
60 votes167 views6 answers
Get value by id in jquery
Javascript jQuery
4 votes158 views1 answer
Go to anchor jquery
Javascript jQuery
6 votes168 views5 answers
Change label value jquery
Javascript jQuery
2 votes176 views1 answer
Remove add event listener jquery
Javascript jQuery