Exemplo n.º 1
0
        public JsonResult GetFirms(string sidx, string sord, int page, int rows, bool _search, string searchField, string searchOper, string searchString)
        {
            var res = _FirmService.GetFirmList();

            //   var res = _adminService.GetMasterPackageList();

            sord = (sord == null) ? "" : sord;
            int pageIndex = Convert.ToInt32(page) - 1;
            int pageSize  = rows;

            var PackageList = res.Select(
                t => new
            {
                t.FirmId,
                t.FirmName,
                t.FirmEmail,
                //t.SSN,
                //t.EmailAddress,
                //t.PhoneNumber
            });

            //if (_search)
            //{
            //    switch (searchField)
            //    {
            //        case "PackageName":
            //            PackageList = PackageList.Where(t => t.PackageName.Contains(searchString));
            //            break;
            //        case "MonthlyRate":
            //            PackageList = PackageList.Where(t => t.MonthlyRate.ToString().Contains(searchString));
            //            break;
            //        case "YearlyRate":
            //            PackageList = PackageList.Where(t => t.YearlyRate.ToString().Contains(searchString));
            //            break;
            //        case "SetUpFee":
            //            PackageList = PackageList.Where(t => t.SetUpFee.ToString().Contains(searchString));
            //            break;
            //    }
            //}


            int totalRecords = PackageList.Count();
            var totalPages   = (int)Math.Ceiling((float)totalRecords / (float)rows);

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

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