public IEnumerable <Exame> GetAllExamesByPacienteId(int pacienteId) { List <Exame> exames = new List <Exame>(); using (SqlConnection con = new SqlConnection(connectionString)) { string query = "SELECT * FROM Exame WHERE PacienteId = @id"; SqlCommand cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@id", pacienteId); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Exame exame = new Exame(); exame.Id = Convert.ToInt32(rdr["Id"]); exame.PacienteId = Convert.ToInt32(rdr["PacienteId"]); exame.DataId = Convert.ToInt32(rdr["DataId"]); exames.Add(exame); } con.Close(); } return(exames); }
public void UpdateExame(Exame exame) { using (SqlConnection con = new SqlConnection(connectionString)) { string query = "UPDATE Exame set PacienteId = @PacienteId, DataId = @DataId WHERE Id = @Id"; SqlCommand cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@PacienteId", exame.PacienteId); cmd.Parameters.AddWithValue("@DataId", exame.DataId); cmd.Parameters.AddWithValue("@Id", exame.Id); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } }
public Exame GetExame(int Id) { Exame exame = new Exame(); using (SqlConnection con = new SqlConnection(connectionString)) { string query = "SELECT * FROM Exame WHERE Id = " + Id; SqlCommand cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.Text; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { exame.Id = Convert.ToInt32(rdr["Id"]); exame.PacienteId = Convert.ToInt32(rdr["PacienteId"]); exame.DataId = Convert.ToInt32(rdr["DataId"]); } con.Close(); } return(exame); }