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));
}
