public List<Animal> BuscaAnimalByFiltro(string Nome, string Raca) { try { OpenConnection(); Cmd = new SqlCommand("SELECT * FROM Animal WHERE Nome LIKE '%@v1%' OR Raca LIKE '%@v2%'", Con); Cmd.Parameters.AddWithValue("@v1", Nome); Cmd.Parameters.AddWithValue("@v2", Raca); Dr = Cmd.ExecuteReader(); List<Animal> list = new List<Animal>(); while (Dr.Read()) { var Animal = new Animal(); Animal.Nome = Convert.ToString(Dr["Nome"]); Animal.Cor = Convert.ToString(Dr["Cor"]); Animal.Peso = Convert.ToDecimal(Dr["Peso"]); Animal.Raca = Convert.ToString(Dr["Raca"]); Animal.Observacao = Convert.ToString(Dr["Observacao"]); Animal.IdFuncionario = Convert.ToInt32(Dr["IdFuncionario"]); Animal.IdCliente = Convert.ToInt32(Dr["IdCliente"]); list.Add(Animal); } return list; } catch (Exception) { throw; } finally { CloseConnection(); } }
public void EditarAnimal(Animal Animal) { try { OpenConnection(); Cmd = new SqlCommand("UPDATE animal SET nome = @v1, cor = @v2, peso = @v3, observacao = @v4, raca = @v5 WHERE IdAnimal = @v6", Con); Cmd.Parameters.AddWithValue("@v1", Animal.Nome); Cmd.Parameters.AddWithValue("@v2", Animal.Cor); Cmd.Parameters.AddWithValue("@v3", Animal.Peso); Cmd.Parameters.AddWithValue("@v4", Animal.Observacao); Cmd.Parameters.AddWithValue("@v5", Animal.Raca); Cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { CloseConnection(); } }
public List<Animal> ListarAnimalByCliente(int IdCliente) { try { OpenConnection(); Cmd = new SqlCommand("SELECT * FROM ANIMAL WHERE idcliente = @v1", Con); Cmd.Parameters.AddWithValue("@v1", IdCliente); Dr = Cmd.ExecuteReader(); List<Animal> list = new List<Animal>(); while (Dr.Read()) { var Cao = new Animal(); Cao.IdAnimal = Convert.ToInt32(Dr["idanimal"]); Cao.Nome = Convert.ToString(Dr["nome"]); Cao.Raca = Convert.ToString(Dr["raca"]); Cao.Peso = Convert.ToDecimal(Dr["peso"]); Cao.Cor = Convert.ToString(Dr["cor"]); Cao.Observacao = Convert.ToString(Dr["observacao"]); Cao.IdFuncionario = Convert.ToInt32(Dr["idfuncionario"]); list.Add(Cao); } return list; } catch (Exception) { throw; } finally { CloseConnection(); } }
public void InsertAnimal(Animal animal, int IdFuncionario, int IdCliente) { try { OpenConnection(); Cmd = new SqlCommand("INSERT INTO animal(nome, cor, obervacao, idfuncionario, idcliente, peso, raca)" + "VALUES(@v1, @v2, @v3, @v4, @v5, @v6, @v7)", Con); Cmd.Parameters.AddWithValue("@v1", animal.Nome); Cmd.Parameters.AddWithValue("@v2", animal.Cor); Cmd.Parameters.AddWithValue("@v3", animal.Observacao); Cmd.Parameters.AddWithValue("@v4", animal.IdFuncionario); Cmd.Parameters.AddWithValue("@v5", animal.IdCliente); Cmd.Parameters.AddWithValue("@v6", animal.Peso); Cmd.Parameters.AddWithValue("@v7", animal.Raca); Cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { CloseConnection(); } }