public string GetBgJqGridJson(IList <JieYueDocDto> list, long totalRecords, PagingParameter paging, int userId) { IList <JsonJqGridRowObject> rows = list.Select(item => new JsonJqGridRowObject(FormatHelper.GetLongString(item.Id), new[] { item.ShenQingrenName, item.Content, item.Company, FormatHelper.GetIntString(item.Year), item.BaogaoMingcheng, item.CabinetNo, item.Path, FormatHelper.GetIntString(item.JieyueTianshu), FormatHelper.GetIsoDateString(item.JieyueShijian), FormatHelper.GetIsoDateString(GetGuihuanShijian(item.JieyueTianshu, item.JieyueShijian, item.ZidingyiGuihuanShijian)), GetOperating(item.Id, userId), GetintervalDays(item.JieyueTianshu, item.JieyueShijian, item.ZidingyiGuihuanShijian), })).ToList(); var jsonJqGridObject = new JsonJqGridObject(rows, totalRecords, paging.PageIndex, paging.PageSize); return(Serialize(jsonJqGridObject)); }
public IList <FaReportName> Find(PagingParameter paging, string query, bool?enable, out long count) { IQueryable <FaReportName> queryable = !string.IsNullOrEmpty(query) ? DataContext.FaReportNames.Where(t => t.Name.Contains(query) || t.Remark.Contains(query)) : DataContext.FaReportNames; if (enable != null) { queryable = queryable.Where(t => t.Enable == enable); } count = queryable.Count(); if (count == 0) { return(new List <FaReportName>()); } int pageSize = paging.PageSize; int pageIndex = paging.PageIndex; pageIndex = pageIndex - 1; queryable = queryable.OrderByDescending(t => t.Name).ThenByDescending(t => t.LastUpdated) .Skip(pageSize * pageIndex).Take(pageSize); return(queryable.ToList()); }
/// <summary> /// Returns A Profile with Images and Paged /// </summary> /// <param name="userid"></param> /// <param name="page"></param> /// <returns></returns> public UserProfilePage GetProfileByUsername(string userName, PagingParameter page) { if (string.IsNullOrEmpty(userName)) { throw new ArgumentException("User Name can't be null or empty"); } var result = ((IUserRepository)Database.UserRepository) .GetPagedUserByUsername(userName, page.PageIndex, page.ItemsPerPage); var userProfile = new UserProfilePage() { User = Mapper.Map <UserDTO>(result), Images = Mapper.Map <List <ImagePost> >(result.Images), Parameters = new PagingParameter() { ItemsPerPage = page.ItemsPerPage, PageIndex = page.PageIndex, TotalItems = ((IImageRepository)Database.ImageRepository).ImagesQuantity(result.Id), } }; return(userProfile); }
public ActionResult <CRMPartner> GetAllPartners([FromQuery] PagingParameter pagingParameter) { var query = _choiceRepoistory.GetAllPartners(pagingParameter); var previousLink = query.HasPrevious ? CreatePartnerResourceUrl(pagingParameter, ResourceUriType.PreviousPage, "GetAllPartners", query.TotalPages) : null; var nextLink = query.HasNext ? CreatePartnerResourceUrl(pagingParameter, ResourceUriType.NextPage, actionName: "GetAllPartners") : null; var pageMetaData = new { totalCount = query.TotalCount, pageSize = query.PageSize, currentPage = query.CurrentPage, totalPages = query.TotalPages, previousPageLink = previousLink, nextPageLink = nextLink }; Response.Headers.Add("custom-Pagination", Newtonsoft.Json.JsonConvert.SerializeObject(pageMetaData)); var temp = _mapper.Map <List <CRMPartner>, List <CRMPartnerDTO> >(query); return(Ok(temp.OrderByDescending(x => x.CRMPartnerId))); }
public async Task <GameLogResult <MatchCueHistory> > GetMatchCueHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId) { var query = _dbContext.MatchCueHistories.Where(x => dateTimeRange.From <= x.Datetime && x.Datetime <= dateTimeRange.To); // todo: indexが効いてるか要確認 if (playerId.HasValue) { query = query.Where(x => x.PlayerId1 == playerId.Value || x.PlayerId2 == playerId.Value || x.PlayerId3 == playerId.Value || x.PlayerId4 == playerId.Value || x.PlayerId5 == playerId.Value || x.PlayerId6 == playerId.Value); } var list = await query.OrderByDescending(x => x.Datetime) .Skip(pagingParameter.CountPerPage * (pagingParameter.PageNumber - 1)) .Take(pagingParameter.CountPerPage) .ToListAsync(); var count = await query.CountAsync(); return(new GameLogResult <MatchCueHistory>(list, count)); }
public async Task <Paging <IssueDTO> > GetIssues(PagingParameter pagingParameter) { var books = await this.GetAllAsyn(); var source = books.Skip((pagingParameter.CurrentPage - 1) * pagingParameter.PageSize).Take(pagingParameter.PageSize); var sourcedto = this._mapper.Map <List <IssueDTO> >(source.ToList()); var PageCount = (int)Math.Ceiling((double)books.Count / pagingParameter.PageSize); Paging <IssueDTO> response = new Paging <IssueDTO> { CurrentPage = pagingParameter.CurrentPage, PageCount = PageCount, TotalCount = books.Count, Items = sourcedto, PageSize = pagingParameter.PageSize }; response.Pages = new List <int>(); for (int i = 1; i <= PageCount; i++) { response.Pages.Add(i); } return(response); }
public async Task <IResponse <IEnumerable <Post> > > GetPostAsync(string username, PagingParameter pagingParameter) { try { if (string.IsNullOrWhiteSpace(username)) { return new Response <IEnumerable <Post> > { IsSuccessful = false, Message = ServiceMessage.InvalidPageId } } ; var posts = await _crawlerUnitOfWork.PostRepo.GetAsync(username, pagingParameter); if (posts.IsNull()) { return new Response <IEnumerable <Post> > { IsSuccessful = false, Message = ServiceMessage.RecordNotExist } } ; return(new Response <IEnumerable <Post> > { Result = posts, IsSuccessful = true, Message = ServiceMessage.Success }); } catch (Exception e) { FileLoger.Error(e); return(new Response <IEnumerable <Post> > { IsSuccessful = false, Message = ServiceMessage.Exception }); } }
public IList <FaCabinetNo> GetCabinetNos(PagingParameter paging, string query, bool?enable, out long count) { return(_faCabinetNoRepository.Find(paging, query, enable, out count)); }
public IList <FaReportName> GetReportNames(PagingParameter paging, string query, bool?enable, out long count) { return(_faReportNameRepository.Find(paging, query, enable, out count)); }
public PagedList <Booking> GetAllBookings(PagingParameter pagingParameter) { var data = _unitOfWork.BookingRepository.GetAllBookings(pagingParameter); return(data); }
public async Task <GameLogResult <PlayerAccountCreateHistory> > GetPlayerAccountCreateHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId) { var query = _dbContext.PlayerAccountCreateHistories.Where(x => dateTimeRange.From <= x.Datetime && x.Datetime <= dateTimeRange.To); if (playerId.HasValue) { query = query.Where(x => x.PlayerId == playerId.Value); } var list = await query.OrderByDescending(x => x.Datetime) .Skip(pagingParameter.CountPerPage * (pagingParameter.PageNumber - 1)) .Take(pagingParameter.CountPerPage) .ToListAsync(); var count = await query.CountAsync(); return(new GameLogResult <PlayerAccountCreateHistory>(list, count)); }
public async Task <PaginatedList <SongBrief> > _Page_fromDB(SongFilterParameter queryParameter, PagingParameter pagingParameter) { var query = _context.OSSongs .Include(s => s.CreatedBy) .AsNoTracking(); _SetIQueryableWhereConditions(query, queryParameter); var count = await query.CountAsync(); if (pagingParameter != null) { bool bIsAscending = (pagingParameter.columnOrder?.ToLower() ?? "asc") == "asc" ? true : false; pagingParameter.columnToOrder = pagingParameter.columnToOrder?.ToLower() ?? "title"; switch (pagingParameter?.columnToOrder) { case "title": default: query = bIsAscending ? query.OrderBy(s => s.Title) : query.OrderByDescending(s => s.Title); break; // TODO: other cases as needed. } //Apply paging //Offset before limit! if (pagingParameter.offset != null) { query = query.Skip((int)pagingParameter?.offset); } if (pagingParameter.limit != null) { query = query.Take((int)pagingParameter?.limit); } } var songs = await query.ToListAsync(); return(new PaginatedList <SongBrief> { Items = songs.Select(s => new SongBrief(s)).ToList(), Total = count, CurrentIndex = pagingParameter?.offset ?? 0, PageSize = pagingParameter?.limit ?? 0 }); }
public async Task <PaginatedList <SongBrief> > Page(SongFilterParameter queryParameter, PagingParameter pagingParameter) { if (_useCache) { return(await _Page_fromCache(queryParameter, pagingParameter)); } else { return(await _Page_fromDB(queryParameter, pagingParameter)); } }
public async Task <PaginatedList <SongBrief> > _Page_fromCache(SongFilterParameter queryParameter, PagingParameter pagingParameter) { IEnumerable <OSSong> songs = _FilterSongs(await _GetCache(), queryParameter); var count = songs.Count(); if (pagingParameter != null) { bool bIsAscending = (pagingParameter.columnOrder?.ToLower() ?? "asc") == "asc" ? true : false; pagingParameter.columnToOrder = pagingParameter.columnToOrder?.ToLower() ?? "title"; switch (pagingParameter?.columnToOrder) { case "title": default: songs = bIsAscending ? songs.OrderBy(s => s.Title) : songs.OrderByDescending(s => s.Title); break; // TODO: other cases as needed. } //Apply paging //Offset before limit! if (pagingParameter.offset != null) { songs = songs.Skip((int)pagingParameter?.offset); } if (pagingParameter.limit != null) { songs = songs.Take((int)pagingParameter?.limit); } } return(new PaginatedList <SongBrief> { Items = songs.Select(s => new SongBrief(s)).ToList(), Total = count, CurrentIndex = pagingParameter?.offset ?? 0, PageSize = pagingParameter?.limit ?? 0 }); }
public ActionResult <PartnerEmployeeDTO> GetPartners([FromQuery] PagingParameter pagingParameter = null) { return(Ok(_choiceRepoistory.GetAllPartners(pagingParameter))); }
public async Task <Either <PaginatedList <SongBrief>, ErrorInfo> > Page(SongFilterParameter queryParameter, PagingParameter pagingParameter) { return(await _OSSongRepo.Page(queryParameter, pagingParameter)); }
public async Task <GameLogResult <MatchEntryPlayerHistory> > GetMatchEntryPlayerHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId, string matchId) { var query = _dbContext.MatchEntryPlayerHistories.Where(x => dateTimeRange.From <= x.Datetime && x.Datetime <= dateTimeRange.To); if (playerId.HasValue) { query = query.Where(x => x.PlayerId == playerId.Value); } if (!string.IsNullOrWhiteSpace(matchId)) { query = query.Where(x => x.MatchId == matchId); } var list = await query.OrderByDescending(x => x.Datetime) .Skip(pagingParameter.CountPerPage * (pagingParameter.PageNumber - 1)) .Take(pagingParameter.CountPerPage) .ToListAsync(); var count = await query.CountAsync(); return(new GameLogResult <MatchEntryPlayerHistory>(list, count)); }
public async Task <GameLogResult <PlayerAccountCreateHistory> > GetPlayerAccountCreateHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId) { return(await _gameLogRepository.GetPlayerAccountCreateHistoryList(pagingParameter, dateTimeRange, playerId)); }
public string GetFaCabineNosJqGridJson(IList <FaCabinetNo> list, long totalRecords, PagingParameter paging) { IList <JsonJqGridRowObject> rows = list.Select(item => new JsonJqGridRowObject(FormatHelper.GetLongString(item.Id), new[] { HtmlHelper.Encode(item.CabinetNo), item.Path, GetCabineNoEnable(item.Enable), FormatHelper.GetIsoDateString(item.LastUpdated), GetOperating(item.Enable, item.Id) })).ToList(); var jsonJqGridObject = new JsonJqGridObject(rows, totalRecords, paging.PageIndex, paging.PageSize); return(Serialize(jsonJqGridObject)); }
public async Task <GameLogResult <LogoutHistory> > GetLogoutHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId, string remoteIp) { return(await _gameLogRepository.GetLogoutHistoryList(pagingParameter, dateTimeRange, playerId, remoteIp)); }
public PagedList <CRMPartner> SearchPartnerDetails(PagingParameter pagingParameter, SearchCommonParamters searchCommonParamters) { var data = _unitOfWork.PartnerInfoPubFacingRepository.SearchPartnerDetails(pagingParameter, searchCommonParamters); return(data); }
public async Task <GameLogResult <ChatSayHistory> > GetChatSayHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, int searchType, long?playerId, string groupId, string matchId, int?side) { return(await _gameLogRepository.GetChatSayHistoryList(pagingParameter, dateTimeRange, searchType, playerId, groupId, matchId, side)); }
public PagedList <Booking> SearchBookingDetails(PagingParameter pagingParameter, SearchCommonParamters searchCommonParamters) { var data = _unitOfWork.BookingRepository.SearchBookingDetails(pagingParameter, searchCommonParamters); return(data); }
public async Task <GameLogResult <ChatDirectHistory> > GetChatDirectHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId) { return(await _gameLogRepository.GetChatDirectHistoryList(pagingParameter, dateTimeRange, playerId)); }
public IList <JieYueDocDto> GetPageFaReturnDocs( PagingParameter paging, FaArchiveListParameter parameter, out long count) { return(_faReturnDocRepository.Find(paging, parameter, out count)); }
public async Task <GameLogResult <PartyHistory> > GetPartyHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId, string groupId) { return(await _gameLogRepository.GetPartyHistoryList(pagingParameter, dateTimeRange, playerId, groupId)); }
public IList <FaCompany> GetCompanines(PagingParameter paging, string query, bool?enable, out long count) { return(_faCompanyRepository.Find(paging, query, enable, out count)); }
public async Task <GameLogResult <MatchExecutionHistory> > GetMatchExecutionHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, string matchId) { return(await _gameLogRepository.GetMatchExecutionHistoryList(pagingParameter, dateTimeRange, matchId)); }
public async Task <IEnumerable <Notification> > GetAsync(NotificationStatus status, PagingParameter pagingParameter) { try { var query = "SELECT * "+ "FROM [Notifier].[Notification] n "+ "WHERE n.Status = @Status " + "ORDER BY p.NotificationId ASC "+ "OFFSET @PageSize * (@PageNumber - 1) ROWS "+ "FETCH NEXT @PageSize ROWS ONLY;"; return(await _sqlConnection.ExecuteQueryAsync <Notification>(query, new { Status = status, pagingParameter.PageNumber, pagingParameter.PageSize })); } catch (Exception e) { FileLoger.Error(e); return(null); } }
public async Task <GameLogResult <MatchExitPlayerHistory> > GetMatchExitPlayerHistoryList(PagingParameter pagingParameter, DateTimeRange dateTimeRange, long?playerId, string matchId) { return(await _gameLogRepository.GetMatchExitPlayerHistoryList(pagingParameter, dateTimeRange, playerId, matchId)); }