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