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