public Raca Alterar(int id, Raca d) { cmd.Connection = conexao.Conectar(); //Colocando os Parametros cmd.CommandText = "UPDATE Raca SET Descricao = @descricao WHERE IdRaca = @id"; cmd.Parameters.AddWithValue("@descricao", d.Descricao); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); //encerrar Conexao conexao.Desconectar(); return(d); }
public TipoDePet Alterar(int id, TipoDePet a) { cmd.Connection = conexao.Conectar(); //Colocando os Parametros cmd.CommandText = "UPDATE TipoDePet SET Descricao = @descricao WHERE IdTipoDePet = @id"; cmd.Parameters.AddWithValue("@descricao", a.Descricao); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); //encerrar Conexao conexao.Desconectar(); return(a); }
public TipoDePet Alterar(TipoDePet e, int id) { cmd.Connection = conexao.Conectar(); cmd.CommandText = "UPDATE TipoDePet " + "SET Descricao = @descricao, " + "WHERE IdTipoDePet = @id"; cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@descricao", e.Descricao); cmd.ExecuteNonQuery(); conexao.Desconectar(); return(e); }
public Raca Alterar(Raca a, int id) { cmd.Connection = conexao.Conectar(); cmd.CommandText = "UPDATE Raca " + "SET Descricao = @descricao, " + "WHERE IdRaca = @id"; cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@descricao", a.Descricao); cmd.ExecuteNonQuery(); conexao.Desconectar(); return(a); }