private void GetODbcRecords(TreeNode nodeToAddTo, int vIsUI = 0) { try { foreach (var vCurrCloudList in in2sqlSvcCloud.vCloudList) { string vv = vCurrCloudList.CloudName; } if (vIsUI == 0) { foreach (var vCurrvODBCList in In2SqlSvcODBC.vODBCList) { in2SqlRightPaneTreeTables.setODBCTreeLineSimple(nodeToAddTo, vCurrvODBCList.OdbcName); } return; } if (vIsUI == 1) { foreach (var vCurrvODBCList in In2SqlSvcODBC.vODBCList) { In2SqlSvcODBC.checkOdbcStatus(vCurrvODBCList.OdbcName); in2SqlRightPaneTreeTables.setODBCTreeLineComplex(nodeToAddTo, vCurrvODBCList.OdbcName, vCurrvODBCList.OdbcName); } return; } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "GetODbcRecords"); } }
private void WF01BTTest_Click(object sender, EventArgs e) { var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vODBCName); vCurrODBC.Login = WF01TBLogin.Text; vCurrODBC.Password = WF01TBPassword.Text; In2SqlSvcODBC.ChangeOdbcValue(vODBCName, vCurrODBC); In2SqlSvcODBC.checkOdbcStatus(vODBCName); vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vODBCName); DialogResult result; if (vCurrODBC.ConnStatus == 1) { WF01BTOk.Enabled = true; result = MessageBox.Show("Test passed".ToString()); in2SqlRegistry.setLocalValue(vODBCName, "Login", vCurrODBC.Login); in2SqlRegistry.setLocalValue(vODBCName, "Password", vCurrODBC.Password); } else { result = MessageBox.Show(vCurrODBC.ConnErrMsg); } In2SqlSvcTool.RunGarbageCollector(); }
public static void getTablesAndViews(TreeNodeMouseClickEventArgs e) { e.Node.Nodes.Clear(); string vCurrOdbcName = e.Node.Text; In2SqlSvcODBC.checkOdbcStatus(vCurrOdbcName); var vCurrODBC = In2SqlSvcODBC.vODBCList.Find(item => item.OdbcName == vCurrOdbcName); try { if ((vCurrODBC.ConnStatus == 0)) { return; } if (vCurrODBC.ConnStatus < 0) { e.Node.ImageIndex = 7; e.Node.SelectedImageIndex = 7; e.Node.Tag = "ODBC%"; TreeNode vNodeErrRecord = new TreeNode(vCurrODBC.ConnErrMsg, 99, 99); e.Node.Nodes.Add(vNodeErrRecord); return; } if (vCurrODBC.ConnStatus == 1) { e.Node.ImageIndex = 2; e.Node.SelectedImageIndex = 2; e.Node.Tag = "ODBC#"; TreeNode vNodeTableFolder = new TreeNode("Tables".ToString(), 3, 3); vNodeTableFolder.Tag = vCurrODBC.OdbcName + "_tf"; e.Node.Nodes.Add(vNodeTableFolder); initSQlObjects(ref vCurrODBC); foreach (var vCurrTable in vCurrODBC.Tables) { TreeNode vNodeTable = new TreeNode(vCurrTable.Name, 4, 4); vNodeTable.Tag = vCurrODBC.OdbcName + "|" + vCurrTable.Name + "|$TABLE$"; vNodeTableFolder.Nodes.Add(vNodeTable); TreeNode vNodeColumnTbl = new TreeNode(" ".ToString(), 99, 99); vNodeColumnTbl.Tag = vCurrODBC.OdbcName + "." + vCurrTable.Name; vNodeTable.Nodes.Add(vNodeColumnTbl); } TreeNode vNodeViewFolder = new TreeNode("Views".ToString(), 5, 5); vNodeViewFolder.Tag = vCurrODBC.OdbcName + "_vf"; e.Node.Nodes.Add(vNodeViewFolder); foreach (var vCurrView in vCurrODBC.Views) { TreeNode vNodeView = new TreeNode(vCurrView.Name, 6, 6); vNodeView.Tag = vCurrODBC.OdbcName + "." + vNodeView.Name + "|$VIEW$"; vNodeViewFolder.Nodes.Add(vNodeView); TreeNode vNodeColumnVw = new TreeNode(" ".ToString(), 99, 99); vNodeColumnVw.Tag = vCurrODBC.OdbcName + "." + vNodeView.Name; vNodeView.Nodes.Add(vNodeColumnVw); } TreeNode vNodeFunctionFolder = new TreeNode("Functions".ToString(), 10, 10); vNodeFunctionFolder.Tag = vCurrODBC.OdbcName + "_fn"; e.Node.Nodes.Add(vNodeFunctionFolder); foreach (var vCurrFunc in vCurrODBC.SQLFunctions) { TreeNode vNodeView = new TreeNode(vCurrFunc.Name, 9, 9); vNodeView.Tag = vCurrODBC.OdbcName + "." + vCurrFunc.Name; vNodeFunctionFolder.Nodes.Add(vNodeView); } TreeNode vNodeExecFolder = new TreeNode("Procedures".ToString(), 8, 8); vNodeExecFolder.Tag = vCurrODBC.OdbcName + "_pr"; e.Node.Nodes.Add(vNodeExecFolder); foreach (var vCurrProced in vCurrODBC.SQLProgramms) { TreeNode vNodeView = new TreeNode(vCurrProced.Name, 11, 11); vNodeView.Tag = vCurrODBC.OdbcName + "|" + vCurrProced.Name; vNodeExecFolder.Nodes.Add(vNodeView); } return; } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "treeODBC_NodeMouseClick 1 "); } }