Exemplos de DataTablesResponse.CreateResponse em C# (CSharp)

Exemplo n.º 1

Arquivo: CategoryController.cs Projeto: war-man/lab-sample

        // for display datatable
        public ActionResult GetCategoryList(DataTablesRequest param)
        {
            //http://www.justinmichaels.net/using-jquery-datatables-with-asp-net-mvc-for-serverside-filtering-sorting-and-paging
            var categoryList = _db.Categories.AsEnumerable();

            var viewCategoryList = categoryList;

            IEnumerable <Category> filteredCategoryList;

            if (!string.IsNullOrEmpty(param.sSearch))
            {
                filteredCategoryList = viewCategoryList.Where(cat => (cat.Name ?? "").Contains(param.sSearch)).ToList();
            }
            else
            {
                filteredCategoryList = viewCategoryList;
            }

            var viewDataList = filteredCategoryList.Skip(param.iDisplayStart).Take(param.iDisplayLength).ToList();

            string[] data = viewDataList.ConvertAll(x => x.ToString()).ToArray();

            var result = DataTablesResponse.CreateResponse(param, categoryList.Count(), filteredCategoryList.Count(), data);

            return(Json(result, JsonRequestBehavior.AllowGet));
        }