public async Task <DatabaseManyResult <TEntity> > GetAllWithOrderDescAsync(Expression <Func <TEntity, object> > predicate, int limit = 50, int skip = 0) { var dbResult = new DatabaseManyResult <TEntity>(); try { var dbSet = _applicationDbContext.Set <TEntity>(); var result = await dbSet.OrderByDescending(predicate).Skip(skip).Take(limit).ToListAsync <TEntity>(); if (result == null) { throw new ArgumentNullException("Result object is null."); } dbResult.Success = true; dbResult.Entities = result; return(dbResult); } catch (Exception ex) { dbResult.Exception = ex; dbResult.Message = "Exception GetAllAsync " + typeof(TEntity).Name; return(dbResult); } }
public async Task <DatabaseManyResult <TEntity> > GetAllWithOrderDescAsync(Expression <Func <TEntity, object> > predicate, Expression <Func <TEntity, object> > include, Expression <Func <TEntity, object> > include2 = null, Expression <Func <TEntity, object> > include3 = null, Expression <Func <TEntity, object> > include4 = null, int limit = 50, int skip = 0, bool isAll = false) { var dbResult = new DatabaseManyResult <TEntity>(); try { var dbSet = _applicationDbContext.Set <TEntity>(); var dbQuery = dbSet.AsQueryable(); dbQuery = (include != null) ? dbQuery.Include(include) : dbQuery; dbQuery = (include2 != null) ? dbQuery.Include(include2) : dbQuery; dbQuery = (include3 != null) ? dbQuery.Include(include3) : dbQuery; dbQuery = (include4 != null) ? dbQuery.Include(include4) : dbQuery; var result = dbSet.OrderByDescending(predicate ?? (_ => _.Id)); var resultQuery = !isAll?result.Skip(skip).Take(limit) : result; var resultList = await resultQuery.ToListAsync <TEntity>(); if (result == null) { throw new ArgumentNullException("Result object is null."); } dbResult.Success = true; dbResult.Entities = resultList; return(dbResult); } catch (Exception ex) { dbResult.Exception = ex; dbResult.Message = "Exception GetAllAsync " + typeof(TEntity).Name; return(dbResult); } }
public async Task <DatabaseManyResult <TEntity> > GetAllAsync(Expression <Func <TEntity, object> > include, Expression <Func <TEntity, object> > include2 = null, Expression <Func <TEntity, object> > include3 = null, Expression <Func <TEntity, object> > include4 = null, int limit = 50, int skip = 0) { var dbResult = new DatabaseManyResult <TEntity>(); try { var dbSet = _applicationDbContext.Set <TEntity>(); var dbQuery = dbSet.Include(include); dbQuery = (include2 != null) ? dbQuery.Include(include2) : dbQuery; dbQuery = (include3 != null) ? dbQuery.Include(include3) : dbQuery; dbQuery = (include4 != null) ? dbQuery.Include(include4) : dbQuery; var result = await dbQuery.OrderBy(_ => _.Id).Skip(skip).Take(limit).ToListAsync <TEntity>(); if (result == null) { throw new ArgumentNullException("Result object is null."); } dbResult.Success = true; dbResult.Entities = result; return(dbResult); } catch (Exception ex) { dbResult.Exception = ex; dbResult.Message = "Exception GetAllAsync " + typeof(TEntity).Name; return(dbResult); } }
public async Task <DatabaseManyResult <TEntity> > SqlQueryManyEntitiesAsync(string query) { var dbResult = new DatabaseManyResult <TEntity>(); try { var result = await _applicationDbContext.Database.SqlQuery <TEntity>(query).ToListAsync(); if (result == null) { throw new ArgumentNullException("Result object is null."); } dbResult.Success = true; dbResult.Entities = result; return(dbResult); } catch (Exception ex) { dbResult.Exception = ex; dbResult.Message = "Exception SqlQueryManyEntitiesAsync " + typeof(TEntity).Name; return(dbResult); } }