public void Remover(int id) { Entities.tb_provider provider = db.tb_provider.First(t => t.id_provider == id); db.tb_provider.Remove(provider); db.SaveChanges(); }
public void Alterar(Entities.tb_provider provider) { Entities.tb_provider list = db.tb_provider.FirstOrDefault(l => l.id_provider == provider.id_provider); list.nm_provider = provider.nm_provider; list.nm_name = provider.nm_name; list.ds_typePerson = provider.ds_typePerson; list.nr_identification = provider.nr_identification; list.ds_state = provider.ds_state; list.nr_cep = provider.nr_cep; list.ds_address = provider.ds_address; list.ds_note = provider.ds_note; list.nr_cellphone = provider.nr_cellphone; list.nr_tellphone = provider.nr_tellphone; list.ds_email = provider.ds_email; db.SaveChanges(); }
public List <Entities.tb_provider> ConsultarPorNomeTipoDePessoa(Entities.tb_provider provider) { List <Entities.tb_provider> list = db.tb_provider.Where(l => l.nm_provider == provider.nm_provider && l.ds_typePerson == provider.ds_typePerson).ToList(); return(list); }
public List <Entities.tb_provider> ConsultarPorNome(Entities.tb_provider provider) { List <Entities.tb_provider> list = db.tb_provider.Where(l => l.nm_provider == provider.nm_provider).ToList(); return(list); }
public Entities.tb_provider ConsultaPorID(int id) { Entities.tb_provider provider = db.tb_provider.FirstOrDefault(t => t.id_provider == id); return(provider); }
public void Inserir(Entities.tb_provider provider) { db.tb_provider.Add(provider); db.SaveChanges(); }