public JsonResult GetSlider(string sidx, string sord, int page, int rows, string colName, string colValue) //Gets the todo Lists. { int pageIndex = Convert.ToInt32(page) - 1; int pageSize = rows; var sliderList = _sliderBusiness.GetListWT(); var records = (from p in sliderList select new SliderViewModel { TokenKey = p.TokenKey, SliderImage = p.SliderImage, ImageOrder = p.ImageOrder, Title = p.Title, Description = p.Description }).AsQueryable(); //applying filter if (!string.IsNullOrEmpty(colName) && !string.IsNullOrEmpty(colValue)) { records = records.Where(c => c.GetType().GetProperty(colName).GetValue(c, null).ToString().ToLower().Contains(colValue.ToLower())); } int totalRecords = records.Count(); var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows); if (!string.IsNullOrEmpty(sidx) && !string.IsNullOrEmpty(sord)) { if (sord.Trim().ToLower() == "asc") { records = SortHelper.OrderBy(records, sidx); } else { records = SortHelper.OrderByDescending(records, sidx); } } //applying paging records = records.Skip(pageIndex * pageSize).Take(pageSize); var jsonData = new { total = totalPages, page, records = totalRecords, rows = records }; return(Json(jsonData, JsonRequestBehavior.AllowGet)); }
public ActionResult LoadSlider() { var sliderList = _sliderBusiness.GetListWT().OrderBy(c => c.ImageOrder); var vmSliderList = (from c in sliderList select new SliderViewModel { SliderId = c.SliderId, TokenKey = c.TokenKey, SliderImage = "/SliderImage/" + c.SliderImage, Title = c.Title, Description = c.Description, ImageOrder = c.ImageOrder }).ToList(); return(PartialView("_LoadSlider", vmSliderList)); }