private void PopulateDatabase(string databasePath)
{
string location = this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name;
_logger.OpenSection(location);
_logger.Info("Opening database connection...");
using (var connection = new SQLiteConnection("Data Source=" + databasePath + ";Version=3;"))
{
connection.Open();
string[] createTableStatements =
{
CREATE_TABLE_QUOTES,
CREATE_TABLE_WORDS,
CREATE_TABLE_SOURCES
};
foreach (var createOneTable in createTableStatements)
{
CreateTable(createOneTable, connection);
}
CreateTable(ALL_DATA_VIEW, connection, "view");
connection.Close();
}
_logger.CloseSection(location);
}
private void btnCreateDictionary_Click(object sender, EventArgs e)
{
string location = this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name;
_logger.OpenSection(location);
var message = _logger.Info("Enter a path in which the dictionary will be created.");
var folderPath = Microsoft.VisualBasic.Interaction.InputBox(
message, "Dictionary path",
Path.GetDirectoryName(Application.ExecutablePath),
this.Location.X + ((this.Size.Width - 370) / 2), this.Location.Y + ((this.Size.Height - 160) / 2));
if (String.IsNullOrEmpty(folderPath))
{
MessageBox.Show(_logger.Info("Cancelled by user."));
_logger.CloseSection(location);
return;
}
_logger.Info("User chose folder '" + folderPath + "'.");
if (!Directory.Exists(folderPath))
{
message = _logger.Info("Please enter the path of an existing folder.");
MessageBox.Show(message, "Folder does not exist",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
_logger.CloseSection(location);
return;
}
message = _logger.Info("Enter a filename for the dictionary.");
var filename = Microsoft.VisualBasic.Interaction.InputBox(
message, "Dictionary filename",
"Dictionary" + DateTime.Now.ToString("yyyyMMdd_hhmmss") + ".sqlite",
this.Location.X + ((this.Size.Width - 370) / 2), this.Location.Y + ((this.Size.Height - 160) / 2));
if (String.IsNullOrEmpty(filename))
{
MessageBox.Show(_logger.Info("Cancelled by user."));
_logger.CloseSection(location);
return;
}
var databaseCreator = GlobalObjects.DatabaseCreator.CreateDatabase(folderPath, filename);
message = "Database created.";
MessageBox.Show(_logger.Info(message));
_logger.CloseSection(location);
}
