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(); } }