public Brand GetById(int id)
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
return(context.Brands.Find(id));
}
}
public Product GetById(int id)
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
return(context.Products.Include("ProductBrand").Single(x => x.Id == id));
}
}
public void Insert(Brand entity)
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
context.Brands.Add(entity);
context.SaveChanges();
}
}
public void Delete(Product entity)
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
context.Products.Attach(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public void Update(Brand entity)
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
context.Brands.Attach(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void Insert(Product entity)
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
Brand productBrand = context.Brands.Find(entity.IdBrand);
entity.ProductBrand = productBrand;
context.Products.Add(entity);
context.SaveChanges();
}
}
public Task <List <Product> > GetAll()
{
return(Task.Run(() =>
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
return context.Products.Include("ProductBrand").ToList();
}
}));
}
public Task <List <Brand> > GetAll()
{
return(Task.Run(() =>
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
return context.Brands.ToList();
}
}));
}
public void Update(Product entity)
{
using (ProductBrandDbContext context = new ProductBrandDbContext())
{
Brand productBrand = context.Brands.Find(entity.IdBrand);
entity.ProductBrand = productBrand;
context.Products.Attach(entity);
context.Entry(entity).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}