/// <summary>
/// Creates an empty database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CreateEmptyDBClick(object sender, RoutedEventArgs e)
{
try
{
if (DBTypeComboBox.SelectedIndex < 0) throw new ArgumentNullException("Please select a database type.");
DbCreationHelper = new DatabaseCreationHelperFromMXML(_dbType, null);
String result = DbCreationHelper.CreateEmptyDwh();
Clipboard.SetText(result);
ModernDialog.ShowMessage("The SQL-Statement was copied to the clipboard.", "Info", MessageBoxButton.OK);
}
catch (Exception ex)
{
ModernDialog.ShowMessage(ex.Message, "Error: ", MessageBoxButton.OK);
}
}
/// <summary>
/// Creates the insert statements
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CreateInsertStatementClick(object sender, RoutedEventArgs e)
{
try
{
if (_dbType == null) throw new ArgumentNullException("Please select a database type.");
if (SourceFile.Text.Equals("")) throw new ArgumentNullException("Please select a source file.");
string filetype = Path.GetExtension(SourceFile.Text);
String result = "";
if (filetype.Equals(".mxml"))
{
DbCreationHelper = new DatabaseCreationHelperFromMXML(_dbType, SourceFile.Text);
result = DbCreationHelper.CreateInsertSqlStatement();
}
Clipboard.SetText(result);
ModernDialog.ShowMessage("The SQL-Statement was copied to the clipboard.", "Info", MessageBoxButton.OK);
}
catch (Exception ex)
{
ModernDialog.ShowMessage(ex.Message, "Error: ", MessageBoxButton.OK);
}
}