public void AddProduct(Product p)
{
using (var context = new WebServiceDBContext())
{
context.Produtcs.Add(p);
context.SaveChanges();
}
}
public void UpdateProduct(Product p)
{
using (var context = new WebServiceDBContext())
{
context.Entry(p).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void UpdateTabelaPreco(TabelaPreco tab)
{
using (var context = new WebServiceDBContext())
{
context.Entry(tab).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void AddTypeProduct(TypeProduct typePro)
{
using (var context = new WebServiceDBContext())
{
context.TypeProduct.Add(typePro);
context.SaveChanges();
}
}
public void RemoveProduct(long id)
{
using (var context = new WebServiceDBContext())
{
Product product = context.Produtcs.Find(id);
context.Entry(product).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void RemoveTabelaPreco(long id)
{
using (var context = new WebServiceDBContext())
{
TabelaPreco tab = context.TabelaPrecos.Find(id);
context.Entry(tab).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void AddTabelaPreco(TabelaPreco tp)
{
using (var context = new WebServiceDBContext())
{
foreach (Product p in tp.producs)
{
context.Produtcs.Attach(p);
context.Entry(p).State = EntityState.Unchanged;
}
context.TabelaPrecos.Add(tp);
context.SaveChanges();
}
}