Ejemplo n.º 1
0
        /// <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));
        }