public List <Color> GetAll(Expression <Func <Color, bool> > filter = null)
{
using (TableContext context = new TableContext())
{
return(filter == null?context.Set <Color>().ToList() : context.Set <Color>().Where(filter).ToList());
}
}
public Color Get(Expression <Func <Color, bool> > filter)
{
using (TableContext context = new TableContext())
{
return(context.Set <Color>().SingleOrDefault(filter));
}
}
public Brand Get(Expression <Func <Brand, bool> > filter)
{
using (TableContext context = new TableContext())
{
return(context.Set <Brand>().SingleOrDefault(filter));
}
}
public Product Get(Expression <Func <Product, bool> > filter)
{
using (TableContext context = new TableContext())
{
return(context.Set <Product>().SingleOrDefault(filter));
}
}
public void Update(Color entity)
{
using (TableContext context = new TableContext())
{
var updatedEntity = context.Entry(entity);
updatedEntity.State = EntityState.Modified;
context.SaveChanges();
}
}
public void Delete(Color entity)
{
using (TableContext context = new TableContext())
{
var deletedEntity = context.Entry(entity);
deletedEntity.State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Add(Color entity)
{
using (TableContext context = new TableContext())
{
var addedEntity = context.Entry(entity);
addedEntity.State = EntityState.Added;
context.SaveChanges();
}
}