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