private void GetViewModelPropertyValues(string accNumber, string examDate, bool testConducted)
{
AirCondUmskData acUmskDataVM = (AirCondUmskData)viewmodel;
accNumberCol.Value = accNumber;
dateOfExamCol.Value = examDate;
isTestConductedCol.Value = testConducted.ToString(CultureInfo.InvariantCulture);
avgSpPerRtEarCol.Value = acUmskDataVM.AvgSpPerRtEar.ToString();
impairRtEarCol.Value = acUmskDataVM.ImpairRtEar.ToString();
avgSpPerLtEarCol.Value = acUmskDataVM.AvgSpPerLtEar.ToString();
impairLtEarCol.Value = acUmskDataVM.ImpairLtEar.ToString();
disabilityCol.Value = acUmskDataVM.Disability.ToString();
}
public override void OpenRecordFromDatabase(string accNumber, string examDate, out bool testConducted)
{
base.OpenRecordFromDatabase(accNumber, examDate, out testConducted);
string query = "SELECT * FROM " + disabilityTable + " WHERE AccNumber = '" + accNumber +
"' AND DateOfExam = '" + examDate + "'";
SQLiteCommand readCmd = new SQLiteCommand(query, DatabaseInfo.SqliteCon);
SQLiteDataReader reader = readCmd.ExecuteReader();
testConducted = false;
if (reader.Read())
{
AirCondUmskData acUmskDataVM = (AirCondUmskData)viewmodel;
testConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
acUmskDataVM.AvgSpPerRtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(avgSpPerRtEarCol.Index));
acUmskDataVM.ImpairRtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(impairRtEarCol.Index));
acUmskDataVM.AvgSpPerLtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(avgSpPerLtEarCol.Index));
acUmskDataVM.ImpairLtEar = NullDoubleHelper.ToNullableDouble(reader.GetString(impairLtEarCol.Index));
acUmskDataVM.Disability = NullDoubleHelper.ToNullableDouble(reader.GetString(disabilityCol.Index));
}
}
public AirCondUmskVM()
{
TabTitle = "AC(U/Msk)";
PureToneData = new AirCondUmskData();
}