private IQueryable <Quote> QueryQuotes(Filters.QuoteFilterOptions options, PagingSettings paging = null) { var quotes = Context.Quote.Where(q => !q.Deleted.HasValue); if (options != null) { if (options.Order == "desc") { quotes = quotes.OrderByDescending(x => x.CreatedDate); } } if (paging != null) { quotes = quotes.Distinct().OrderByDescending(l => l.CreatedDate).ToPagedQueryable(paging); } return(quotes); }
public PaginatedListTests() { //create InMemory DbContext DbContextOptions <TestDbContext> options; var builder = new DbContextOptionsBuilder <TestDbContext>(); builder.UseInMemoryDatabase("PaginatedListTests") .EnableSensitiveDataLogging(); options = builder.Options; _context = new TestDbContext(options); _context.Database.EnsureDeleted(); _context.Database.EnsureCreated(); var settings = new PagingSettings { PageSize = 20 }; _settings = Microsoft.Extensions.Options.Options.Create(settings); _items = new List <TestModel>(); for (int i = 0; i < _testItemsCount; i++) { _items.Add(new TestModel() { Id = Guid.NewGuid(), Name = "test" + i }); } for (int i = 0; i < _testItemsCount; i++) { _items.Add(new TestModel() { Id = Guid.NewGuid(), Name = "name" + i }); } _context.AddRange(_items); _context.SaveChanges(); }
/// <summary> /// Get collection's documents /// </summary> /// <param name="settings">Istance of PagingSettings</param> /// <param name="sortings">list of sortingField</param> /// <param name="token">cancellation token async support</param> /// <returns>Return list of documents</returns> public virtual async Task <IEnumerable <T> > Get(PagingSettings settings, IEnumerable <SortingField> sortings, CancellationToken token = default(CancellationToken)) => (IEnumerable <T>) await GetCollection(null, settings, sortings, null, token);
/// <summary> /// Get collection's documents /// </summary> /// <param name="filter">lambda expression filter</param> /// <param name="settings">Istance of PagingSettings</param> /// <param name="sortings">list of sortingField</param> /// <param name="token">cancellation token async support</param> /// <returns>Return list of documents</returns> public virtual async Task <IEnumerable <T> > Get(Expression <Func <T, bool> > filter, PagingSettings settings, IEnumerable <SortingField> sortings, CancellationToken token = default(CancellationToken)) => (IEnumerable <T>) await GetCollection(filter, settings, sortings, null, token);
public static List <T> ToPagedList <T>(this List <T> items, PagingSettings paging) { return(items.Skip((paging.PageIndex - 1) * paging.PageCount).Take(paging.PageCount).ToList()); }
public static IQueryable <T> ToPagedQueryable <T>(this IQueryable <T> items, PagingSettings paging) { return(items.Skip((paging.PageIndex - 1) * paging.PageCount).Take(paging.PageCount)); }
public List <Webhook> GetWebhookList() { var settings = new PagingSettings(); return(GetWebhookListPager(settings)); }
public List <Lead> GetAll(Filters.LeadFilterOptions options = null, PagingSettings paging = null) { return(Repository.GetAll(options, paging)); }
/// <summary> /// Get collection's documents /// </summary> /// <param name="settings">Istance of PagingSettings</param> /// <param name="projection">defines a projection document to specify or restrict fields to return</param> /// <param name="token">cancellation token async support</param> /// <returns>Return list of documents</returns> public virtual async Task <IEnumerable <T> > Get(PagingSettings settings, Expression <Func <T, object> > projection, CancellationToken token = default(CancellationToken)) { return((IEnumerable <T>) await GetCollection(null, settings, null, projection, token)); }
/// <summary> /// Get collection's documents /// </summary> /// <param name="settings">Istance of PagingSettings</param> /// <param name="token">cancellation token async support</param> /// <returns>Return list of documents</returns> public virtual async Task <IEnumerable <T> > Get(PagingSettings settings, CancellationToken token = default(CancellationToken)) { return((IEnumerable <T>) await GetCollection(null, settings, null, null, token)); }
/// <summary> /// Get collection's documents /// </summary> /// <param name="filter">lambda expression filter</param> /// <param name="settings">Istance of PagingSettings</param> /// <param name="sortings">list of sortingField</param> /// <param name="projection">defines a projection document to specify or restrict fields to return</param> /// <param name="token">cancellation token async support</param> /// <returns>Return list of documents</returns> public virtual async Task <IEnumerable <T> > Get(Expression <Func <T, bool> > filter, PagingSettings settings, IEnumerable <SortingField> sortings, Expression <Func <T, object> > projection, CancellationToken token = default(CancellationToken)) { return((IEnumerable <T>) await GetCollection(filter, settings, sortings, projection, token)); }
public List <Page> GetPageList(long surveyId) { var settings = new PagingSettings(); return(GetPageListPager(surveyId, settings)); }
public List <Question> GetQuestionList(long surveyId, long pageId, PagingSettings settings) { return(GetQuestionListPager(surveyId, pageId, settings)); }
public List <Question> GetQuestionList(long surveyId, long pageId) { var settings = new PagingSettings(); return(GetQuestionListPager(surveyId, pageId, settings)); }
public List <Page> GetPageList(long surveyId, PagingSettings settings) { return(GetPageListPager(surveyId, settings)); }
public List <QuoteItem> GetAllItems(Filters.QuoteItemFilterOptions options = null, PagingSettings paging = null) { return(Repository.GetAllItems(options, paging)); }
public List <Task> GetAll(Filters.TaskFilterOptions options = null, PagingSettings paging = null) { var tasks = QueryTasks(options, paging); return(tasks.ToList()); }
public List <Message> GetMessageList(long collectorId) { var settings = new PagingSettings(); return(GetMessageListPager(collectorId, settings)); }
public async Task <IActionResult> OnGetAsync(int id, int?pageIndex) { string token = await idData.GetAccessToken(HttpContext); Token = token; try { Data = new CategoriesViewModel { Data = await client.Get(token, id) }; if (Data.Data.UserId != idData.GetClaimId(User)) { Onwer = await usersClient.Get(token, Data.Data.UserId); } Paging = new PagingSettings { ItemCountPerPage = 8, RouteData = new Dictionary <string, string> { ["id"] = Data.Data.Id.ToString(), } }; IEnumerable <Note> notes; { int count = (await nodesClient.Query(token, categoryId: Data.Data.Id, targets: NoteTargets.Count)).Count(); Paging.MaximumIndex = (count / Paging.ItemCountPerPage) + (count % Paging.ItemCountPerPage > 0 ? 1 : 0); if (!pageIndex.HasValue) { pageIndex = 1; } Paging.CurrentIndex = pageIndex.Value; int offset = (Paging.CurrentIndex - 1) * Paging.ItemCountPerPage; notes = await nodesClient.Query(token, categoryId : Data.Data.Id, offset : offset, count : Paging.ItemCountPerPage); Notes = notes.ToList(); } /*{ * Dictionary<int, Relation> rs = new Dictionary<int, Relation>(); * foreach (Note v in notes) * { * foreach (Relation r in await relationsClient.GetAdjacents(token, v.Id)) * { * if (rs.ContainsKey(r.Id)) * { * continue; * } * * rs.Add(r.Id, r); * } * } * Graph = new GraphViewModel * { * Graph = await RelationHelper.GenerateGraph(nodesClient, client, rs.Values, token) * }; * }*/ } catch { return(NotFound()); } return(Page()); }
public List <Message> GetMessageList(long collectorId, PagingSettings settings) { return(GetMessageListPager(collectorId, settings)); }
public List <Webhook> GetWebhookList(PagingSettings settings) { return(GetWebhookListPager(settings)); }
public List <Recipient> GetRecipientList(long collectorId, long messageId) { var settings = new PagingSettings(); return(GetRecipientListPager(collectorId, messageId, settings)); }
public static List <T> ToPagedList <T>(this IQueryable <T> items, PagingSettings paging) { return(ToPagedQueryable(items, paging).ToList()); }
public List <Recipient> GetRecipientList(long collectorId, long messageId, PagingSettings settings) { return(GetRecipientListPager(collectorId, messageId, settings)); }
public void ShouldReturnPagedSearchResult([Substitute] SearchService service, ISearchServiceRepository serviceRepository, ISearchSettingsRepository settingsRepository, QueryRepository queryRepository, string query, ISearchResults searchResults, [Substitute] SearchController searchController, IRenderingPropertiesRepository renderingPropertiesRepository, [Substitute] PagingSettings pagingSettings) { renderingPropertiesRepository.Get <PagingSettings>().Returns(pagingSettings); service.Search(Arg.Any <IQuery>()).Returns(searchResults); serviceRepository.Get().Returns(service); var controller = new SearchController(serviceRepository, settingsRepository, queryRepository, renderingPropertiesRepository); var result = controller.PagedSearchResults(query, null) as ViewResult; result.Model.Should().BeOfType <PagedSearchResults>(); }
public List <Invoice> GetAll(Filters.InvoiceFilterOptions options = null, PagingSettings paging = null) { var invoices = QueryInvoices(options, paging); return(invoices.ToList()); }
/// <summary> /// Get collection's documents /// </summary> /// <param name="filter">lambda expression filter</param> /// <param name="settings">Istance of PagingSettings</param> /// <param name="projection">defines a projection document to specify or restrict fields to return</param> /// <param name="token">cancellation token async support</param> /// <returns>Return list of documents</returns> public virtual async Task <IEnumerable <T> > Get(Expression <Func <T, bool> > filter, PagingSettings settings, Expression <Func <T, object> > projection, CancellationToken token = default(CancellationToken)) => (IEnumerable <T>) await GetCollection(filter, settings, null, projection, token);
private IQueryable <Invoice> QueryInvoices(Filters.InvoiceFilterOptions options, PagingSettings paging = null) { var invoices = Context.Invoice.Where(i => !i.Deleted.HasValue); if (options != null) { if (options.Order == "desc") { invoices = invoices.OrderByDescending(x => x.CreatedDate); } } if (paging != null) { invoices = invoices.Distinct().OrderByDescending(l => l.CreatedDate).ToPagedQueryable(paging); } return(invoices); }
/// <summary> /// Get collection's documents /// </summary> /// <param name="settings">Istance of PagingSettings</param> /// <param name="sortings">list of sortingField</param> /// <param name="projection">defines a projection document to specify or restrict fields to return</param> /// <param name="token">cancellation token async support</param> /// <returns>Return list of documents</returns> public virtual async Task <IEnumerable <T> > Get(PagingSettings settings, IEnumerable <SortingField> sortings, Expression <Func <T, object> > projection, CancellationToken token = default(CancellationToken)) => (IEnumerable <T>) await GetCollection(null, settings, sortings, projection, token);
public List <InvoiceItem> GetAllItems(InvoiceItemFilterOptions options = null, PagingSettings paging = null) { return(Context.InvoiceItem.Where(q => !q.Deleted.HasValue).ToList()); }