private void btnImportData_Click(object sender, RoutedEventArgs e) { OpenFileDialog theDialog = new OpenFileDialog(); theDialog.Title = "Open Excel File"; theDialog.Filter = "Excel files (.xls)|*.xls"; ChangeStatusText("Importing data. Please wait..."); if (theDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { var softText = File.ReadAllText(theDialog.FileName); CaselyData.SoftPathExcelConvert sc = new SoftPathExcelConvert(); var importedData = sc.importSoftPathCSVData(theDialog.FileName); var caselyUserDataEntriesToAdd = new List <CaseEntry>(); int casesImportedCount = 0; int casesAlreadImported = 0; foreach (var d in importedData) { // Import the cases only if there is not already a report version by both the attending and the resident. if (!(SqliteDataAcces.HasMultipleAuthorEntries(d.CaseNumber))) { caselyUserDataEntriesToAdd.Add(d); casesImportedCount++; } else { casesAlreadImported++; } } SqliteDataAcces.BatchInsertNewCaseEntry(caselyUserDataEntriesToAdd); System.Windows.Forms.MessageBox.Show($"{casesImportedCount/2} cases imported. {casesAlreadImported} already existed in Casely."); } catch (Exception ex) { System.Windows.MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message); } ChangeStatusText(""); } }