public List <LabRecord> DisplayLabRecordList() { List <LabRecord> labRecordList = new List <LabRecord>(); string query = "SELECT * from LABORATORY"; OracleConnection connection = new OracleConnection(connectionString); connection.Open(); OracleCommand cmd = new OracleCommand(query, connection); OracleDataReader reader = cmd.ExecuteReader(); LabRecord labRecord = new LabRecord(); while (reader.Read()) { int patient_id = Convert.ToInt32(reader[TableColumnMappings.Lab_patient_index]); labRecord.Patient = GetPatientById(patient_id); labRecord.Test_name = reader[TableColumnMappings.Lab_test_name_index].ToString(); labRecord.Test_date = Convert.ToDateTime(reader[TableColumnMappings.Lab_test_date_index]); int doctor_id = Convert.ToInt32(reader[TableColumnMappings.Lab_doctor_index]); labRecord.Doctor = GetStaffById(doctor_id); labRecordList.Add(labRecord); } connection.Close(); return(labRecordList); }
public void AddPatientLabRecord(LabRecord record) { string query = "INSERT INTO laboratory VALUES(:id, :patient_id, :test_name, :test_date, :doctor_referred)"; OracleConnection connection = new OracleConnection(connectionString); connection.Open(); OracleCommand cmd = new OracleCommand(query, connection); cmd.Parameters.Add(new OracleParameter("id", record.Id)); cmd.Parameters.Add(new OracleParameter("patient_id", record.Patient.Id)); cmd.Parameters.Add(new OracleParameter("test_name", record.Test_name)); cmd.Parameters.Add(new OracleParameter("test_date", record.Test_date)); cmd.Parameters.Add(new OracleParameter("doctor_referred", record.Doctor._Stf_ID)); int rows = cmd.ExecuteNonQuery(); Message = Convert.ToString(rows) + " rows added to database"; cmd.Dispose(); conn.Close(); }