public TEntity GetById(int id)
{
using (var context = new SGBContext())
{
return(context.Set <TEntity>().Find(id));
}
}
public List <TEntity> ListAll()
{
using (var context = new SGBContext())
{
return(context.Set <TEntity>().ToList());
}
}
public void Delete(TEntity entity)
{
using (var context = new SGBContext())
{
context.Entry(entity).State = EntityState.Deleted;
context.SaveChanges();
}
}
public TEntity Add(TEntity entity)
{
using (var context = new SGBContext())
{
context.Entry(entity).State = EntityState.Added;
context.SaveChanges();
return(entity);
}
}
public TEntity Update(TEntity entity)
{
using (var context = new SGBContext())
{
context.Entry(entity).State = entity.Id == 0 ?
EntityState.Added :
EntityState.Modified;
context.SaveChanges();
return(entity);
}
}
private void ConfigContext(SGBContext context)
{
context.Configuration.ProxyCreationEnabled = false;
context.Configuration.LazyLoadingEnabled = false;
}
