public QueryResult <MainPageVideoViewModel> GetVideosForMain(int pageNum, OrderType orderBy, OrderDirection order, int pageSize)
{
var res = _videoRepository.GetAllVideos(pageNum, orderBy, order, pageSize);
MainPageVideoViewModel videoRes = new MainPageVideoViewModel();
int count = 0;
return(new QueryResult <MainPageVideoViewModel>(new MainPageVideoViewModel {
PageNum = pageNum,
VideosArray = res.Select(e => { count = e.Count; return e as VideoViewModel; }).ToList(),
PagesAmount = (int)Math.Ceiling(count / (double)pageSize)
}));
}
public QueryResult <MainPageVideoViewModel> GetVideosForMain(int pageNum, OrderType orderBy, OrderDirection order, int pageSize)
{
var p = new DynamicParameters();
p.Add("@PageNum", pageNum, DbType.Int32);
p.Add("@OrderBy", orderBy, DbType.Int32);
p.Add("@Order", order, DbType.Int32);
var res = Connection.Query <CountViewModel>("GetAllVideos", p, commandType: CommandType.StoredProcedure);
MainPageVideoViewModel videoRes = new MainPageVideoViewModel();
int count = 0;
return(new QueryResult <MainPageVideoViewModel>(new MainPageVideoViewModel {
PageNum = pageNum,
VideosArray = res.Select(e => { count = e.Count; return e as VideoViewModel; }).ToList(),
PagesAmount = (int)Math.Ceiling(count / (double)pageSize)
}));
}
