private void disableTSQLToolStripMenuItem_Click(object sender, EventArgs e)
{
var con = GetService(treeView.SelectedNode);
var node = treeView.SelectedNode;
WorkAsync(new WorkAsyncInfo
{
Message = "Disabling...",
Work = (worker, args) =>
{
TSqlEndpoint.Disable(con.ServiceClient);
},
PostWorkCallBack = (args) =>
{
if (args.Error != null)
{
MessageBox.Show("Error disabling TDS Endpoint:\r\n\r\n" + args.Error.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
node.Text = "TDS Endpoint (Disabled)";
node.ImageIndex = 20;
node.SelectedImageIndex = 20;
}
});
}
private void enableTSQLToolStripMenuItem_Click(object sender, EventArgs e)
{
var con = GetService(treeView.SelectedNode);
try
{
TSqlEndpoint.Enable(con.ServiceClient);
treeView.SelectedNode.Text = "T-SQL Endpoint";
if (!String.IsNullOrEmpty(con.ServiceClient.CurrentAccessToken))
{
treeView.SelectedNode.ImageIndex = 21;
treeView.SelectedNode.SelectedImageIndex = 21;
}
else
{
treeView.SelectedNode.ImageIndex = 21;
treeView.SelectedNode.SelectedImageIndex = 21;
treeView.SelectedNode.Text += " (Unavailable - OAuth authentication required)";
}
}
catch (Exception ex)
{
MessageBox.Show("Error enabling T-SQL Endpoint:\r\n\r\n" + ex.Message);
}
}
private void disableTSQLToolStripMenuItem_Click(object sender, EventArgs e)
{
var con = GetService(treeView.SelectedNode);
try
{
TSqlEndpoint.Disable(con.ServiceClient);
treeView.SelectedNode.ImageIndex = 20;
treeView.SelectedNode.SelectedImageIndex = 20;
treeView.SelectedNode.Text = "T-SQL Endpoint (Disabled)";
}
catch (Exception ex)
{
MessageBox.Show("Error enabling T-SQL Endpoint:\r\n\r\n" + ex.Message);
}
}
public void AddConnection(ConnectionDetail con)
{
var conNode = treeView.Nodes.Add(con.ConnectionName);
conNode.Tag = con;
conNode.ContextMenuStrip = serverContextMenuStrip;
SetIcon(conNode, "Environment");
var entitiesNode = conNode.Nodes.Add("Entities");
SetIcon(entitiesNode, "Folder");
AddVirtualChildNodes(entitiesNode, LoadEntities);
treeView.SelectedNode = conNode;
if (new Uri(con.OrganizationServiceUrl).Host.EndsWith(".dynamics.com") &&
new Version(con.OrganizationVersion) >= new Version("9.1.0.17437"))
{
var tsqlNode = conNode.Nodes.Add("T-SQL Endpoint");
if (TSqlEndpoint.IsEnabled(con.ServiceClient))
{
if (!String.IsNullOrEmpty(con.ServiceClient.CurrentAccessToken))
{
tsqlNode.ImageIndex = 21;
tsqlNode.SelectedImageIndex = 21;
}
else
{
tsqlNode.Text += " (Unavailable - OAuth authentication required)";
tsqlNode.ImageIndex = 22;
tsqlNode.SelectedImageIndex = 22;
}
}
else
{
tsqlNode.Text += " (Disabled)";
tsqlNode.ImageIndex = 20;
tsqlNode.SelectedImageIndex = 20;
}
tsqlNode.ContextMenuStrip = tsqlContextMenuStrip;
}
conNode.Expand();
}
private void AddConnectionChildNodes(ConnectionDetail con, CrmServiceClient svc, TreeNode conNode)
{
var entitiesNode = conNode.Nodes.Add("Entities");
SetIcon(entitiesNode, "Folder");
AddVirtualChildNodes(entitiesNode, LoadEntities);
var metadataNode = conNode.Nodes.Add("Metadata");
SetIcon(metadataNode, "Folder");
AddVirtualChildNodes(metadataNode, LoadMetadata);
treeView.SelectedNode = conNode;
if (new Uri(con.OrganizationServiceUrl).Host.EndsWith(".dynamics.com") &&
new Version(con.OrganizationVersion) >= new Version("9.1.0.17437"))
{
var tsqlNode = conNode.Nodes.Add("TDS Endpoint");
if (TSqlEndpoint.IsEnabled(svc))
{
if (!String.IsNullOrEmpty(svc.CurrentAccessToken))
{
tsqlNode.ImageIndex = 21;
tsqlNode.SelectedImageIndex = 21;
}
else
{
tsqlNode.Text += " (Unavailable - OAuth authentication required)";
tsqlNode.ImageIndex = 22;
tsqlNode.SelectedImageIndex = 22;
}
}
else
{
tsqlNode.Text += " (Disabled)";
tsqlNode.ImageIndex = 20;
tsqlNode.SelectedImageIndex = 20;
}
tsqlNode.ContextMenuStrip = tsqlContextMenuStrip;
}
conNode.Expand();
}
private void enableTSQLToolStripMenuItem_Click(object sender, EventArgs e)
{
var con = GetService(treeView.SelectedNode);
var node = treeView.SelectedNode;
WorkAsync(new WorkAsyncInfo
{
Message = "Enabling...",
Work = (worker, args) =>
{
TSqlEndpoint.Enable(con.ServiceClient);
},
PostWorkCallBack = (args) =>
{
if (args.Error != null)
{
MessageBox.Show("Error enabling TDS Endpoint:\r\n\r\n" + args.Error.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
node.Text = "TDS Endpoint";
if (!String.IsNullOrEmpty(con.ServiceClient.CurrentAccessToken))
{
node.ImageIndex = 21;
node.SelectedImageIndex = 21;
}
else
{
node.ImageIndex = 21;
node.SelectedImageIndex = 21;
node.Text += " (Unavailable - OAuth authentication required)";
}
}
});
}
