private void ShowEditor(object sender, EventArgs e)
{
TextBox origin = (TextBox)sender;
if (
(comboBox1.SelectedItem.ToString().Equals("Generic T-SQL Query Collector Type")) ||
(comboBox1.SelectedItem.ToString().Equals("Extended T-SQL Query Collector Type"))
)
{
TSQLParametersEditor editor = new TSQLParametersEditor(origin.Text);
editor.ShowDialog(this);
origin.Text = CollectorUtils.FormatXMLDocument(editor.ReturnValue);
}
else
{
if (comboBox1.SelectedItem.ToString().Equals("Extended XE Reader Collector Type"))
{
XEReaderParametersEditor editor = new XEReaderParametersEditor(origin.Text);
editor.ShowDialog(this);
origin.Text = CollectorUtils.FormatXMLDocument(editor.ReturnValue);
}
else
{
XMLEditor dialog = new XMLEditor(origin.Text);
dialog.ShowDialog(this);
origin.Text = dialog.ReturnValue;
}
}
}
public XMLEditor(String text, String type)
{
InitializeComponent();
_textControl = new ICSharpCode.TextEditor.TextEditorControl();
this.Controls.Add(_textControl);
_textControl.Dock = DockStyle.Fill;
_textControl.Document.HighlightingStrategy = HighlightingStrategyFactory.CreateHighlightingStrategy(type);
this.Text = type + " Editor";
if (type.Equals("XML"))
{
_textControl.Text = CollectorUtils.FormatXMLDocument(text);
}
else
{
_textControl.Text = text;
}
}
private void fillValues(int collectionItemId)
{
String sql = @"
SELECT *
FROM msdb.dbo.syscollector_collection_items
WHERE collection_item_id = '{0}'
";
sql = String.Format(sql, collectionItemId);
DataTable dt = CollectorUtils.GetDataTable(Manager.ServerName, "msdb", sql);
foreach (DataRow dr in dt.Rows)
{
textBox1.Text = dr["collection_set_id"].ToString();
textBox7.Text = dr["collection_item_id"].ToString();
textBox2.Text = dr["name"].ToString();
ComboSetValue(comboBox1, (Guid)dr["collector_type_uid"]);
textBox3.Text = dr["frequency"].ToString();
textBox4.Text = CollectorUtils.FormatXMLDocument(dr["parameters"].ToString());
}
}
private void fillValues(Guid collectorTypeUid)
{
String sql = @"
SELECT *
FROM msdb.dbo.syscollector_collector_types
WHERE collector_type_uid = '{0}'
";
sql = String.Format(sql, collectorTypeUid.ToString());
DataTable dt = CollectorUtils.GetDataTable(Manager.ServerName, "msdb", sql);
foreach (DataRow dr in dt.Rows)
{
textBox1.Text = dr["collector_type_uid"].ToString();
textBox2.Text = dr["name"].ToString();
textBox3.Text = CollectorUtils.FormatXMLDocument(dr["parameter_schema"].ToString());
textBox4.Text = CollectorUtils.FormatXMLDocument(dr["parameter_formatter"].ToString());
textBox5.Text = dr["collection_package_path"].ToString();
button1.Tag = dr["collection_package_id"].ToString();
textBox6.Text = dr["upload_package_path"].ToString();
button2.Tag = dr["upload_package_id"].ToString();
checkBox1.Checked = Boolean.Parse(dr["is_system"].ToString());
}
}
