private void csvExporter_DoWork(object sender, DoWorkEventArgs e)
{
string filename = (string)e.Argument;
int pp = 0;
ListViewWorker lw = new ListViewWorker();
foreach (ListView resultView in listViewExports)
{
resultView.Columns.Add("Group");
for (int ai = 0; ai < resultView.Items.Count; ai++)
{
resultView.Items[ai].SubItems.Add(listLabelExports[pp]);
}
if (pp == 0)
{
string firstCsv = lw.exportCsv(resultView, true);
System.IO.File.WriteAllText(filename, firstCsv);
}
else
{
string nextCsv = lw.exportCsv(resultView, false);
System.IO.File.AppendAllText(filename, nextCsv);
}
pp++;
}
}
private void exportCsvToFile(string filename)
{
ListViewWorker Worker = new ListViewWorker();
this.setStatusMsg("Exporting to " + filename + " please wait");
string csvContent = Worker.exportCsv(this.listView);
System.IO.File.WriteAllText(filename, csvContent);
resetlabel();
}
private void exportCsvFiles(string filename)
{
int pp = 0;
ListViewWorker lw = new ListViewWorker();
if (listViewExports == null)
{
MessageBox.Show("No Data to export. Make sure youre Query is executed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
foreach (ListView resultView in listViewExports)
{
resultView.Columns.Add("Group");
statusLabel.Text = "writing group no.: " + pp;
onStatusChange("csv ... write group no.: " + pp + " " + filename);
statusLabel.Invalidate();
Application.DoEvents();
for (int ai = 0; ai < resultView.Items.Count; ai++)
{
resultView.Items[ai].SubItems.Add(listLabelExports[pp]);
}
if (pp == 0)
{
string firstCsv = lw.exportCsv(resultView, true);
System.IO.File.WriteAllText(filename, firstCsv);
}
else
{
string nextCsv = lw.exportCsv(resultView, false);
System.IO.File.AppendAllText(filename, nextCsv);
}
pp++;
}
statusLabel.Text = "writing DONE (" + filename + ") ";
}
