private void GetViewModelPropertyValues(string accNumber, string examDate, bool testConducted)
{
PureToneData ptdViewModel = (PureToneData)viewmodel;
accNumberCol.Value = accNumber;
dateOfExamCol.Value = examDate;
isTestConductedCol.Value = testConducted.ToString(CultureInfo.InvariantCulture);
re125Col.Value = ptdViewModel.RtEarHLdB125Hz;
re250Col.Value = ptdViewModel.RtEarHLdB250Hz;
re500Col.Value = ptdViewModel.RtEarHLdB500Hz;
re1000Col.Value = ptdViewModel.RtEarHLdB1000Hz;
re2000Col.Value = ptdViewModel.RtEarHLdB2000Hz;
re3000Col.Value = ptdViewModel.RtEarHLdB3000Hz;
re4000Col.Value = ptdViewModel.RtEarHLdB4000Hz;
re6000Col.Value = ptdViewModel.RtEarHLdB6000Hz;
re8000Col.Value = ptdViewModel.RtEarHLdB8000Hz;
le125Col.Value = ptdViewModel.LtEarHLdB125Hz;
le250Col.Value = ptdViewModel.LtEarHLdB250Hz;
le500Col.Value = ptdViewModel.LtEarHLdB500Hz;
le1000Col.Value = ptdViewModel.LtEarHLdB1000Hz;
le2000Col.Value = ptdViewModel.LtEarHLdB2000Hz;
le3000Col.Value = ptdViewModel.LtEarHLdB3000Hz;
le4000Col.Value = ptdViewModel.LtEarHLdB4000Hz;
le6000Col.Value = ptdViewModel.LtEarHLdB6000Hz;
le8000Col.Value = ptdViewModel.LtEarHLdB8000Hz;
}
public override void OpenRecordFromDatabase(string accNumber, string examDate, out bool testConducted)
{
string query = "SELECT * FROM " + dbTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
testConducted = false;
if (reader.Read())
{
PureToneData ptdViewModel = (PureToneData)viewmodel;
testConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
ptdViewModel.RtEarHLdB125Hz = reader.GetString(re125Col.Index);
ptdViewModel.RtEarHLdB250Hz = reader.GetString(re250Col.Index);
ptdViewModel.RtEarHLdB500Hz = reader.GetString(re500Col.Index);
ptdViewModel.RtEarHLdB1000Hz = reader.GetString(re1000Col.Index);
ptdViewModel.RtEarHLdB2000Hz = reader.GetString(re2000Col.Index);
ptdViewModel.RtEarHLdB3000Hz = reader.GetString(re3000Col.Index);
ptdViewModel.RtEarHLdB4000Hz = reader.GetString(re4000Col.Index);
ptdViewModel.RtEarHLdB6000Hz = reader.GetString(re6000Col.Index);
ptdViewModel.RtEarHLdB8000Hz = reader.GetString(re8000Col.Index);
ptdViewModel.LtEarHLdB125Hz = reader.GetString(le125Col.Index);
ptdViewModel.LtEarHLdB250Hz = reader.GetString(le250Col.Index);
ptdViewModel.LtEarHLdB500Hz = reader.GetString(le500Col.Index);
ptdViewModel.LtEarHLdB1000Hz = reader.GetString(le1000Col.Index);
ptdViewModel.LtEarHLdB2000Hz = reader.GetString(le2000Col.Index);
ptdViewModel.LtEarHLdB3000Hz = reader.GetString(le3000Col.Index);
ptdViewModel.LtEarHLdB4000Hz = reader.GetString(le4000Col.Index);
ptdViewModel.LtEarHLdB6000Hz = reader.GetString(le6000Col.Index);
ptdViewModel.LtEarHLdB8000Hz = reader.GetString(le8000Col.Index);
}
}
