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));
}
