public racas Cadastrar(racas a)
{
cmd.Connection = conexao.Conectar();
cmd.CommandText = "INSERT INTO racas (Nome) " +
"VALUES" +
"(@nome)";
cmd.Parameters.AddWithValue("@nome", a.Nome);
cmd.ExecuteNonQuery();
return(a);
}
public racas Alterar(int id, racas a)
{
cmd.Connection = conexao.Conectar();
cmd.CommandText = "UPDATE racas SET " +
"Nome = @nome, " +
"IdTipoPets = @idtipopets WHERE IdRaca = @id";
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@nome", a.Nome);
cmd.Parameters.AddWithValue("@idtipopets", a.IdTipoPets);
cmd.ExecuteNonQuery();
conexao.Desconectar();
return(a);
}
public racas BuscarPorId(int id)
{
cmd.Connection = conexao.Conectar();
cmd.CommandText = "SELECT * FROM racas WHERE IdRaca = @id";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader dados = cmd.ExecuteReader();
racas a = new racas();
while (dados.Read())
{
a.IdRaca = Convert.ToInt32(dados.GetValue(0));
a.Nome = dados.GetValue(1).ToString();
a.IdTipoPets = Convert.ToInt32(dados.GetValue(2));
}
conexao.Desconectar();
return(a);
}
