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();
}
