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