public ICollection <TabelaPreco> GetAllTabelaPreco()
{
using (var context = new WebServiceDBContext())
{
return(context.TabelaPrecos.ToList());
}
}
public ICollection <Product> GetAll()
{
using (var context = new WebServiceDBContext())
{
return(context.Produtcs.ToList());
}
}
public ICollection <TypeProduct> GetAllTypeProduct()
{
using (var context = new WebServiceDBContext())
{
return(context.TypeProduct.ToList());
}
}
public void UpdateProduct(Product p)
{
using (var context = new WebServiceDBContext())
{
context.Entry(p).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void AddProduct(Product p)
{
using (var context = new WebServiceDBContext())
{
context.Produtcs.Add(p);
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 Product GetProduct(long id)
{
Product prod = null;
using (var context = new WebServiceDBContext())
{
prod = context.Produtcs.Find(id);
}
return(prod);
}
public TabelaPreco GetTabelaPreco(long id)
{
TabelaPreco tab = null;
using (var context = new WebServiceDBContext())
{
tab = context.TabelaPrecos.Find(id);
}
return(tab);
}
public TypeProduct GetTypeProduct(long id)
{
TypeProduct tproduct = null;
using (var context = new WebServiceDBContext())
{
tproduct = context.TypeProduct.Find(id);
}
return(tproduct);
}
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();
}
}