public int Contar(Expression <Func <T, bool> > where)
{
using (var db = new AplicacionDBContext())
{
return(db.Set <T>().Where(where).Count());
}
}
public T ObtenerPorId(int id)
{
using (var db = new AplicacionDBContext())
{
return(db.Set <T>().FirstOrDefault(x => x.Id == id));
}
}
public void Agregar(T entidad)
{
using (var db = new AplicacionDBContext())
{
db.Entry(entidad).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
}
}
public void Eliminar(int id)
{
using (var db = new AplicacionDBContext())
{
var entidad = new T()
{
Id = id
};
db.Entry(entidad).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public IEnumerable <T> EncontrarPor(ParametrosDeQuery <T> parametrosDeQuery)
{
var orderByClass = ObtenerOrderBy(parametrosDeQuery);
Expression <Func <T, bool> > whereTrue = x => true;
var where = (parametrosDeQuery.Where == null) ? whereTrue : parametrosDeQuery.Where;
using (AplicacionDBContext db = new AplicacionDBContext())
{
if (orderByClass.IsAscending)
{
return(db.Set <T>().Where(where).OrderBy(orderByClass.OrderBy)
.Skip((parametrosDeQuery.Pagina - 1) * parametrosDeQuery.Top)
.Take(parametrosDeQuery.Top).ToList());
}
else
{
return(db.Set <T>().Where(where).OrderByDescending(orderByClass.OrderBy)
.Skip((parametrosDeQuery.Pagina - 1) * parametrosDeQuery.Top)
.Take(parametrosDeQuery.Top).ToList());
}
}
}
public ClienteQueryServicio(AplicacionDBContext context)
{
_context = context;
}
public ProductoQueryServicio(AplicacionDBContext context)
{
_context = context;
}
public ClienteCrearEventHandler(AplicacionDBContext context)
{
_context = context;
}
public UsuarioRepositorio(AplicacionDBContext _db, IMapper _mapper)
{
db = _db;
mapper = _mapper;
}
public TerciarizacionRepositorio(AplicacionDBContext _db, IMapper _mapper)
{
db = _db;
mapper = _mapper;
}
public ProductoEnStockActualizarEventHandler(AplicacionDBContext context,
ILogger <ProductoEnStockActualizarEventHandler> logger)
{
_context = context;
_logger = logger;
}
public ProveedorRepositorio(AplicacionDBContext _db, IMapper _mapper)
{
db = _db;
mapper = _mapper;
}
public ProductoCrearEventHandler(AplicacionDBContext context)
{
_context = context;
}
