private void clearRecentFilesHistoryToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show("Are you sure?", "Delete Recent Files History", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes) { RecentFilesManager.Clear(); loadRecentFiles(); } }
public PreferencesDialog(RecentFilesManager recentFilesManager) { _recentFilesManager = recentFilesManager; InitializeComponent(); LoadPreferences(); LoadSearchEngines(); radioSystemProxy.Visible = btnEditSystemProxy.Visible = MonoUtilities.GetPlatform() == MonoUtilities.Platform.Windows; }
void loadRecentFiles() { recentFilesToolStripMenuItem.DropDownItems.Clear(); foreach (string file in RecentFilesManager.Read()) { ToolStripMenuItem tsmi = new ToolStripMenuItem(); tsmi.Text = file; tsmi.Click += new EventHandler(tsmi_Click); recentFilesToolStripMenuItem.DropDownItems.Add(tsmi); } recentFilesToolStripMenuItem.DropDownItems.Add(toolStripSeparatorRecentFiles); recentFilesToolStripMenuItem.DropDownItems.Add(clearRecentFilesHistoryToolStripMenuItem); }
public MainForm() { var tablatureDirectory = TabsterEnvironment.CreateEnvironmentDirectoryPath(TabsterEnvironmentDirectory.UserData, "Library"); var databasePath = Path.Combine(TabsterEnvironment.GetEnvironmentDirectoryPath(TabsterEnvironmentDirectory.ApplicatonData), "library.db"); var fileProcessor = new TabsterFileProcessor <TablatureFile>(Constants.TablatureFileVersion); Logging.GetLogger().Info(string.Format("Initializing database: {0}", databasePath)); _databaseHelper = new TabsterDatabaseHelper(databasePath); _libraryManager = new LibraryManager(_databaseHelper, fileProcessor, tablatureDirectory); _playlistManager = new PlaylistManager(_databaseHelper, fileProcessor); _recentFilesManager = new RecentFilesManager(_databaseHelper, fileProcessor, Settings.Default.MaxRecentItems); InitializeComponent(); Text = string.Format("{0} v{1}", Application.ProductName, TabsterEnvironment.GetVersion().ToString(TabsterVersionFormatFlags.BuildString | TabsterVersionFormatFlags.Truncated)); #if PORTABLE Text = Text.Replace("Build", "Portable Build"); #endif InitAspectGetters(); UpdateSortColumnMenu(true); //tabviewermanager events TablatureViewForm.GetInstance(this).TabClosed += TabHandler_OnTabClosed; recentlyViewedMenuItem.MaxDisplayItems = Settings.Default.MaxRecentItems; recentlyViewedMenuItem.ClearItemClicked += recentlyViewedMenuItem_OnClearItemClicked; previewToolStrip.Renderer = new ToolStripRenderer(); if (Settings.Default.ClientState == FormWindowState.Maximized) { WindowState = FormWindowState.Maximized; } else { Size = Settings.Default.ClientSize; } ToggleEmptyLibraryOverlay(listViewLibrary, true); ToggleEmptyLibraryOverlay(listViewSearch, true); PreviewEditor.Font = TablatureFontManager.GetFont(); searchPreviewEditor.Font = TablatureFontManager.GetFont(); }
private void OnDialogOk(object sender, EventArgs eventArgs) { if (m_clearHistory) { RecentFilesManager.ClearHistory(); } LanguageManager.Language = Language.FromName(m_languageComboBox.SelectedItem.ToString()); if (m_rdbSpecificTool.Checked) { Properties.Settings.Default.ImageEditingTool = m_txtEditingToolPath.Text; } else { Properties.Settings.Default.ImageEditingTool = ""; } Properties.Settings.Default.Save(); }
public void ReadFile(string fileName) { XmlNode node; string src, tgt, val; StringBuilder sbLoadingErrors = new StringBuilder(); if (!File.Exists(fileName)) { MessageBox.Show("File does not exists!"); return; } if (!thePageNavigator1.GotoBeginning()) { return; } GlobalVariables.LoadedColumnMappings.Clear(); GlobalVariables.LoadedUserColumnsDefinitions.Clear(); src = tgt = val = string.Empty; //trfType = ETransformationType.SKIP; pageSourceConnection.rtbSrcConnStr.Text = string.Empty; pageSourceConnection.cbxSrcTableOrViewName.Text = string.Empty; pageTargetConnection.rtbTgtConnStr.Text = string.Empty; pageTargetConnection.cbxTgtTableOrViewName.Text = string.Empty; try { XmlDocument doc = new XmlDocument(); doc.Load(fileName); // Source Connection node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/SourceConnection/ConnectionString"); if (node == null) { node = doc.DocumentElement.SelectSingleNode("/MERGER/SourceConnection/ConnectionString"); } if (node != null) { pageSourceConnection.rtbSrcConnStr.Text = node.InnerText; } else { sbLoadingErrors.AppendLine("Cannot read Source ConnectionString"); } node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/SourceConnection/IsTableOrView"); if (node == null) { node = doc.DocumentElement.SelectSingleNode("/MERGER/SourceConnection/IsTableOrView"); } if (node != null) { pageSourceConnection.rbIsTableOrView.Checked = (node.InnerText == "True"); pageSourceConnection.rbIsCommandText.Checked = (node.InnerText != "True"); } else { sbLoadingErrors.AppendLine("Cannot read IsTableOrView"); } if (pageSourceConnection.rbIsTableOrView.Checked) { GlobalVariables.SourceConnection = DbHelper.CreateConnection(pageSourceConnection.rtbSrcConnStr.Text); pageSourceConnection.cbxSrcTableOrViewName.AddItems(DbHelper.GetTablesViewsAndSynonyms(GlobalVariables.SourceConnection)); } node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/SourceConnection/TableOrViewName"); if (node == null) { node = doc.DocumentElement.SelectSingleNode("/MERGER/SourceConnection/TableOrView"); } if (node != null) { pageSourceConnection.cbxSrcTableOrViewName.Text = node.InnerText; } else { sbLoadingErrors.AppendLine("Cannot read Source TableOrViewName"); } node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/SourceConnection/CommandText"); if (node == null) { node = doc.DocumentElement.SelectSingleNode("/MERGER/SourceConnection/CommandText"); } if (node != null) { pageSourceConnection.rtbCommandText.Text = node.InnerText.Replace("<![CDATA[", "").Replace("]]>", ""); } else { sbLoadingErrors.AppendLine("Cannot read CommandText"); } // Target Connection node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/TargetConnection/ConnectionString"); if (node == null) { node = doc.DocumentElement.SelectSingleNode("/MERGER/TargetConnection/ConnectionString"); } if (node != null) { pageTargetConnection.rtbTgtConnStr.Text = node.InnerText; } else { sbLoadingErrors.AppendLine("Cannot read Target ConnectionString"); } GlobalVariables.TargetConnection = DbHelper.CreateConnection(pageTargetConnection.rtbTgtConnStr.Text); pageTargetConnection.cbxTgtTableOrViewName.AddItems(DbHelper.GetTablesViewsAndSynonyms(GlobalVariables.TargetConnection)); node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/TargetConnection/TableOrViewName"); if (node == null) { node = doc.DocumentElement.SelectSingleNode("/MERGER/TargetConnection/TableOrView"); } if (node != null) { pageTargetConnection.cbxTgtTableOrViewName.Text = node.InnerText; } else { sbLoadingErrors.AppendLine("Cannot read TableOrViewName"); } // User Variables foreach (XmlNode n in doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/UserVariables").ChildNodes) { MyUserVariable uv = new MyUserVariable(); node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/UserVariables/{0}/Name", n.Name)); uv.Name = node.InnerText; node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/UserVariables/{0}/DataType", n.Name)); uv.DataType = node.InnerText; node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/UserVariables/{0}/Value", n.Name)); uv.Definition = node.InnerText; GlobalVariables.LoadedUserColumnsDefinitions.Add(uv); } // Options node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/Options/RecordsOnTargetNotFoundOnSourceMode"); if (node != null) { GlobalVariables.Options.RecordsOnTargetNotFoundOnSourceMode = (ERecordsOnTargetNotFoundOnSourceMode)Enum.Parse(typeof(ERecordsOnTargetNotFoundOnSourceMode), node.InnerText); } else { node = doc.DocumentElement.SelectSingleNode("/MERGER/Options/RecordsOnTargetNotFoundOnSourceEx"); if (node != null) { if (node.InnerText.Equals("UpdateDateTo")) { GlobalVariables.Options.RecordsOnTargetNotFoundOnSourceMode = ERecordsOnTargetNotFoundOnSourceMode.UpdateTargetField; } else if (node.InnerText.Equals("PhysicallyDelete")) { GlobalVariables.Options.RecordsOnTargetNotFoundOnSourceMode = ERecordsOnTargetNotFoundOnSourceMode.PhysicallyDelete; } else if (node.InnerText.Equals("DoNothing")) { GlobalVariables.Options.RecordsOnTargetNotFoundOnSourceMode = ERecordsOnTargetNotFoundOnSourceMode.DoNothing; } } else { sbLoadingErrors.AppendLine("Cannot read RecordsOnTargetNotFoundOnSourceMode"); } } node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/Options/IgnoreDatabasePrefix"); if (node == null) { node = doc.DocumentElement.SelectSingleNode("/MERGER/Options/IgnoreDatabasePrefix"); } if (node != null) { GlobalVariables.Options.IgnoreDatabasePrefix = (node.InnerText == "True"); } else { sbLoadingErrors.AppendLine("Cannot read IgnoreDatabasePrefix"); } node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/Options/ShowExtendedComments"); if (node == null) { node = doc.DocumentElement.SelectSingleNode("/MERGER/Options/ShowExtendedComments"); } if (node != null) { GlobalVariables.Options.ShowExtendedComments = (node.InnerText == "True"); } else { sbLoadingErrors.AppendLine("Cannot read ShowExtendedComments"); } node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/Options/SCD2VersionNumberMode"); if (node != null) { GlobalVariables.Options.SCD2VersionNumberMode = (ESCD2VersionNumberMode)Enum.Parse(typeof(ESCD2VersionNumberMode), node.InnerText); } else { sbLoadingErrors.AppendLine("Cannot read VersionNumberResetOnSCD2"); } node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/Options/SCD13UpdateMode"); if (node != null) { GlobalVariables.Options.SCD13UpdateMode = (ESCD13UpdateMode)Enum.Parse(typeof(ESCD13UpdateMode), node.InnerText); } else { sbLoadingErrors.AppendLine("Cannot read SCD13UpdateMode"); } node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/Options/ComparisonMethod"); if (node != null) { GlobalVariables.Options.ComparisonMethod = (EComparisonMethod)Enum.Parse(typeof(EComparisonMethod), node.InnerText); } else { sbLoadingErrors.AppendLine("Cannot read ComparisonMethod"); } // Column Mappings node = doc.DocumentElement.SelectSingleNode("/ScdMergeWizard/ColumnMappings"); if (node != null) { foreach (XmlNode n in node.ChildNodes) { node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/SourceColumn", n.Name)); var srcc = node.InnerText; node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/TransformationType", n.Name)); var trfc = (ETransformationCode)Enum.Parse(typeof(ETransformationCode), node.InnerText); ETargetDatabaseType tgtdbt; node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/TargetDatabaseType", n.Name)); if (node != null) { tgtdbt = (ETargetDatabaseType)Enum.Parse(typeof(ETargetDatabaseType), node.InnerText); } else { tgtdbt = ETargetDatabaseType.TARGET; } node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/TargetColumn", n.Name)); var tgtc = node.InnerText; string val1c = string.Empty, val2c = string.Empty, cins = string.Empty, cupd = string.Empty, cdel = string.Empty; // Old version node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/Value1Column", n.Name)); if (node != null) { val1c = node.InnerText; } node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/Value2Column", n.Name)); if (node != null) { val2c = node.InnerText; } // New version node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/CustomInsertValue", n.Name)); if (node != null) { cins = node.InnerText; } node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/CustomUpdateValue", n.Name)); if (node != null) { cupd = node.InnerText; } node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/CustomDeleteValue", n.Name)); if (node != null) { cdel = node.InnerText; } EColumnCompareMethod ccm; node = doc.DocumentElement.SelectSingleNode(string.Format("/ScdMergeWizard/ColumnMappings/{0}/ColumnCompareMethod", n.Name)); if (node != null) { ccm = (EColumnCompareMethod)Enum.Parse(typeof(EColumnCompareMethod), node.InnerText); } else { ccm = EColumnCompareMethod.Default; } if (string.IsNullOrEmpty(cins) && !string.IsNullOrEmpty(val1c) && (trfc == ETransformationCode.SCD2_IS_ACTIVE || trfc == ETransformationCode.SCD3_PREVIOUS_VALUE || trfc == ETransformationCode.CREATED_DATE)) { cins = val1c; } if (string.IsNullOrEmpty(cupd) && !string.IsNullOrEmpty(val1c) && (trfc == ETransformationCode.SCD2_DATE_FROM || trfc == ETransformationCode.SCD2_DATE_TO || trfc == ETransformationCode.SCD3_DATE_FROM || trfc == ETransformationCode.MODIFIED_DATE)) { cupd = val1c; } if (string.IsNullOrEmpty(cdel) && !string.IsNullOrEmpty(val1c) && (trfc == ETransformationCode.DELETED_DATE || trfc == ETransformationCode.IS_DELETED)) { cdel = val1c; } if (string.IsNullOrEmpty(cins) && !string.IsNullOrEmpty(val2c) && (trfc == ETransformationCode.SCD2_DATE_FROM || trfc == ETransformationCode.SCD2_DATE_TO || trfc == ETransformationCode.SCD3_DATE_FROM || trfc == ETransformationCode.MODIFIED_DATE || trfc == ETransformationCode.DELETED_DATE || trfc == ETransformationCode.IS_DELETED)) { cins = val2c; } if (string.IsNullOrEmpty(cupd) && !string.IsNullOrEmpty(val2c) && (trfc == ETransformationCode.SCD2_IS_ACTIVE)) { cupd = val2c; } GlobalVariables.LoadedColumnMappings.Add(new ColumnMapping(srcc, tgtdbt, tgtc, trfc, cins, cupd, cdel, ccm)); } } else { node = doc.DocumentElement.SelectSingleNode("/MERGER/Mappings"); if (node != null) { foreach (XmlNode n in node.ChildNodes) { node = doc.DocumentElement.SelectSingleNode(string.Format("/MERGER/Mappings/{0}/Source", n.Name)); var srcc = node.InnerText; node = doc.DocumentElement.SelectSingleNode(string.Format("/MERGER/Mappings/{0}/Transformation", n.Name)); ETransformationCode tt = ETransformationCode.SKIP; try { tt = (ETransformationCode)Enum.Parse(typeof(ETransformationCode), node.InnerText); } catch { } var trfc = tt; node = doc.DocumentElement.SelectSingleNode(string.Format("/MERGER/Mappings/{0}/Target", n.Name)); var tgtc = node.InnerText; GlobalVariables.LoadedColumnMappings.Add(new ColumnMapping(srcc, ETargetDatabaseType.TARGET, tgtc, trfc, string.Empty, string.Empty, string.Empty, EColumnCompareMethod.Default)); } } else { sbLoadingErrors.AppendLine("Cannot load ColumnMappings"); } } RecentFilesManager.Add(fileName); loadRecentFiles(); GlobalVariables.IsProjectModified = false; } catch (Exception ex) { MyExceptionHandler.NewEx(ex); } FileName = fileName; }
private void save(bool isSaveAs) { if (string.IsNullOrEmpty(FileName) || isSaveAs) { SaveFileDialog sfd = new SaveFileDialog(); sfd.DefaultExt = "mwpxml"; sfd.Filter = "SCD Merge Wizard Project Files|*.mwpxml"; sfd.RestoreDirectory = true; sfd.Title = "Save Project"; if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK) { FileName = sfd.FileName; } else { return; } if (string.IsNullOrEmpty(FileName)) { return; } } using (XmlWriter writer = XmlWriter.Create(FileName)) { writer.WriteStartElement("ScdMergeWizard"); writer.WriteStartElement("SourceConnection"); writer.WriteElementString("ConnectionString", pageSourceConnection.rtbSrcConnStr.Text); writer.WriteElementString("IsTableOrView", pageSourceConnection.rbIsTableOrView.Checked.ToString()); writer.WriteElementString("TableOrViewName", pageSourceConnection.cbxSrcTableOrViewName.Text); writer.WriteElementString("CommandText", "<![CDATA[" + pageSourceConnection.rtbCommandText.Text + "]]>"); writer.WriteEndElement(); writer.WriteStartElement("TargetConnection"); writer.WriteElementString("ConnectionString", pageTargetConnection.rtbTgtConnStr.Text); writer.WriteElementString("TableOrViewName", pageTargetConnection.cbxTgtTableOrViewName.Text); writer.WriteEndElement(); writer.WriteStartElement("UserVariables"); for (int i = 0; i < GlobalVariables.UserColumnsDefinitions.Count; i++) { MyUserVariable uv = GlobalVariables.UserColumnsDefinitions[i]; writer.WriteStartElement("UserVariable_" + i.ToString()); writer.WriteElementString("Name", uv.Name); writer.WriteElementString("DataType", uv.DataType); writer.WriteElementString("Value", "<![CDATA[" + uv.Definition + "]]>"); writer.WriteEndElement(); } writer.WriteEndElement(); writer.WriteStartElement("Options"); writer.WriteElementString("RecordsOnTargetNotFoundOnSourceMode", GlobalVariables.Options.RecordsOnTargetNotFoundOnSourceMode.ToString()); writer.WriteElementString("IgnoreDatabasePrefix", GlobalVariables.Options.IgnoreDatabasePrefix.ToString()); writer.WriteElementString("ShowExtendedComments", GlobalVariables.Options.ShowExtendedComments.ToString()); writer.WriteElementString("SCD2VersionNumberMode", GlobalVariables.Options.SCD2VersionNumberMode.ToString()); writer.WriteElementString("SCD13UpdateMode", GlobalVariables.Options.SCD13UpdateMode.ToString()); writer.WriteElementString("ComparisonMethod", GlobalVariables.Options.ComparisonMethod.ToString()); writer.WriteEndElement(); writer.WriteStartElement("ColumnMappings"); for (int i = 0; i < GlobalVariables.ColumnMappings.Count; i++) { ColumnMapping cm = GlobalVariables.ColumnMappings[i]; writer.WriteStartElement("ColumnMapping_" + i.ToString()); writer.WriteElementString("SourceColumn", cm.SourceColumn); writer.WriteElementString("TransformationType", cm.TransformationCode.ToString()); writer.WriteElementString("TargetDatabaseType", cm.TargetDatabaseType.ToString()); writer.WriteElementString("TargetColumn", cm.TargetColumn); //writer.WriteElementString("Value1Column", cm.Value1Column); //writer.WriteElementString("Value2Column", cm.Value2Column); writer.WriteElementString("CustomInsertValue", cm.CustomInsertValue); writer.WriteElementString("CustomUpdateValue", cm.CustomUpdateValue); writer.WriteElementString("CustomDeleteValue", cm.CustomDeleteValue); writer.WriteElementString("ColumnCompareMethod", cm.ColumnCompareMethod.ToString()); writer.WriteEndElement(); } writer.WriteEndElement(); // Mappings writer.WriteEndElement(); // MERGER } RecentFilesManager.Add(FileName); GlobalVariables.IsProjectModified = false; }
public PreferencesDialog(RecentFilesManager recentFilesManager, PreferencesSection section) : this(recentFilesManager) { tabControl1.SelectedIndex = (int)section; }