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