Esempio n. 1
0
        public JsonResult GetCompanyManager(string sidx, string sort, int page, int rows)
        {
            sort = (sort == null) ? "" : sort;
            int        pageIndex     = Convert.ToInt32(page) - 1;
            int        pageSize      = rows;
            AdminUsers obj           = new AdminUsers();
            var        CompaniesList = obj.GetCompanyManager();
            int        totalRecords  = CompaniesList.Count();
            var        totalPages    = (int)Math.Ceiling((float)totalRecords / (float)rows);

            if (sort.ToUpper() == "DESC")
            {
                CompaniesList = CompaniesList.OrderByDescending(t => t.ServiceFirstCompanyManagerID).ToList();
                CompaniesList = CompaniesList.Skip(pageIndex * pageSize).Take(pageSize).ToList();
            }
            else
            {
                CompaniesList = CompaniesList.OrderBy(t => t.ServiceFirstCompanyManagerID).ToList();
                CompaniesList = CompaniesList.Skip(pageIndex * pageSize).Take(pageSize).ToList();
            }
            var jsonData = new
            {
                total = totalPages,
                page,
                records = totalRecords,
                rows    = CompaniesList
            };

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