/// <summary> /// Display datatable /// </summary> /// <param name="searchString">string you want to search</param> /// <param name="sorting">sorting type (acs or decs)</param> /// <param name="searchPageSize">number record per page</param> /// <param name="searchPage">page range</param> /// <returns></returns> public ActionResult Index(string searchString, string sorting = "decs", int searchPageSize = 10, int searchPage = 1) { ViewBag.SearchString = searchString; if (sorting.Equals("asc")) { sorting = "decs"; } else { sorting = "asc"; } ViewBag.Sorting = sorting; ViewBag.SearchRolePage = searchPage; ViewBag.SearchRolePageSize = searchPageSize; var dao = new RoleDao(); var model = dao.listAllPaging(searchString, sorting, searchPageSize, searchPage); var totalRows = dao.totalRows(searchString); if (totalRows == 0) { ViewBag.SearchRolePageDisplay = 0; } else { ViewBag.SearchRolePageDisplay = (searchPage - 1) * searchPageSize + 1; } var pageRange = searchPage * searchPageSize; if (totalRows > (pageRange)) { ViewBag.SearchRolePageSizeDisplay = pageRange; } else { ViewBag.SearchRolePageSizeDisplay = totalRows; } ViewBag.TotalRoleDisplay = totalRows; return(View(model)); }