Beispiel #1
0
        public void inserirVacina(Vacina vacina)
        {
            using (OdbcConnection conexao = ConexaoPadrao.createConnection())
            {
                string sql = "insert into VACINA (ID_VACINA, ID_ANIMAL, ID_MEDICAMENTO, DATA) values(?,?,?,?)";
                OdbcCommand command = new OdbcCommand(sql, conexao);

                command.Parameters.AddWithValue("@ID_VACINA", vacina.id);
                command.Parameters.AddWithValue("@ID_ANIMAL", vacina.idAnimal);
                command.Parameters.AddWithValue("@ID_MEDICAMENTO", vacina.idMedicamento);
                command.Parameters.AddWithValue("@DATA", vacina.data);

                conexao.Open();
                command.ExecuteNonQuery();
            }
        }
Beispiel #2
0
        public void alteraVacina(Vacina vacina)
        {
            using (OdbcConnection conexao = ConexaoPadrao.createConnection())
            {
                string sql = "update VACINA set ID_ANIMAL = ?, ID_MEDICAMENTO = ?, DATA = ?, where ID_VACINA = ?";
                OdbcCommand command = new OdbcCommand(sql, conexao);

                command.Parameters.AddWithValue("@ID_ANIMAL", vacina.idAnimal);
                command.Parameters.AddWithValue("@ID_MEDICAMENTO", vacina.idMedicamento);
                command.Parameters.AddWithValue("@DATA", vacina.data);
                command.Parameters.AddWithValue("@ID_VACINA", vacina.id);

                conexao.Open();
                command.ExecuteNonQuery();
            }
        }