public int Count(Expression <Func <T, bool> > filter = null)
{
using (TheBestShopContext _context = new TheBestShopContext())
{
return(filter == null?_context.Set <T>().Count() : _context.Set <T>().Where(filter).Count());
}
}
public List <T> GetAll(Expression <Func <T, bool> > filter = null)
{
using (TheBestShopContext _context = new TheBestShopContext())
{
return(filter == null?_context.Set <T>().ToList() : _context.Set <T>().Where(filter).ToList());
}
}
public List <T> Pagination(Expression <Func <T, bool> > filter = null, Func <IQueryable <T>, IOrderedQueryable <T> > orderby = null, int pageNumber = 1, int pageSize = 10)
{
using (TheBestShopContext _context = new TheBestShopContext())
{
return(filter == null ?
orderby == null?
_context.Set <T>().Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() :
orderby(_context.Set <T>()).Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() :
orderby == null?
_context.Set <T>().Where(filter).Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList() :
orderby(_context.Set <T>()).Where(filter).Skip((pageNumber - 1) * pageSize).Take(pageSize).ToList());
}
}
public List <T> SqlRaw(string sqlCode)
{
using (TheBestShopContext _context = new TheBestShopContext())
{
return(_context.Set <T>().FromSqlRaw(sqlCode).ToList());
}
}
public T FindById(int id)
{
using (TheBestShopContext _context = new TheBestShopContext())
{
return(_context.Set <T>().Find(id));
}
}
public virtual T GetOne(Expression <Func <T, bool> > filter)
{
using (TheBestShopContext _context = new TheBestShopContext())
{
return(_context.Set <T>().FirstOrDefault(filter));
}
}
public IQueryable <T> Where(Expression <Func <T, bool> > filter = null, Func <IQueryable <T>, IOrderedQueryable <T> > orderby = null)
{
return(orderby == null?_contextt.Set <T>().Where(filter) : orderby(_contextt.Set <T>()));
}