private void SerializePackageAsXML(string PackageName, string LogFileName, string Description, string packGUID, string verGUID) { Cursor.Current = Cursors.WaitCursor; try { DTSPackage2 oPackage = new DTSPackage2(PackageName, LogFileName, Description); // set the DTS package authentication type if (_UID != null && _PWD != null) { oPackage.Authentication = DTSPackage2.authTypeFlags.Default; } else { oPackage.Authentication = DTSPackage2.authTypeFlags.Trusted; } string SQLserver = this.TabText; // load the package from SQL server into the persisted object oPackage.Load(SQLserver, _UID, _PWD, null, packGUID, verGUID); m_DialogTitle = "Save DTS XML Package File as..."; m_DialogTypeFilter = "XML files (*.xml)|*.xml|All files (*.*)|*.*"; ArrayList arl = ShowSaveFileDialog(PackageName, m_DialogTitle, m_DialogTypeFilter); DialogResult dr = (DialogResult)arl[0]; if (dr == DialogResult.OK) { // save package from persisted object onto the HD as a file FileName = (string)arl[1]; // TODO: may want to do this async for bigger DTS packages oPackage.Save(FileName); // show xml XMLDoc xmlDoc = new XMLDoc(); xmlDoc.RightToLeftLayout = RightToLeftLayout; FileInfo fi = new FileInfo(FileName); xmlDoc.TabText = fi.Name; xmlDoc.Text = fi.Name; xmlDoc.ToolTipText = fi.Name; xmlDoc.FileName = FileName; xmlDoc.Show(this.DockPanel); } } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show("XML Serializer Error is: " + ex.Message, "SERIALIZER ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; } }
private void SerializePackageAsXML(string PackageName, string LogFileName, string Description, string packGUID, string verGUID) { Cursor.Current = Cursors.WaitCursor; try { DTSPackage2 oPackage = new DTSPackage2(PackageName, LogFileName, Description); // set the DTS package authentication type if (_UID != null && _PWD != null) { oPackage.Authentication = DTSPackage2.authTypeFlags.Default; } else { oPackage.Authentication = DTSPackage2.authTypeFlags.Trusted; } string SQLserver = this.TabText; // load the package from SQL server into the persisted object oPackage.Load(SQLserver, _UID, _PWD, null, packGUID, verGUID); m_DialogTitle = "Save DTS XML Package File as..."; m_DialogTypeFilter = "XML files (*.xml)|*.xml|All files (*.*)|*.*"; ArrayList arl = ShowSaveFileDialog(PackageName, m_DialogTitle, m_DialogTypeFilter); DialogResult dr = (DialogResult)arl[0]; if (dr == DialogResult.OK) { // save package from persisted object onto the HD as a file FileName = (string)arl[1]; // TODO: may want to do this async for bigger DTS packages oPackage.Save(FileName); // show xml XMLDoc xmlDoc = new XMLDoc(); xmlDoc.RightToLeftLayout = RightToLeftLayout; FileInfo fi = new FileInfo(FileName); xmlDoc.TabText = fi.Name; xmlDoc.Text = fi.Name; xmlDoc.ToolTipText = fi.Name; xmlDoc.FileName = FileName; xmlDoc.Show(this.DockPanel); } } catch(Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show("XML Serializer Error is: " + ex.Message, "SERIALIZER ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; } }
private void xMLFileToolStripMenuItem1_Click(object sender, EventArgs e) { // open xml document XMLDoc xDoc = new XMLDoc(); xDoc.InitialDirectory = LastDirectory; if (xDoc.Open(dockPanel)) { LastDirectory = xDoc.InitialDirectory; } }
private IDockContent GetContentFromPersistString(string persistString) { bool reOpenLast = false; object obj = OptionValues.GetValue("ReOpenLast", optionsSettings); if (obj != null) { CheckState checkSave = (CheckState)obj; if (checkSave == CheckState.Checked) { reOpenLast = true; } } if (persistString == typeof(SQLServerExplorer).ToString()) return m_serverExplorer; else if (persistString == typeof(XmlNodeExplorer).ToString()) return m_xmlNodeExplorer; else { string[] parsedStrings = persistString.Split(new char[] { ',' }); if (parsedStrings.Length < 3) return null; if (parsedStrings[0] == typeof(XMLDoc).ToString() && reOpenLast) { XMLDoc xmlDoc = new XMLDoc(); if (parsedStrings[1] != string.Empty) { xmlDoc.FileName = parsedStrings[1]; LastDirectory = xmlDoc.InitialDirectory; } if (parsedStrings[2] != string.Empty) xmlDoc.Text = parsedStrings[2]; return xmlDoc; } else if (parsedStrings[0] == typeof(SQLDoc).ToString() && reOpenLast) { SQLDoc sqlDoc = new SQLDoc(); if (parsedStrings[1] != string.Empty) { sqlDoc.FileName = parsedStrings[1]; LastDirectory = sqlDoc.InitialDirectory; } if (parsedStrings[2] != string.Empty) sqlDoc.Text = parsedStrings[2]; return sqlDoc; } else { return null; } } }
private bool SQLTransformation(XMLDoc xmlDoc) { bool retval = false; if (xmlDoc == null) { xmlDoc = new XMLDoc(); xmlDoc.InitialDirectory = LastDirectory; if (!xmlDoc.Open(dockPanel)) { xmlDoc.Close(); xmlDoc.Dispose(); this.toolStripStatusLabel1.Text = ""; } else { LastDirectory = xmlDoc.InitialDirectory; } } if (xmlDoc.IsDatabaseSchema) { string m_DialogTitle = "Save SQL File As..."; string m_DialogTypeFilter = "SQL files (*.sql)|*.sql|All files (*.*)|*.*"; string m_fileName = xmlDoc.FileName.ToLower().Replace("xml", "sql"); ArrayList arl = xmlDoc.ShowSaveFileDialog(m_fileName, m_DialogTitle, m_DialogTypeFilter); LastDirectory = xmlDoc.InitialDirectory; DialogResult dr = (DialogResult)arl[0]; if (dr == DialogResult.OK) { m_fileName = (string)arl[1]; AsyncTransformSQL trans = null; if (xmlDoc.IsDatabaseDiff) { trans = new AsyncTransformSQL(this, xmlDoc.FileName, m_fileName, AsyncTransformSQL.TransformType.Diff); trans.CompleteTransformSQL += new AsyncTransformSQL.CompleteTransformDelegate(trans_CompleteTransformSQL); } else { trans = new AsyncTransformSQL(this, xmlDoc.FileName, m_fileName, AsyncTransformSQL.TransformType.Create); trans.CompleteTransformSQL += new AsyncTransformSQL.CompleteTransformDelegate(trans_CompleteTransformSQL); } string work = "Processing XML Snapshot: " + xmlDoc.FileName + "..."; this.toolStripStatusLabel2.Text = string.Empty; this.toolStripStatusLabel1.Text = work; trans.Start(); retval = true; } else { this.toolStripStatusLabel1.Text = ""; } } return retval; }
private void xMLFileToolStripMenuItem_Click(object sender, EventArgs e) { // rehydrate DTS package from DTS XML file bool openNewFlag = true; if (dockPanel.ActiveDocument != null && typeof(XMLDoc).IsInstanceOfType(dockPanel.ActiveDocument.DockHandler.Form)) { XMLDoc xmlDoc = (XMLDoc)dockPanel.ActiveDocument.DockHandler.Form; if (xmlDoc.IsDTSPackage) { this.toolStripStatusLabel1.Text = "Generating DTS Package From: " + xmlDoc.TabText; xmlDoc.ReHydrateDTS(m_serverExplorer.Servers); openNewFlag = false; } else { openNewFlag = true; } } if (openNewFlag) // open new window { XMLDoc xmlDoc = new XMLDoc(); xmlDoc.InitialDirectory = LastDirectory; if (!xmlDoc.Open(dockPanel)) { xmlDoc.Close(); xmlDoc.Dispose(); return; } else { LastDirectory = xmlDoc.InitialDirectory; } if (xmlDoc.IsDTSPackage) { this.toolStripStatusLabel1.Text = "Generating DTS Package From: " + xmlDoc.TabText; xmlDoc.ReHydrateDTS(m_serverExplorer.Servers); } } }