public void Remover(int id) { Entities.tb_product product = db.tb_product.First(t => t.id_product == id); db.tb_product.Remove(product); db.SaveChanges(); }
public void Alterar(Entities.tb_product product) { Entities.tb_product list = db.tb_product.FirstOrDefault(t => t.id_product == product.id_product); list.nm_product = product.nm_product; list.ds_typeProduct = product.ds_typeProduct; list.ds_placeStock = product.ds_placeStock; list.vl_amount = product.vl_amount; list.vl_value = product.vl_value; list.ds_note = product.ds_note; db.SaveChanges(); }
public List <Entities.tb_product> ConsultarPorTipo(Entities.tb_product product) { List <Entities.tb_product> list = db.tb_product.Where(l => l.ds_typeProduct == product.ds_typeProduct).ToList(); return(list); }
public List <Entities.tb_product> ConsultarPorNome(Entities.tb_product product) { List <Entities.tb_product> list = db.tb_product.Where(l => l.nm_product == product.nm_product).ToList(); return(list); }
public Entities.tb_product ConsultaPorID(int id) { Entities.tb_product product = db.tb_product.FirstOrDefault(t => t.id_product == id); return(product); }
public void Inserir(Entities.tb_product product) { db.tb_product.Add(product); db.SaveChanges(); }