public DapperRepository_Tests()
{
_productDapperRepository = Resolve <IDapperRepository <Product> >();
_productRepository = Resolve <IRepository <Product> >();
_unitOfWorkManager = Resolve <IUnitOfWorkManager>();
_productDetailRepository = Resolve <IRepository <ProductDetail> >();
_productDetailDapperRepository = Resolve <IDapperRepository <ProductDetail> >();
_personRepository = Resolve <IRepository <Person> >();
_personDapperRepository = Resolve <IDapperRepository <Person> >();
_goodDapperRepository = Resolve <IDapperRepository <Good> >();
_dapperQueryFilterExecuter = Resolve <IDapperQueryFilterExecuter>();
}
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));
}
public DapperRepository(IUnitOfWork unitofwork, IDbConnectionProvider dbconnectionProvider, IDapperQueryFilterExecuter dapperQueryFilterExecuter)
{
_unitofwork = unitofwork;
_dbconnectionProvider = dbconnectionProvider;
_dapperQueryFilterExecuter = dapperQueryFilterExecuter;
}
