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