public static void Create_database(string file_path)
{
SQLiteConnection connection = new SQLiteConnection(string.Format("DataSource={0}", file_path));
connection.Open();
// Create registries table
SQLiteCommand registries_command = new SQLiteCommand(connection)
{
CommandText = "CREATE TABLE IF NOT EXISTS registries (id INTEGER PRIMARY KEY AUTOINCREMENT, date TEXT, category TEXT, type TEXT, amount REAL, description TEXT, currency TEXT);"
};
registries_command.ExecuteNonQuery();
// Create categories table
SQLiteCommand categories_command = new SQLiteCommand(connection)
{
CommandText = "CREATE TABLE IF NOT EXISTS categories (id INTEGER PRIMARY KEY AUTOINCREMENT, category TEXT);"
};
categories_command.ExecuteNonQuery();
// Create categories table
SQLiteCommand currencies_command = new SQLiteCommand(connection)
{
CommandText = "CREATE TABLE IF NOT EXISTS currencies (id INTEGER PRIMARY KEY AUTOINCREMENT, currency TEXT, vs_usd_rate REAL);"
};
currencies_command.ExecuteNonQuery();
connection.Close();
DatabaseHandler.Add_currency(file_path, "USD", 1);
}
private void Add_new_currency(object sender, RoutedEventArgs e)
{
string currency_name = AddCurrencyDialogCurrencyNameBox.Text;
if (DatabaseHandler.Sanitize_string(currency_name))
{
if (DatabaseHandler.Currency_exists(GlobalVariables.temporary_file_path, currency_name) != true)
{
double vs_usd_rate;
try
{
vs_usd_rate = Convert.ToDouble(AddCurrencyDialogCurrencyRateBox.Text);
}
catch
{
return;
}
if (vs_usd_rate > 0)
{
DatabaseHandler.Add_currency(GlobalVariables.temporary_file_path, currency_name, vs_usd_rate);
this.correcly_created = true;
this.Close();
}
else
{
InvalidInputDialog invalid_input_dialog = new InvalidInputDialog();
invalid_input_dialog.Set_msg("The Currency rate can't be negative");
invalid_input_dialog.ShowDialog();
}
}
}
else
{
InvalidInputDialog invalid_input_dialog = new InvalidInputDialog();
invalid_input_dialog.Set_msg("Are you using any ilegal chars ('!@#$%^&*()_+=,./\";:[]{}\\|)?");
invalid_input_dialog.ShowDialog();
}
}
