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 <IEnumerable <Book> > GetAllBooks()
{
List <BookMsSql> BookList = await db.Books.ToListAsync();
if (BookList != null)
{
MsSqlDataConvert.InitData(BookList);
result = MsSqlDataConvert.GetIEnumerubleDbResult();
}
return(result);
}
public async Task <IEnumerable <Author> > GetAllAuthors()
{
var builder = Builders <AuthorMongoDb> .Filter;
var filters = new List <FilterDefinition <AuthorMongoDb> >();
List <AuthorMongoDb> CollectionResult = await db.Authors.Find(builder.Empty).ToListAsync();
if (CollectionResult != null)
{
mongoDbDataConvert.InitData(CollectionResult);
result = mongoDbDataConvert.GetIEnumerubleDbResult();
}
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);
}
public async Task <IEnumerable <Author> > GetAllAuthors()
{
List <AuthorMsSql> AuthorList = await db.Authors.ToListAsync();
if (AuthorList != null)
{
MsSqlDataConvert.InitData(AuthorList);
result = MsSqlDataConvert.GetIEnumerubleDbResult();
}
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);
}
