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