public static void getCsvHeaders(TreeNodeMouseClickEventArgs e) { try { String vNodeTag = e.Node.Parent.Text + '.' + e.Node.Text; FilesAndProperties vCurrObjProp = In2SqlSvcCsv.vFileObjProp.Find(item => item.ObjName == vNodeTag); if (vCurrObjProp.objColumns == null) { In2SqlSvcCsv.vFileObjProp.AddRange(In2SqlSvcCsv.getCsvFileColumn(e.Node.Parent.Text, e.Node.Text)); vCurrObjProp = In2SqlSvcCsv.vFileObjProp.Find(item => item.ObjName == vNodeTag); } if (vCurrObjProp.objColumns != null) { if (vCurrObjProp.objColumns.Count > 0) { e.Node.Nodes.Clear(); foreach (var vCurrColumn in vCurrObjProp.objColumns) { TreeNode vNodeColumn = new TreeNode(vCurrColumn.ToString(), 14, 14); vNodeColumn.Tag = vNodeTag + '.' + vCurrColumn + "_clm"; e.Node.Nodes.Add(vNodeColumn); } } } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "getColumnsandIndexes "); } }
private void refreshList() { In2SqlSvcCsv.vFolderList = In2SqlSvcCsv.FolderList(); CMBoxConnection.Items.Clear(); foreach (var vCurrFolder in In2SqlSvcCsv.vFolderList) { CMBoxConnection.Items.Add(vCurrFolder.FolderName); } }
private void RegularObjecteMenu_Click(object sender, EventArgs e) { if (sender.ToString().Contains("PivotTable")) { intSqlVBAEngine.createPivotTable(miSelectNode.Parent.Parent.Text, miSelectNode.Text); } else if (sender.ToString().Contains("Table")) { if (miSelectNode.Parent.Parent.Tag.ToString().Contains("Cloud")) { In2SqlVBAEngineCloud.createExTable(miSelectNode.Parent.Parent.Text, miSelectNode.Text, null); } else { intSqlVBAEngine.createExTable(miSelectNode.Parent.Parent.Text, miSelectNode.Text); } } /* fix me */ else if (sender.ToString().Contains("generate CSV")) { if (miSelectNode.Parent.Parent.Tag.ToString().ToUpper().Contains("ODBC")) { In2SqlSvcODBC.dumpOdbctoCsv( miSelectNode.Parent.Parent.Text , "select * from " + miSelectNode.Text , In2SqlSvcCsv.getFirstFolder() + miSelectNode.Text + ".csv"); } else if (sender.ToString().Contains("Chart")) { MessageBox.Show(string.Concat("You have Clicked '", sender.ToString(), "' Menu"), "Menu Items Event", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (sender.ToString().Contains("Editor")) { MessageBox.Show(string.Concat("You have Clicked '", sender.ToString(), "' Menu"), "Menu Items Event", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (sender.ToString().Contains("Properties")) { MessageBox.Show(string.Concat("You have Clicked '", sender.ToString(), "' Menu"), "Menu Items Event", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void GetCSVRecords(TreeNode nodeToAddTo) { try { In2SqlSvcCsv.vFolderList = In2SqlSvcCsv.FolderList(); foreach (var vCurrFolder in In2SqlSvcCsv.vFolderList) { in2SqlRightPaneTreeTables.setCSVTreeLineSimple(nodeToAddTo, vCurrFolder.FolderName, "CSV$"); } return; } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "GetCloudRecords"); } }
private static void initCsvObjects(ref In2SqlSvcCsv.FolderProperties vCurrCloudObj) { try { if (vCurrCloudObj.Files == null) { vCurrCloudObj.Files = new List <In2SqlSvcCsv.CloudObjects>(); } if (vCurrCloudObj.Files.Count == 0) { vCurrCloudObj.Files.AddRange(In2SqlSvcCsv.getFileList(vCurrCloudObj.FolderName)); } } catch (Exception er) { In2SqlSvcTool.ExpHandler(er, "initCloudObjects"); } }
private void button2_Click(object sender, EventArgs e) { In2SqlSvcCsv.vFolderList = In2SqlSvcCsv.FolderList(); this.Close(); }