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