private void DoImportLocalities()
{
var importArgs = new ImportArgs<Locality>
{
Filename = filename,
WorkSheetName = sheet
};
importArgs.Columns.Clear();
foreach (var columnViewModel in Columns)
{
var reader = columnViewModel.GetCellReader();
if (reader != null)
{
importArgs.Columns.Add((ICellReader<Locality>)reader);
}
}
var excelImport = new ExcelImport<Locality>(context, locality => locality, _ => { });
excelImport.ProgressChanged += (o, e) => { Progress = excelImport.Progress*100; };
excelImport.Cancelled += (o, e) => { MessageBox.Show("Import cancelled."); };
excelImport.Error += (o, e) => { MessageBox.Show("ERROR!\n\n" + e.Error); };
excelImport.Finished += (o, e) =>
{
excelImport.Save();
MessageBox.Show("Import complete");
};
excelImport.Start(importArgs);
}
private void DoImportData()
{
var importArgs = new ImportArgs<Mouse>
{
Filename = filename,
WorkSheetName = sheet
};
importArgs.Columns.Clear();
foreach (var columnViewModel in Columns)
{
var reader = columnViewModel.GetCellReader();
if (reader != null)
{
importArgs.Columns.Add((ICellReader<Mouse>) reader);
}
}
var excelImport = new ExcelImport<Mouse>(context,
mice => mice.Include(m => m.Records).Include(m => m.Locality),
c => c.Localities.Include(l => l.Mice).Load());
excelImport.ProgressChanged += (o, e) => { Progress = excelImport.Progress*100; };
excelImport.Finished += (o, e) =>
{
excelImport.Save();
MessageBox.Show("Import complete");
};
excelImport.Cancelled += (o, e) => { MessageBox.Show("Import cancelled."); };
excelImport.Error += (o, e) => { MessageBox.Show("ERROR!\n\n" + e.Error); };
excelImport.Start(importArgs);
}
