public async Task <PagedResults <Book> > GetAllBooks(int page, int pageSize, string orderBy, bool ascending) { PagedResults <Book> result = null; var BookQueryResult = from b in db.Books.AsQueryable() join a in db.Authors.AsQueryable() on b.AuthorId equals a.Id into joinedResult from r in joinedResult.DefaultIfEmpty() select new BookMongoDbQueryResult { Id = b.Id, Year = b.Year, Name = b.Name, Description = b.Description, AuthorId = b.AuthorId, AuthorName = r.Name + " " + r.Surname }; PagedResults <BookMongoDbQueryResult> bookPagedResult = await pagination.CreatePagedResultsAsync(BookQueryResult, page, pageSize, orderBy, ascending); if (bookPagedResult != null) { mongoDbDataConvert.InitData(bookPagedResult); result = mongoDbDataConvert.GetFormatedPagedResults(); } return(result); }
public async Task <PagedResults <Book> > GetAllBooks(int page, int pageSize, string orderBy, bool ascending) { PagedResults <Book> result = null; IQueryable <BookPostgreSqlQueryResult> BookQuery = db.Books.Join(db.Authors, b => b.AuthorId, a => a.Id, (b, a) => new BookPostgreSqlQueryResult { Id = b.Id, Year = b.Year, Name = b.Name, Description = b.Description, AuthorId = b.Id.ToString(), AuthorName = a.Name + " " + a.Surname }).AsQueryable(); PagedResults <BookPostgreSqlQueryResult> BookPagedResult = await pagination.CreatePagedResultsAsync(BookQuery, page, pageSize, orderBy, ascending); if (BookPagedResult != null) { PostgreSqlDataConvert.InitData(BookPagedResult); result = PostgreSqlDataConvert.GetFormatedPagedResults(); } return(result); }
public async Task <PagedResults <Author> > GetAllAuthors(int page, int pageSize, string orderBy, bool ascending) { PagedResults <Author> result = null; IQueryable <AuthorPostgreSql> authorsQueryResult = db.Authors.AsQueryable(); PagedResults <AuthorPostgreSql> authorPagedResult = await pagination.CreatePagedResultsAsync(authorsQueryResult, page, pageSize, orderBy, ascending); if (authorPagedResult != null) { PostgreSqlDataConvert.InitData(authorPagedResult); result = PostgreSqlDataConvert.GetFormatedPagedResults(); } return(result); }
public async Task <PagedResults <Author> > GetAllAuthors(int page, int pageSize, string orderBy, bool ascending) { PagedResults <Author> result = null; var builder = Builders <AuthorMongoDb> .Filter; IEnumerable <AuthorMongoDb> CollectionResult = db.Authors.Find(builder.Empty).ToEnumerable(); IQueryable <AuthorMongoDb> authorsQueryResult = CollectionResult.AsQueryable(); PagedResults <AuthorMongoDb> authorPagedResult = await pagination.CreatePagedResultsAsync(authorsQueryResult, page, pageSize, orderBy, ascending); if (authorPagedResult != null) { mongoDbDataConvert.InitData(authorPagedResult); result = mongoDbDataConvert.GetFormatedPagedResults(); } return(result); }