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