public TipoDoPet Adicionar(TipoDoPet t)
{
cmd.Connection = conexao.Conectar();
cmd.CommandText = "INSERT INTO tipoPet " +
"(Descricao)" +
"Values" +
"(@descricao)";
cmd.Parameters.AddWithValue("@descricao", t.Descricao);
cmd.ExecuteNonQuery();
conexao.Desconectar();
return(t);
}
public TipoDoPet Alterar(int id, TipoDoPet t)
{
cmd.Connection = conexao.Conectar();
cmd.CommandText = "UPDATE FROM tipoPet" +
"Descricao = @descricao" +
"WHERE" +
"IdTipoPet = @id";
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@descricao", t.Descricao);
cmd.ExecuteNonQuery();
conexao.Desconectar();
return(t);
}
public TipoDoPet BuscarId(int id)
{
cmd.Connection = conexao.Conectar();
cmd.CommandText = "SELECT * FROM tipoPet WHERE idTipoPet = @id";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader dados = cmd.ExecuteReader();
TipoDoPet t = new TipoDoPet();
while (dados.Read())
{
t.IdTipoPet = Convert.ToInt32(dados.GetValue(0));
t.Descricao = dados.GetValue(1).ToString();
}
conexao.Desconectar();
return(t);
}
public TipoDoPet Put(int id, [FromBody] TipoDoPet t)
{
return(rep.Alterar(id, t));
}
public TipoDoPet Post([FromBody] TipoDoPet t)
{
return(rep.Adicionar(t));
}
