public virtual ActionResult GetSliderDataTable(int page = 0, int count = 10, Order order = Order.Descending,
SliderOrderBy orderBy = SliderOrderBy.ById)
{
ViewBag.CurrentPage = page + 1;
ViewBag.TotalRecords = _SliderService.GetSlidersCount();
ViewBag.Count = count;
return(PartialView(MVC.Admin.Slider.Views._SliderDataTable,
_SliderService.GetSliderDataTable(page, count, order, orderBy)));
}
public IList <SliderDataTableModel> GetSliderDataTable(int page, int count, Order order = Order.Asscending,
SliderOrderBy orderBy = SliderOrderBy.ById)
{
IQueryable <SliderDataTableModel> lstSliders =
_Sliders.Include(Slider => Slider.User)
.Select(
Slider =>
new SliderDataTableModel
{
Id = Slider.Id,
Title = Slider.Title,
Priority = Slider.Priority,
Status = Slider.Status,
Link = Slider.Link,
Picture = Slider.Picture
})
.AsQueryable();
if (order == Order.Asscending)
{
switch (orderBy)
{
case SliderOrderBy.ById:
lstSliders = lstSliders.OrderBy(Slider => Slider.Id).AsQueryable();
break;
case SliderOrderBy.ByTitle:
lstSliders = lstSliders.OrderBy(Slider => Slider.Title).AsQueryable();
break;
case SliderOrderBy.ByPriority:
lstSliders = lstSliders.OrderBy(Slider => Slider.Priority).AsQueryable();
break;
}
}
else
{
switch (orderBy)
{
case SliderOrderBy.ById:
lstSliders = lstSliders.OrderByDescending(Slider => Slider.Id).AsQueryable();
break;
case SliderOrderBy.ByTitle:
lstSliders = lstSliders.OrderByDescending(Slider => Slider.Title).AsQueryable();
break;
case SliderOrderBy.ByPriority:
lstSliders = lstSliders.OrderByDescending(Slider => Slider.Priority).AsQueryable();
break;
}
}
return(lstSliders.Skip(page * count).Take(count).ToList());
}
