public static IQueryable <T> AddPagination <T>(this IQueryable <T> query, PagingData paging) { if (paging == null) { return(query); } if (!paging.Page.HasValue || paging.Page < 0) { paging.Page = 0; } if (paging.PageSize.HasValue) { if (paging.PageSize < 1) { paging.PageSize = 5; } query = query.Skip(paging.Page.Value * paging.PageSize.Value) .Take(paging.PageSize.Value); } return(query); }
public static MvcHtmlString PageLinks(this HtmlHelper html, PagingData pagingData, Func <int, string> pageUrl, Func <int, string> onClick) { StringBuilder result = new StringBuilder(); string prevLink = (pagingData.CurrentPage == 1) ? BuildHtmlItem(pageUrl(pagingData.CurrentPage - 1), "«", onClick(pagingData.CurrentPage - 1), false, true) : BuildHtmlItem(pageUrl(pagingData.CurrentPage - 1), "«", onClick(pagingData.CurrentPage - 1)); result.Append(prevLink); var start = (pagingData.CurrentPage <= pagingData.PagesPerGroup + 1) ? 1 : (pagingData.CurrentPage - pagingData.PagesPerGroup); var end = (pagingData.CurrentPage > (pagingData.TotalPages - pagingData.PagesPerGroup)) ? pagingData.TotalPages : pagingData.CurrentPage + pagingData.PagesPerGroup; for (int i = start; i <= end; i++) { string pageHtml = string.Empty; pageHtml = (i == pagingData.CurrentPage) ? BuildHtmlItem(pageUrl(i), i.ToString(), onClick(i), true) : BuildHtmlItem(pageUrl(i), i.ToString(), onClick(i)); result.Append(pageHtml); } string nextLink = (pagingData.CurrentPage == pagingData.TotalPages) ? BuildHtmlItem(pageUrl(pagingData.CurrentPage + 1), "»", onClick(pagingData.CurrentPage + 1), false, true) : BuildHtmlItem(pageUrl(pagingData.CurrentPage + 1), "»", onClick(pagingData.CurrentPage + 1)); result.Append(nextLink); return(MvcHtmlString.Create(result.ToString())); }
/// <summary> /// 统计的分页方法 /// </summary> /// <param name="DT"></param> /// <returns></returns> public static PagingData QueryStaticsForPaging(DataTransmission DT) { try { //DataQuery _DQ = new DataQuery(); PagingData _DS = IDataQuery.QueryStaticsForPaging(DT); return(_DS); } catch (Exception ex) { String errMsg = String.Empty; errMsg += "dataSource:" + DT.DataSource.ToString(); errMsg += ",fileds:"; for (int i = 0; i < DT.Fields.Length; i++) { errMsg += DT.Fields[i].ToString() + "||"; } for (int i = 0; i < DT.Filters.Count; i++) { errMsg += DT.Filters[i].GetString + "||"; } errMsg += ",orders:"; for (int i = 0; i < DT.Orders.Count; i++) { errMsg += DT.Orders[i].ToQueryString() + "||"; } errMsg += ",FirstResult:" + DT.FirstResult; errMsg += ",MaxResult:" + DT.MaxResult; LogHelper.WriteLog(errMsg + ",QueryStaticsForPaging方法异常:", ex); //LogHelper.WriteLog("源名:" + DT.DataSource.ToString() + ",QueryStaticsForPaging方法异常:", ex); throw new Exception(DT.DataSource.ToString() + ex.ToString()); //throw ex; } }
public async Task GetNewHitsPlaylistsTestMethod() { await AuthorizeAsyncTestMethod(); PagingData paging = new PagingData { Offset = 0, Limit = 10, }; var playlistsResult = await OpenAPI.GetNewHitsPlaylistsAsync(paging.Limit, paging.Offset); var playlists = playlistsResult.Content; foreach (var item in playlists.Data) { Debug.WriteLine($"new hits playlist: {item.Title}"); var detailPlaylistResult = await OpenAPI.GetPlaylistOfNewHitsPlaylistsAsync(item.Id); var detailPlaylist = detailPlaylistResult.Content; foreach (var trackItem in detailPlaylist.Tracks.Data) { Debug.WriteLine($"private playlist track: {trackItem.Id}, {trackItem.Name}"); } } }
public async Task GetChartsAndPlaylistTracks() { var chartPlaylistsResult = await OpenAPI.GetChartListAsync(); var chartPlaylists = chartPlaylistsResult.Content; foreach (var item in chartPlaylists.Data) { Debug.WriteLine($"chart playlist: {item.Title}, {item.Id}"); PagingData tracksPaging = null; // Get playlist information var playlist = await OpenAPI.GetPlaylistOfChartAsync(item.Id); // Get tracks of the playlist var tracksResult = await OpenAPI.GetPlaylistTracksOfChartAsync(item.Id, tracksPaging?.Limit, tracksPaging?.Offset); var tracks = tracksResult.Content; tracksPaging = tracks.Paging; tracksPaging.Offset = tracks.Paging.NextOffset(); foreach (var track in tracks.Data) { Debug.WriteLine($"song: {track.Name}, {track.Id}"); } if (tracksPaging.IsEnd()) { // Loop to get all tracks of the playlist } } }
public Index(PagingData <UserContract> users, UserGroupId groupId, string name, bool verifiedArtists) { Users = users; GroupId = groupId; Name = name; VerifiedArtists = verifiedArtists; }
// // GET: /User/ public ActionResult Index(Index model, string filter = null, UserSortRule?sort = null, int totalCount = 0, int page = 1) { if (!string.IsNullOrEmpty(filter) && string.IsNullOrEmpty(model.Name)) { model.Name = filter; } if (Request.IsAjaxRequest()) { return(UsersPaged(model.GroupId, model.Name, model.Disabled, model.VerifiedArtists, sort ?? UserSortRule.RegisterDate, totalCount, page)); } var pageIndex = page - 1; var groupId = model.GroupId; var sortRule = sort ?? UserSortRule.RegisterDate; var result = Data.GetUsers(groupId, model.Name, model.Disabled, model.VerifiedArtists, sortRule, PagingProperties.CreateFromPage(pageIndex, usersPerPage, true)); if (page == 1 && result.TotalCount == 1 && result.Items.Length == 1) { return(RedirectToAction("Profile", new { id = result.Items[0].Name })); } var data = new PagingData <UserContract>(result.Items.ToPagedList(pageIndex, usersPerPage, result.TotalCount), null, "Index", "usersList"); data.RouteValues = new RouteValueDictionary(new { groupId, name = model.Name, disabled = model.Disabled, sortRule, totalCount = result.TotalCount, action = "Index" }); return(View(new Index(data, groupId, model.Name, model.VerifiedArtists))); }
/// <summary> /// 查询音乐,模糊查询 /// </summary> /// <param name="condition">条件筛选,歌手,标题,标签,专辑</param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public PagingData <Music> GetMusicList(string condition, int pageIndex, int pageSize) { var rsp = new PagingData <Music>(); if (string.IsNullOrEmpty(condition)) { rsp.Countnum = yfjbContext.Music.Where(m => m.Status == 1).Count(); rsp.Data = yfjbContext.Music.Where(m => m.Status == 1).OrderByDescending(m => m.Id) .Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); } else { rsp.Countnum = yfjbContext.Music.Where(m => m.Status == 1 && (m.Singer.Contains(condition) || m.Title.Contains(condition) || m.Tag.Contains(condition) || m.Album.Contains(condition))).Count(); rsp.Data = yfjbContext.Music.Where(m => m.Status == 1 && (m.Singer.Contains(condition) || m.Title.Contains(condition) || m.Tag.Contains(condition) || m.Album.Contains(condition))) .OrderByDescending(m => m.Id) .Skip((pageIndex - 1) * pageSize) .Take(pageSize) .ToList(); } return(rsp); }
public JsonResult GetJsonList([FromQuery] PagingData pg) { ExtResult er = new ExtResult(); er.success = true; er.totalCount = 0; try { DataTable dt = DbUtil.QueryDT(""); int count = 2; er.totalCount = count; for (int i = 0; i < count; i++) { er.data[i] = ""; } return(new JsonResult(er)); } catch (Exception e) { //throw e; er.success = false; er.msg = e.Message; return(new JsonResult(er)); } }
public static SearchResult <T> FetchSearchResult <TBase, TMap, T>( this IQueryable <TBase> baseQuery, Func <IQueryable <TBase>, IQueryable <TMap> > map, Func <IEnumerable <TMap>, IEnumerable <T> > transform, PagingData pagingData, bool fetchTotalCount = true) { if (map == null) { throw new ArgumentNullException(nameof(map)); } if (transform == null) { throw new ArgumentNullException(nameof(transform)); } var totalResults = fetchTotalCount ? baseQuery.Count() : (int?)null; var queryPagingData = pagingData ?? new PagingData(1, DefaultPageSize, 0); var resultPagingData = fetchTotalCount ? PagingData.MakeForResultCount(queryPagingData, totalResults.Value) : queryPagingData; var items = baseQuery .Map(map) .FetchPage(resultPagingData) .Transform(transform); return(new SearchResult <T>(items, resultPagingData)); }
public JsonResult GetJsonList([FromQuery] PagingData pg) { ExtResult er = new ExtResult(); er.success = true; er.totalCount = 0; try { int total = 0; DataTable dt = DbUtil.Query("SELECT * FROM PAYMENT_BILL_REQ ", pg.start, pg.limit, ref int total); int count = 2; er.totalCount = count; for (int i = 0; i < count; i++) { er.data[i] = ""; } return(new JsonResult(er)); } catch (Exception e) { //throw e; er.success = false; er.msg = e.Message; return(new JsonResult(er)); } }
public static async Task<List<User>> GetUserAsync(this IAdminAccessBll accessBll, SessionToken token, PagingData page) { var result = await AdminAccessWs.GetUsersAsync( token.ToWebSeriveObject<WS.SessionToken>(), page.ToWebSeriveObject<WS.PagingData>()); return ProxyHelper.ToListOf<WS.User, BLL.User>(result); }
public async Task GetAlbumAndTracks() { string albumId = "WpTPGzNLeutVFHcFq6"; // Get album information var albumResult = await OpenAPI.GetAlbumAsync(albumId); var album = albumResult.Content; Debug.WriteLine($"album: {album.Name}, {album.Id}"); PagingData tracksPaging = null; // Get tracks of the album var tracksResult = await OpenAPI.GetTracksOfAlbumAsync(album.Id, tracksPaging?.Limit, tracksPaging?.Offset); var tracks = tracksResult.Content; tracksPaging = tracks.Paging; tracksPaging.Offset = tracks.Paging.NextOffset(); foreach (var track in tracks.Data) { Debug.WriteLine($"song: {track.Name}, {track.Id}"); } if (tracksPaging.IsEnd() == false) { // Loop to get all tracks of the album } }
/// <summary> /// 统计的分页方法 /// </summary> /// <param name="dataSource">统计的名称</param> /// <param name="fileds">选择列</param> /// <param name="filters">过滤条件</param> /// <param name="orders">排序条件</param> /// <param name="selectors">选择条件</param> /// <param name="page">页数</param> /// <param name="pageSize">每页显示多少条</param> /// <param name="statisticsEngName">统计的名称</param> /// <returns></returns> public static PagingData QueryByStatisticForPaging(WebDataSource dataSource, String[] fileds, List <Expression> filters, List <Order> orders, List <Expression> selectors, int page, int pageSize, String statisticsEngName) { try { DataTransmission _data = GetData(dataSource, fileds, filters, orders, selectors, page, pageSize, true, statisticsEngName); PagingData _DS = QueryStaticsForPaging(_data); return(_DS); } catch (Exception ex) { String errMsg = String.Empty; errMsg += "dataSource:" + dataSource.ToString(); errMsg += ",fileds:"; for (int i = 0; i < fileds.Length; i++) { errMsg += fileds[i].ToString() + "||"; } for (int i = 0; i < filters.Count; i++) { errMsg += filters[i].GetString + "||"; } errMsg += ",orders:"; for (int i = 0; i < orders.Count; i++) { errMsg += orders[i].ToQueryString() + "||"; } errMsg += ",page:" + page; errMsg += ",pageSize:" + pageSize; LogHelper.WriteLog(errMsg + ",QueryByStatisticForPaging方法异常:", ex); throw new Exception(dataSource.ToString() + ex.ToString()); //throw ex; } }
public JsonNetResult QueryCouponCard(WebQueryFilter filter) { if (this.Auth.GetAuthenticatedUser() == null) { return new JsonNetResult() { Data = new { } } } ; var merchant = this.Merchant.GetDefaultMerchant(); filter.Columns.Add(new QueryColumnFilter() { Data = "Merchant.Id", Searchable = true, DbType = System.Data.DbType.Int64, Search = new SearchColumnFilter() { Regex = false, Value = merchant.Id } }); var model = this.CardCoupon.QueryCardCoupon(filter, new PagingCondition(filter.Start, filter.Length)); var viewModel = new PagingData <CardCouponWithoutWapperViewModel>(model.Items.Select(o => new CardCouponWithoutWapperViewModel(o))) { Paging = model.Paging, TotalCount = model.TotalCount }; return(new JsonNetResult() { Data = viewModel }); }
public async Task <JsonResult> GetJobHistory() { int count = 0; QuartzScheduler context = new QuartzScheduler(quartzJobStoreSettings.QuartzConnectionString); var dataTableData = new DataTableData <QRTZ_JOB_HISTORY>(); var gridData = context.QRTZ_JOB_HISTORY.ToList();//new List<QRTZ_JOB_HISTORY>(); PagingData pgData = new PagingData(Request.QueryString); Expression <Func <QRTZ_JOB_HISTORY, bool> > where = w => ( w.JOB_NAME.Contains(pgData.Search ?? "")); /* Expression<Func<Order, bool>> where = w => ( * w.OrderNumber != "");*/ dataTableData.draw = pgData.Draw; // count = gridData.Count; gridData = await GetList(gridData.Where(d => d.JOB_NAME != "").AsQueryable().OrderByDescending(d => d.STARTDATE).ThenBy(d => d.JOB_NAME), pgData, where); dataTableData.data = gridData; dataTableData.recordsFiltered = count; dataTableData.recordsTotal = count; dataTableData.success = true; return(Json(dataTableData, JsonRequestBehavior.AllowGet)); }
public void OnGet(int PageNum = 1) { DynamicParameters parameter = new DynamicParameters(); parameter.Add("@PageNum", PageNum, DbType.Int32, ParameterDirection.Input); parameter.Add("@pageSize", PageSize, DbType.Int32, ParameterDirection.Input); Employees = _SPCall.ReturnList <Employee>("DapperPaging_Employee_GetAll", parameter).ToList <Employee>(); StringBuilder QParam = new StringBuilder(); if (PageNum != 0) { QParam.Append($"/Index?PageNum=-"); } if (Employees.Count > 0) { PagingData = new PagingData { CurrentPage = PageNum, RecordsPerPage = PageSize, TotalRecords = Employees[0].TotalRows, UrlParams = QParam.ToString(), LinksPerPage = 5 }; } }
public Index(PagingData<UserContract> users, UserGroupId groupId, string name, bool verifiedArtists) { Users = users; GroupId = groupId; Name = name; VerifiedArtists = verifiedArtists; }
public RequestResponse <string> GetImages([FromBody] PagingData pagingData) { var lstImages = _storageHelper.GetList(pagingData.SkipCount, pagingData.PageSize).ToList(); return(new RequestResponse <string> { Data = lstImages, Success = true, Message = FaceGraphConsts.SUCCESS_MESSAGE }); }
public ActionResult Deleted() { var result = Service.GetDeleted(0, entriesPerPage); var data = new PagingData <AlbumContract>(result.Items.ToPagedList(0, entriesPerPage, result.TotalCount), null, "DeletedPaged", "albums"); return(View(data)); }
public virtual PagingData <object> SelectPaging(Type entityType, int pageIndex, int pageSize) { Check.NotNull(entityType); PagingData <object> data = this.DbContext.Set(entityType).ToGeneric().ToPagingData(pageIndex, pageSize); data.Data = data.Data.Select(item => item.Duplicate()).ToArray(); return(data); }
public UiPageList(MainWindow mainWindow) { _mainWindow = mainWindow; _pageList = new Dictionary<int, PhotoList> { { 1, new PhotoList(_mainWindow) } }; Paging = new PagingData(this); }
public virtual PagingData <TEntity> SelectPaging <TKey>(int pageIndex, int pageSize, Expression <Func <TEntity, TKey> > keySelector, ListSortDirection sortDirection = ListSortDirection.Ascending) { Check.NotNull(keySelector); PagingData <TEntity> data = this.DbContext.Set <TEntity>().OrderBy(keySelector, sortDirection).ToPagingData(pageIndex, pageSize); data.Data = data.Data.Select(item => item.Duplicate()); return(data); }
public async Task GetNewReleaseList() { PagingData categoryPaging = null; // List of new release categories. var newReleaseCategoryResult = await OpenAPI.GetNewReleaseCategoriesAsync(categoryPaging?.Limit, categoryPaging?.Offset); var newReleaseCategory = newReleaseCategoryResult.Content; foreach (var categoryItem in newReleaseCategory.Data) { Debug.WriteLine($"new release category: {categoryItem.Title}, {categoryItem.Id}"); // To retrieve information of the new release category with {category_id}. var categoryDetailResult = await OpenAPI.GetNewReleaseCategoryAsync(categoryItem.Id); var categoryDetail = categoryDetailResult.Content; PagingData albumPaging = categoryDetail.Albums.Paging; albumPaging.Offset = albumPaging.NextOffset(); foreach (var album in categoryDetail.Albums.Data) { Debug.WriteLine($"album of the new release: {album.Name}, {album.Id} : {categoryDetail.Title}"); } if (albumPaging.IsEnd()) { continue; } var albumsResult = await OpenAPI.GetAlbumsOfNewReleaseCategoryAsync(categoryItem.Id, albumPaging?.Limit, albumPaging?.Offset); var albums = albumsResult.Content; foreach (var album in albums.Data) { Debug.WriteLine($"album of the new release: {album.Name}, {album.Id} : {categoryDetail.Title}"); } albumPaging = albums.Paging; albumPaging.Offset = albumPaging.Offset + albumPaging.Limit; if (string.IsNullOrEmpty(albums.Paging.Next)) { // Loop to get all albums of the category } } categoryPaging = newReleaseCategory.Paging; categoryPaging.Offset = categoryPaging.Offset + categoryPaging.Limit; if (string.IsNullOrEmpty(newReleaseCategory.Paging.Next)) { // List of new release categories. } }
public ActionResult SongsPaged(int id, int?page, int?totalCount) { var pageIndex = (page - 1) ?? 0; var result = Service.GetSongsInList(id, pageIndex * SongsPerPage, SongsPerPage, !totalCount.HasValue); var count = totalCount.HasValue ? totalCount.Value : result.TotalCount; var data = new PagingData <SongInListContract>(result.Items.ToPagedList(pageIndex, SongsPerPage, count), id, "SongsPaged", "songsInList"); return(PartialView("SongsInListPaged", data)); }
public virtual dynamic List(PagingData paging) { if (!string.IsNullOrEmpty(paging.Filter)) { return(_repository.ListByFilter(paging)); } return(_repository.List(paging)); }
public ActionResult DeletedPaged(int?page) { var p = (page - 1) ?? 0; var result = Service.GetDeleted(p * entriesPerPage, entriesPerPage); var data = new PagingData <AlbumContract>(result.Items.ToPagedList(p, entriesPerPage, result.TotalCount), null, "DeletedPaged", "albums"); return(PartialView("PagedAlbums", data)); }
public IEnumerable <dynamic> List(PagingData paging) { var query = _context.Users.AsQueryable(); query = query .AddOrderByCodigo(paging, x => x.Id) .AddPagination(paging); return(query); }
public UiPageList(MainWindow mainWindow) { _mainWindow = mainWindow; _pageList = new Dictionary <int, PhotoList> { { 1, new PhotoList(_mainWindow) } }; Paging = new PagingData(this); }
public virtual PagingData <TEntity> SelectPaging(int pageIndex, int pageSize, string keySelector, ListSortDirection sortDirection = ListSortDirection.Ascending) { Check.NotEmpty(keySelector); DbSet <TEntity> set = this.DbContext.Set <TEntity>(); PagingData <TEntity> data = this.OrderBy(set, keySelector, sortDirection).ToPagingData(pageIndex, pageSize); data.Data = data.Data.Select(item => item.Duplicate()); return(data); }
public IEnumerable <dynamic> ListByFilter(PagingData paging) { var query = _context.Users.Where(Condition(paging)); query = query .AddOrderByCodigo(paging, x => x.Id) .AddPagination(paging); return(query); }
public static SearchResult <TBase> FetchSimpleSearchResult <TBase>( this IQueryable <TBase> baseQuery, PagingData pagingData, bool fetchTotalCount = true) { return(baseQuery.FetchSearchResult(_ => _, _ => _, pagingData, fetchTotalCount)); }
public virtual PagingData <TEntity> SelectPaging(Expression <Func <TEntity, int, bool> > predicate, int pageIndex, int pageSize, string keySelector, ListSortDirection sortDirection = ListSortDirection.Ascending) { Check.NotNull(predicate); Check.NotEmpty(keySelector); IQueryable <TEntity> queryable = this.DbContext.Set <TEntity>().Where(predicate); PagingData <TEntity> data = this.OrderBy(queryable, keySelector, sortDirection).ToPagingData(pageIndex, pageSize); data.Data = data.Data.Select(item => item.Duplicate()); return(data); }
public ActionResult ArtistTagUsages(string id, int? page) { var pageIndex = (page - 1) ?? 0; var result = Service.GetArtists(id, pageIndex * entriesPerPage, entriesPerPage); var data = new PagingData<ArtistTagUsageContract>(result.Items.ToPagedList(pageIndex, entriesPerPage, result.TotalCount), id, "ArtistTagUsages", "ui-tabs-1"); if (Request.IsAjaxRequest()) return PartialView("ArtistTagUsages", data); else return View("ArtistTagUsages", data); }
public DaoResponse<List<Artist>> Select(PagingData page) { throw new System.NotImplementedException(); }
public abstract List<Venue> GetVenues(PagingData page);
public abstract List<Performance> GetPerformances(PagingData page);
public abstract List<Location> GetLocations(PagingData page);
public List<Location> GetLocations(PagingData page) => ViewAccessDelegate.GetLocations(page);
public PartialViewResult AlbumsPaged(int id, ArtistAlbumParticipationStatus? artistParticipation, int? page) { var pageIndex = (page - 1) ?? 0; var queryParams = new AlbumQueryParams { Paging = PagingProperties.CreateFromPage(pageIndex, entriesPerPage, true), SortRule = AlbumSortRule.ReleaseDateWithNulls, ArtistId = id, ArtistParticipationStatus = artistParticipation ?? ArtistAlbumParticipationStatus.Everything }; var result = Services.Albums.Find(queryParams); var target = queryParams.ArtistParticipationStatus == ArtistAlbumParticipationStatus.OnlyCollaborations ? "ui-tabs-3" : "ui-tabs-2"; var data = new PagingData<AlbumContract>(result.Items.ToPagedList(pageIndex, entriesPerPage, result.TotalCount), id, "AlbumsPaged", target); data.RouteValues = new RouteValueDictionary(new { artistParticipation }); return PartialView("PagedAlbums", data); }
public ActionResult UsersPaged(UserGroupId groupId = UserGroupId.Nothing, string name = "", UserSortRule sortRule = UserSortRule.RegisterDate, int totalCount = 0, int page = 1) { var pageIndex = page - 1; var result = Service.GetUsers(groupId, name, sortRule, PagingProperties.CreateFromPage(pageIndex, usersPerPage, false)); var data = new PagingData<UserContract>(result.Items.ToPagedList(pageIndex, usersPerPage, totalCount), null, "Index", "usersList"); data.RouteValues = new RouteValueDictionary(new { groupId, sortRule, totalCount, action = "Index" }); if (Request.IsAjaxRequest()) return PartialView("PagedUsers", data); else return View("PagedUsers", data); }
public ActionResult FavoriteSongsPaged(int id, int? page, SongVoteRating? rating = null, SongSortRule sort = SongSortRule.Name, bool groupByRating = true) { const int songsPerPage = 50; var pageIndex = (page - 1) ?? 0; var r = rating ?? SongVoteRating.Nothing; var queryParams = new RatedSongQueryParams(id, PagingProperties.CreateFromPage(pageIndex, songsPerPage, true)) { FilterByRating = r, SortRule = sort, GroupByRating = groupByRating }; var result = Service.GetFavoriteSongs(queryParams); var data = new PagingData<FavoriteSongForUserContract>(result.Items.ToPagedList(pageIndex, songsPerPage, result.TotalCount), id, "FavoriteSongs", "ui-tabs-3"); data.RouteValues = new RouteValueDictionary(new { action = "FavoriteSongs", id, rating, sort, groupByRating }); return PartialView("FavoriteSongsPaged", data); }
public PartialViewResult AlbumsPaged(int id, int? page) { var pageIndex = (page - 1) ?? 0; var queryParams = new AlbumQueryParams { Paging = PagingProperties.CreateFromPage(pageIndex, entriesPerPage, true), SortRule = AlbumSortRule.Name, ArtistId = id }; var result = Services.Albums.Find(queryParams); var data = new PagingData<AlbumContract>(result.Items.ToPagedList(pageIndex, entriesPerPage, result.TotalCount), id, "AlbumsPaged", "ui-tabs-2"); return PartialView("PagedAlbums", data); }
public ActionResult DeletedPaged(int? page) { var p = (page - 1) ?? 0; var result = Service.GetDeleted(p * entriesPerPage, entriesPerPage); var data = new PagingData<AlbumContract>(result.Items.ToPagedList(p, entriesPerPage, result.TotalCount), null, "DeletedPaged", "albums"); data.RouteValues = new RouteValueDictionary(new { action = "DeletedPaged" }); return PartialView("PagedAlbums", data); }
public ActionResult Deleted() { var result = Service.GetDeleted(0, entriesPerPage); var data = new PagingData<AlbumContract>(result.Items.ToPagedList(0, entriesPerPage, result.TotalCount), null, "DeletedPaged", "albums"); data.RouteValues = new RouteValueDictionary(new { action = "DeletedPaged" }); return View(data); }
public List<Performance> GetPerformances(PagingData page) => ViewAccessDelegate.GetPerformances(page);
public List<Venue> GetVenues(PagingData page) => ViewAccessDelegate.GetVenues(page);
public DaoResponse<List<Artist>> Select(PagingData page) { var artists = new List<Artist>(); var parameter = new Dictionary<string, QueryParameter> { {"?Offset", new QueryParameter {ParameterValue = page.Offset}}, {"?Request", new QueryParameter {ParameterValue = page.Request}} }; using (var connection = _dbCommProvider.CreateDbConnection()) using (var command = _dbCommProvider.CreateDbCommand(connection, SqlQueries.SelectLimit(EntityViewName), parameter)) using (var dataReader = _dbCommProvider.ExecuteReader(command)) { while (dataReader.Read()) { var artist = CreateArtistObject(dataReader); artists.Add(artist); //if (artist.Picture != null) // artist.Picture.DataStream = LoadImagesSource(artist.Picture.Path); } } return artists.Any() ? DaoResponse.QuerySuccessful(artists) : DaoResponse.QueryEmptyResult<List<Artist>>(); }
public Index(PagingData<UserContract> users, UserGroupId groupId, string name) { Users = users; GroupId = groupId; Name = name; }
public DaoResponse<List<Category>> Select(PagingData page) { var categories = new List<Category>(); var parameter = new Dictionary<string, QueryParameter> { {"?Offset", new QueryParameter {ParameterValue = page.Offset}}, {"?Request", new QueryParameter {ParameterValue = page.Request}} }; using (var connection = _dbCommProvider.CreateDbConnection()) using (var command = _dbCommProvider.CreateDbCommand(connection, SqlQueries.SelectLimit(EntityName), parameter)) using (var dataReader = _dbCommProvider.ExecuteReader(command)) { while (dataReader.Read()) { categories.Add(CreateCategoryObject(dataReader)); } } return categories.Any() ? DaoResponse.QuerySuccessful(categories) : DaoResponse.QueryEmptyResult<List<Category>>(); }
public PartialViewResult SongsPaged(int id = invalidId, int? page = null) { var pageIndex = (page - 1) ?? 0; var queryParams = new SongQueryParams { Paging = PagingProperties.CreateFromPage(pageIndex, entriesPerPage, true), SortRule = SongSortRule.Name, ArtistId = id }; var result = Services.Songs.Find(queryParams); var data = new PagingData<SongContract>(result.Items.ToPagedList(pageIndex, entriesPerPage, result.TotalCount), id, "SongsPaged", "ui-tabs-4"); return PartialView("PagedSongs", data); }
public List<Category> GetCategories(PagingData page) => ViewAccessDelegate.GetCategories(page);
public abstract List<Country> GetCountries(PagingData page);
public List<Country> GetCountries(PagingData page) => ViewAccessDelegate.GetCountries(page);
// // GET: /User/ public ActionResult Index(Index model, UserSortRule? sort = null, int totalCount = 0, int page = 1) { if (Request.IsAjaxRequest()) return UsersPaged(model.GroupId, model.Name, sort ?? UserSortRule.RegisterDate, totalCount, page); var pageIndex = page - 1; var groupId = model.GroupId; var sortRule = sort ?? UserSortRule.RegisterDate; var result = Service.GetUsers(groupId, model.Name, sortRule, PagingProperties.CreateFromPage(pageIndex, usersPerPage, true)); var data = new PagingData<UserContract>(result.Items.ToPagedList(pageIndex, usersPerPage, result.TotalCount), null, "Index", "usersList"); data.RouteValues = new RouteValueDictionary(new { groupId, name = model.Name, sortRule, totalCount = result.TotalCount, action = "Index" }); return View(new Index(data, groupId, model.Name)); }
public abstract List<Artist> GetArtists(PagingData page);
public ActionResult AlbumCollectionPaged(AlbumCollectionRouteParams routeParams) { var id = routeParams.id; if (id == invalidId) return NoId(); const int entriesPerPage = 50; var pageIndex = (routeParams.page - 1) ?? 0; var queryParams = new AlbumCollectionQueryParams(id, PagingProperties.CreateFromPage(pageIndex, entriesPerPage, routeParams.count == 0)) { FilterByStatus = routeParams.purchaseStatus ?? PurchaseStatus.Nothing }; var albums = Service.GetAlbumCollection(queryParams); routeParams.count = (albums.TotalCount != 0 ? albums.TotalCount : routeParams.count); var paged = new PagingData<AlbumForUserContract>(albums.Items.ToPagedList(pageIndex, entriesPerPage, routeParams.count), id, "AlbumCollection", "ui-tabs-1"); paged.RouteValues = new RouteValueDictionary(new { action = "AlbumCollection", id, count = routeParams.count, purchaseStatus = routeParams.purchaseStatus }); return PartialView("AlbumCollectionPaged", paged); }
public abstract List<Category> GetCategories(PagingData page);
public List<Artist> GetArtists(PagingData page) => ViewAccessDelegate.GetArtists(page);
public List<User> GetUsers(SessionToken token, PagingData page) => AdminAccessDelegate.GetUsers(token, page);