/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

41 votes298 views6 answers
Jquery remove element
Javascript jQuery
0 vote290 views2 answers
Jquery smooth scrool
Javascript jQuery
61 votes260 views3 answers
Google apis jquery
Javascript jQuery
12 votes296 views3 answers
Set custom data attribute jquery
Javascript jQuery
0 vote289 views1 answer
Jquery observe class change
Javascript jQuery
0 vote280 views1 answer
Jquery autocomplete bootstrap modal
Javascript jQuery
2 votes306 views1 answer
How to set text for label in jquery
Javascript jQuery
0 vote270 views1 answer
How i change background of row in javascript jquery
Javascript jQuery
1 vote268 views4 answers
Id to id for append jquery
Javascript jQuery
18 votes297 views5 answers
JQuery AJAX form submit
Javascript jQuery