private static void CreateDatabaseTables() { string filename = DBAdmin.CreateDBFile(); if (EventLogTableMgr.CreateEventLogDBTable()) { Logger.AddLogEntry(LogCategory.INFO, "Created Database file \'" + filename + "\'."); } SettingsTableMgr.CreateSettingsDBTable(); AudioClipsTableMgr.CreateAudioClipsDBTable(); TimeTriggerClipsTableMgr.CreateTimeTriggerClipsDBTable(); RulesetsTableMgr.CreateRulesetsDBTable(); RulesTableMgr.CreateRulesetRulesDBTable(); SessionsTableMgr.CreateSessionsDBTable(); SessionClipsTableMgr.CreateSessionsDBTable(); OnlineVoicesTableMgr.CreateOnlineVoicesDBTable(); }
private void SaveSettings(string setting) { string msg = String.Empty; switch (setting) { case "CheckAudioFiles": Settings.CheckAudioFiles = CheckAudioFiles; msg = "Check Audio Files option saved."; break; case "CredentialsFile": Settings.CredentialsFile = CredentialsFile; msg = "Google Application Credentials file setting saved."; break; case "MaxLogEntries": Settings.MaxLogEntries = MaxLogEntries; msg = "Maximum log entries option saved."; break; case "OnlineVoice": case "LanguageCode": Settings.LanguageCode = SelectedLanguageCode; Settings.OnlineVoice = SelectedVoice; msg = "Online voice options saved."; break; } if (SettingsTableMgr.SaveSettingsToDB()) { if (!String.IsNullOrEmpty(msg)) { var messageWin = new MessageWin("Save Settings", msg); messageWin.Show(); } Logger.AddLogEntry(LogCategory.INFO, "App options saved."); } else { var messageWin = new MessageWin("Save Settings", "Error: problem saving app options."); messageWin.Show(); Logger.AddLogEntry(LogCategory.ERROR, "SaveSettings: Problem saving app options"); } }
public static bool LoadSettingsFromDB() { bool returnValue = false; DataTable dataTable = SettingsTableMgr.GetSettings(); string[] optionsList = { "CredentialsFile", "CheckAudioFiles", "MaxLogEntries", "LanguageCode", "OnlineVoice" }; if (dataTable != null) { returnValue = true; foreach (var option in optionsList) { if (dataTable.Columns.Contains(option)) { switch (option) { case "CredentialsFile": CredentialsFile = dataTable.Rows[0][option].ToString(); break; case "LanguageCode": LanguageCode = dataTable.Rows[0][option].ToString(); break; case "OnlineVoice": OnlineVoice = dataTable.Rows[0][option].ToString(); break; case "CheckAudioFiles": string intString = dataTable.Rows[0][option].ToString(); if (Int32.TryParse(intString, out int intValue)) { CheckAudioFiles = intValue == 1 ? true : false; } else { returnValue = false; Logger.AddLogEntry(LogCategory.ERROR, String.Format("LoadOptionsFromDB: Could not parse {0}.", option)); } break; case "MaxLogEntries": intString = dataTable.Rows[0][option].ToString(); if (Int32.TryParse(intString, out intValue)) { MaxLogEntries = intValue; } else { returnValue = false; Logger.AddLogEntry(LogCategory.ERROR, String.Format("LoadOptionsFromDB: Could not parse {0}.", option)); } break; default: returnValue = false; Logger.AddLogEntry(LogCategory.ERROR, String.Format("LoadOptionsFromDB: {0} not found.", option)); break; } } } } return(returnValue); }