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