public void alteraExame(Exame exame) { using (OdbcConnection conexao = ConexaoPadrao.createConnection()) { string sql = "update EXAME set ID_ANIMAL = ?, ID_VETERINARIO = ?, ID_LABORATORIO = ?, DATA = ?, EXAME = ? where ID_EXAME = ?"; OdbcCommand command = new OdbcCommand(sql, conexao); command.Parameters.AddWithValue("@ID_ANIMAL", exame.idAnimal); command.Parameters.AddWithValue("@ID_VETERINARIO", exame.idVeterinario); command.Parameters.AddWithValue("@ID_LABORATORIO", exame.idLaboratorio); command.Parameters.AddWithValue("@DATA", exame.data); command.Parameters.AddWithValue("@EXAME", exame.exame); command.Parameters.AddWithValue("@ID_EXAME", exame.id); conexao.Open(); command.ExecuteNonQuery(); } }
public void inserirExame(Exame exame) { using (OdbcConnection conexao = ConexaoPadrao.createConnection()) { string sql = "insert into EXAME (ID_EXAME, ID_ANIMAL, ID_VETERINARIO, ID_LABORATORIO, DATA, EXAME) values(?,?,?,?,?,?)"; OdbcCommand command = new OdbcCommand(sql, conexao); command.Parameters.AddWithValue("@ID_EXAME", exame.id); command.Parameters.AddWithValue("@ID_ANIMAL", exame.idAnimal); command.Parameters.AddWithValue("@ID_VETERINARIO", exame.idVeterinario); command.Parameters.AddWithValue("@ID_LABORATORIO", exame.idLaboratorio); command.Parameters.AddWithValue("@DATA", exame.data); command.Parameters.AddWithValue("@EXAME", exame.exame); conexao.Open(); command.ExecuteNonQuery(); } }