// ----- Export to File via Context Menu Strip ----------
void ExportToFile(string name, ObjectListView olv, OLVExporter.ExportFormat f)
{
OLVExporter oex = new OLVExporter(olv, olv.FilteredObjects);
string s = oex.ExportTo(f);
File.WriteAllText(name, s);
MessageBox.Show(name + " saved", "Done", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private async Task ImportData(OLVExporter.ExportFormat format, string ext, string filter)
{
if (gvResults.InvokeRequired)
{
gvResults.BeginInvoke(new MethodInvoker(async delegate() { await ExportData(format, ext, filter); }));
}
else
{
OpenFileDialog dlgImport = new OpenFileDialog();
dlgImport.FileName = "*" + ext;
dlgImport.Filter = filter;
if (dlgImport.ShowDialog() == DialogResult.OK)
{
StartAWSOperation("Importing From " + dlgImport.FileName);
await Task.Run(async() =>
{
try
{
List <T> records = new List <T>();
using (StreamReader csvFile = new StreamReader(dlgImport.FileName))
using (CsvReader csvData = new CsvReader(csvFile))
{
csvData.Configuration.HeaderValidated = null;
csvData.Configuration.MissingFieldFound = null;
foreach (T record in csvData.GetRecords <T>())
{
records.Add(record);
}
}
await ImportRecords(records);
EndAWSOperation("Data read from " + dlgImport.FileName);
}
catch (Exception e)
{
EndAWSOperation("Unable to import data: " + e.Message);
}
});
}
}
}
private async Task ExportData(OLVExporter.ExportFormat format, string ext, string filter)
{
if (gvResults.InvokeRequired)
{
gvResults.BeginInvoke(new MethodInvoker(async delegate() { await ExportData(format, ext, filter); }));
}
else
{
SaveFileDialog dlgExport = new SaveFileDialog();
dlgExport.FileName = RecordNames + "-" + DateTime.Now.ToLongDateString() + ext;
dlgExport.Filter = filter;
if (dlgExport.ShowDialog() == DialogResult.OK)
{
StartAWSOperation("Exporting to " + dlgExport.FileName);
await Task.Run(() =>
{
try
{
OLVExporter exporter = new OLVExporter(gvResults, gvResults.FilteredObjects);
string csv = string.Empty;
csv = exporter.ExportTo(format);
using (StreamWriter sw = new StreamWriter(dlgExport.FileName))
sw.Write(csv);
EndAWSOperation("Data saved to " + dlgExport.FileName);
}
catch (Exception e)
{
EndAWSOperation("Unable to export data: " + e.Message);
}
});
}
}
}
