public ActionResult LoadGrid() { try { var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]")?.FirstOrDefault() + "][name]")?.FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]")?.FirstOrDefault(); var searchValue = Request.Form.GetValues("search[value]")?.FirstOrDefault(); //Paging Size (10,20,50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; // Getting all data var sliderData = (from tempsliders in _sliderService.GetAllSliders() select tempsliders); //Search if (!string.IsNullOrEmpty(searchValue)) { sliderData = sliderData.Where(m => m.Name.Contains(searchValue)); } //total number of rows count var enumerable = sliderData as Slider[] ?? sliderData.ToArray(); recordsTotal = enumerable.Count(); //Paging var data = enumerable.Skip(skip).Take(pageSize); //Returning Json Data return(new JsonResult() { Data = new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data.Select(x => new SliderModel() { IsActive = x.IsActive, Id = x.Id, Name = x.Name.Trim(), UserId = x.UserId, CreatedOn = x.CreatedOn, DisplayArea = x.DisplayArea, DisplayAreaString = x.DisplayArea > 0 ? EnumExtensions.GetDescriptionByValue <DisplayAreas>(x.DisplayArea) : "", DisplayOrder = x.DisplayOrder, MaxPictures = x.MaxPictures, ShowCaption = x.ShowCaption, ShowNextPrevIndicators = x.ShowNextPrevIndicators, ShowThumbnails = x.ShowThumbnails }).OrderBy(x => x.Name).ToList() }, ContentEncoding = Encoding.Default, ContentType = "application/json", JsonRequestBehavior = JsonRequestBehavior.AllowGet, MaxJsonLength = int.MaxValue }); } catch (Exception ex) { throw new Exception(ex.Message); } }
public virtual ActionResult AdvancedSearch() { var model = _sliderService.GetAllSliders(); return(PartialView(MVC.Home.Views._AdvancedSearch, model)); }