public IEnumerable <T> GetAllPaged(Expression <Func <T, bool> > predicate, int pageNumber, int itemsPerPage, string sortingProperty, bool ascending = true) { IPredicate filteredPredicate = _dapperQueryFilterExecuter.ExecuteFilter <T>(predicate); IDbConnection connnection = _dbconnectionProvider.GetConnection(); return(connnection.GetPage <T>( filteredPredicate, new List <ISort> { new Sort { Ascending = ascending, PropertyName = sortingProperty } }, pageNumber, itemsPerPage, null)); }
public override IEnumerable <TEntity> GetAllPaged(Expression <Func <TEntity, bool> > predicate, int pageNumber, int itemsPerPage, string sortingProperty, bool ascending = true) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetPage <TEntity>( filteredPredicate, new List <ISort> { new Sort { Ascending = ascending, PropertyName = sortingProperty } }, pageNumber, itemsPerPage, Transaction)); }
public override IEnumerable <TEntity> GetSet(Expression <Func <TEntity, bool> > predicate, int firstResult, int maxResults, string sortingProperty, bool ascending = true) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetSet <TEntity>( filteredPredicate, new List <ISort> { new Sort { Ascending = ascending, PropertyName = sortingProperty } }, firstResult, maxResults, Transaction )); }
public override IEnumerable <TEntity> GetAll() { PredicateGroup predicateGroup = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(); return(Connection.GetList <TEntity>(predicateGroup, transaction: Transaction)); }
public override TEntity FirstOrDefault(Expression <Func <TEntity, bool> > predicate) { IPredicate pg = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetList <TEntity>(pg, transaction: Transaction).FirstOrDefault()); }
public override TEntity Single(Expression <Func <TEntity, bool> > predicate) { IPredicate pg = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetList <TEntity>(pg).Single()); }
public override IEnumerable <TEntity> GetSet(Expression <Func <TEntity, bool> > predicate, int firstResult, int maxResults, bool ascending = true, params Expression <Func <TEntity, object> >[] sortingExpression) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetSet <TEntity>(filteredPredicate, sortingExpression.ToSortable(ascending), firstResult, maxResults, Transaction)); }
public override IEnumerable <TEntity> GetAllPaged(Expression <Func <TEntity, bool> > predicate, int pageNumber, int itemsPerPage, bool ascending = true, params Expression <Func <TEntity, object> >[] sortingExpression) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetPage <TEntity>(filteredPredicate, sortingExpression.ToSortable(ascending), pageNumber, itemsPerPage, Transaction)); }
public override IEnumerable <TEntity> GetAll(Expression <Func <TEntity, bool> > predicate) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.GetList <TEntity>(filteredPredicate, transaction: Transaction)); }
public override int Count(Expression <Func <TEntity, bool> > predicate) { IPredicate filteredPredicate = IDapperQueryFilterExecuter.ExecuteFilter <TEntity, TPrimaryKey>(predicate); return(Connection.Count <TEntity>(filteredPredicate, Transaction)); }