private void ImportTables() { using (var excelTool = new ExcelExportImportTool(_connectionString + "initial catalog=" + databaseSelectorCmbBox.SelectedItem)) { List <DataTable> modifiedTables = excelTool.ImportTablesFromExcel(); List <IModification> modifications = excelTool.FindTableDifferences(modifiedTables); bool noErrors = excelTool.ExecuteSQLCommands(modifications); } }
private void ExportTables() { //TODO: fix improper incrementation of ID in Possessions table List <string> tableNames = new List <string>(); foreach (var item in tableNameLstBox.CheckedItems) { tableNames.Add(item.ToString()); } using (var excelTool = new ExcelExportImportTool(_connectionString + "initial catalog=" + databaseSelectorCmbBox.SelectedItem)) excelTool.ExportTablesToExcel(tableNames); MessageBox.Show("Tables successfully exported!"); }