Search
 
SCRIPT & CODE EXAMPLE
 

JAVASCRIPT

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;
             }
         }
     }
 }
Comment

PREVIOUS NEXT
Code Example
Javascript :: aframe react 
Javascript :: how to dynamically populate pdf with pdfmake node 
Javascript :: react-redux todo list 
Javascript :: add int to string javascirpt 
Javascript :: postman environment variable 
Javascript :: javascript substration between times 
Javascript :: promise.all in javascript 
Javascript :: promise javascript 
Javascript :: how to check request type in js 
Javascript :: javascript get the last item in an array 
Javascript :: object literals and array literals in javascript 
Javascript :: find second largest number in array javascript 
Javascript :: Install PHP debugbar 
Javascript :: what are built in objects in javascript 
Javascript :: how to use cros 
Javascript :: how to use fetch api 
Javascript :: iterate table in jquery 
Javascript :: angular component 
Javascript :: create record mongoose model 
Javascript :: 2 dimensional array index of element value 
Javascript :: Vue JS Syntax error: "Unexpected Token, expected 
Javascript :: olx clone react 
Javascript :: infinite carousel javascript 
Javascript :: No match found for location with path 
Javascript :: trimend in javascript 
Javascript :: plus in javascript 
Javascript :: get number right of the dot length javascript 
Javascript :: dynamodb count items node 
Javascript :: eval javascript 
Javascript :: scirpt tag react 
ADD CONTENT
Topic
Content
Source link
Name
3+2 =