public PureToneTabVM()
{
ACMskTabVM = new AirCondMskVM();
ACUmskTabVM = new AirCondUmskVM();
BCMskTabVM = new BoneCondMskVM();
BCUmskTabVM = new BoneCondUmskVM();
ACAidedTabVM = new AirCondAidVM();
LoudnessTabVM = new LoudDiscomLvlVM();
SoundFieldTabVM = new SoundFieldVM();
ptamTabDict = new SortedDictionary <int, PureToneAMTabVM>();
ptamTabDict[ACMskTabIndex] = ACMskTabVM;
ptamTabDict[ACUmskTabIndex] = ACUmskTabVM;
ptamTabDict[BCMskTabIndex] = BCMskTabVM;
ptamTabDict[BCUmskTabIndex] = BCUmskTabVM;
ptamTabDict[ACAidedTabIndex] = ACAidedTabVM;
ptamTabDict[LoudnessTabIndex] = LoudnessTabVM;
ptamTabDict[SoundFieldTabIndex] = SoundFieldTabVM;
PureToneAMTabs = new ObservableCollection <PureToneAMTabVM>(ptamTabDict.Values);
AblbTabVM = new AblbTabVM();
SisiTabVM = new SisiTabVM();
ToneDecayTabVM = new ToneDecayTabVM();
StengerTabVM = new StengerTabVM();
TuningForkVM = new TuningForkTestsVM();
DateOfExam = DateTime.Now;
IsPureToneTestConducted = false;
IsSpecialTestConducted = false;
}
private void GetViewModelPropertyValues(string accNumber, string examDate, bool testConducted)
{
AblbTabVM ablbViewModel = (AblbTabVM)viewmodel;
accNumberCol.Value = accNumber;
dateOfExamCol.Value = examDate;
isTestConductedCol.Value = testConducted.ToString(CultureInfo.InvariantCulture);
re0Col.Value = ablbViewModel.RightEar0.ToString();
re1Col.Value = ablbViewModel.RightEar1.ToString();
re2Col.Value = ablbViewModel.RightEar2.ToString();
re3Col.Value = ablbViewModel.RightEar3.ToString();
re4Col.Value = ablbViewModel.RightEar4.ToString();
re5Col.Value = ablbViewModel.RightEar5.ToString();
re6Col.Value = ablbViewModel.RightEar6.ToString();
re7Col.Value = ablbViewModel.RightEar7.ToString();
re8Col.Value = ablbViewModel.RightEar8.ToString();
re9Col.Value = ablbViewModel.RightEar9.ToString();
le0Col.Value = ablbViewModel.LeftEar0.ToString();
le1Col.Value = ablbViewModel.LeftEar1.ToString();
le2Col.Value = ablbViewModel.LeftEar2.ToString();
le3Col.Value = ablbViewModel.LeftEar3.ToString();
le4Col.Value = ablbViewModel.LeftEar4.ToString();
le5Col.Value = ablbViewModel.LeftEar5.ToString();
le6Col.Value = ablbViewModel.LeftEar6.ToString();
le7Col.Value = ablbViewModel.LeftEar7.ToString();
le8Col.Value = ablbViewModel.LeftEar8.ToString();
le9Col.Value = ablbViewModel.LeftEar9.ToString();
}
public override void InitializeProperties()
{
ACMskTabVM.InitializeProperties();
ACUmskTabVM.InitializeProperties();
BCMskTabVM.InitializeProperties();
BCUmskTabVM.InitializeProperties();
ACAidedTabVM.InitializeProperties();
LoudnessTabVM.InitializeProperties();
SoundFieldTabVM.InitializeProperties();
IsPureToneTestConducted = false;
AblbTabVM.InitializeProperties();
SisiTabVM.InitializeProperties();
ToneDecayTabVM.InitializeProperties();
StengerTabVM.InitializeProperties();
TuningForkVM.InitializeProperties();
IsSpecialTestConducted = false;
}
public override bool DeleteRecordFromDatabase(string accNumber, string examDate)
{
bool acmskDel = ACMskTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool acumskDel = ACUmskTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool bcmskDel = BCMskTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool bcumskDel = BCUmskTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool acaidDel = ACAidedTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool loudDel = LoudnessTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool soundDel = SoundFieldTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool ablbDel = AblbTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool sisiDel = SisiTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool tonedecayDel = ToneDecayTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool stengerDel = StengerTabVM.DeleteRecordFromDatabase(accNumber, examDate);
bool tuningforkDel = TuningForkVM.DeleteRecordFromDatabase(accNumber, examDate);
return(acmskDel || acumskDel || bcmskDel || bcumskDel || acaidDel || loudDel || soundDel ||
ablbDel || sisiDel || tonedecayDel || stengerDel || tuningforkDel);
}
public override void OpenRecordFromDatabase(string accNumber, string examDate)
{
bool ptTestConducted;
bool stTestConducted;
ACMskTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
ACUmskTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
BCMskTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
BCUmskTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
ACAidedTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
LoudnessTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
SoundFieldTabVM.OpenRecordFromDatabase(accNumber, examDate, out ptTestConducted);
IsPureToneTestConducted = ptTestConducted;
AblbTabVM.OpenRecordFromDatabase(accNumber, examDate, out stTestConducted);
SisiTabVM.OpenRecordFromDatabase(accNumber, examDate, out stTestConducted);
ToneDecayTabVM.OpenRecordFromDatabase(accNumber, examDate, out stTestConducted);
StengerTabVM.OpenRecordFromDatabase(accNumber, examDate, out stTestConducted);
TuningForkVM.OpenRecordFromDatabase(accNumber, examDate);
IsSpecialTestConducted = stTestConducted;
}
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())
{
AblbTabVM ablbViewModel = (AblbTabVM)viewmodel;
testConducted = Convert.ToBoolean(reader.GetString(isTestConductedCol.Index));
ablbViewModel.RightEar0 = NullDoubleHelper.ToNullableDouble(reader.GetString(re0Col.Index));
ablbViewModel.RightEar1 = NullDoubleHelper.ToNullableDouble(reader.GetString(re1Col.Index));
ablbViewModel.RightEar2 = NullDoubleHelper.ToNullableDouble(reader.GetString(re2Col.Index));
ablbViewModel.RightEar3 = NullDoubleHelper.ToNullableDouble(reader.GetString(re3Col.Index));
ablbViewModel.RightEar4 = NullDoubleHelper.ToNullableDouble(reader.GetString(re4Col.Index));
ablbViewModel.RightEar5 = NullDoubleHelper.ToNullableDouble(reader.GetString(re5Col.Index));
ablbViewModel.RightEar6 = NullDoubleHelper.ToNullableDouble(reader.GetString(re6Col.Index));
ablbViewModel.RightEar7 = NullDoubleHelper.ToNullableDouble(reader.GetString(re7Col.Index));
ablbViewModel.RightEar8 = NullDoubleHelper.ToNullableDouble(reader.GetString(re8Col.Index));
ablbViewModel.RightEar9 = NullDoubleHelper.ToNullableDouble(reader.GetString(re9Col.Index));
ablbViewModel.LeftEar0 = NullDoubleHelper.ToNullableDouble(reader.GetString(le0Col.Index));
ablbViewModel.LeftEar1 = NullDoubleHelper.ToNullableDouble(reader.GetString(le1Col.Index));
ablbViewModel.LeftEar2 = NullDoubleHelper.ToNullableDouble(reader.GetString(le2Col.Index));
ablbViewModel.LeftEar3 = NullDoubleHelper.ToNullableDouble(reader.GetString(le3Col.Index));
ablbViewModel.LeftEar4 = NullDoubleHelper.ToNullableDouble(reader.GetString(le4Col.Index));
ablbViewModel.LeftEar5 = NullDoubleHelper.ToNullableDouble(reader.GetString(le5Col.Index));
ablbViewModel.LeftEar6 = NullDoubleHelper.ToNullableDouble(reader.GetString(le6Col.Index));
ablbViewModel.LeftEar7 = NullDoubleHelper.ToNullableDouble(reader.GetString(le7Col.Index));
ablbViewModel.LeftEar8 = NullDoubleHelper.ToNullableDouble(reader.GetString(le8Col.Index));
ablbViewModel.LeftEar9 = NullDoubleHelper.ToNullableDouble(reader.GetString(le9Col.Index));
}
}
public override bool UpdateRecordInDatabase(string accNumber, string examDate, out string msg)
{
string error;
bool success = ACMskTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = ACUmskTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = BCMskTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = BCUmskTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = ACAidedTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = LoudnessTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = SoundFieldTabVM.UpdateRecordInDatabase(accNumber, examDate, isPureToneTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = AblbTabVM.UpdateRecordInDatabase(accNumber, examDate, isSpecialTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = SisiTabVM.UpdateRecordInDatabase(accNumber, examDate, isSpecialTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = ToneDecayTabVM.UpdateRecordInDatabase(accNumber, examDate, isSpecialTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = StengerTabVM.UpdateRecordInDatabase(accNumber, examDate, isSpecialTestConducted, out error);
if (!success)
{
msg = error;
return(false);
}
success = TuningForkVM.UpdateRecordInDatabase(accNumber, examDate, out error);
if (!success)
{
msg = error;
return(false);
}
msg = string.Empty;
return(true);
}
