private void importXLSToolStripMenuItem_Click(object sender, EventArgs e)
{
using (OpenFileDialog fileDialog = new OpenFileDialog())
{
fileDialog.InitialDirectory = ".";
fileDialog.Filter = "xls files (*.xls)|*.xls";
fileDialog.FilterIndex = 1;
fileDialog.RestoreDirectory = true;
if (fileDialog.ShowDialog() == DialogResult.OK)
{
dataImporter = new ExcelDataImporter(fileDialog.FileName);
}
}
List <Item> insertData = dataImporter.ImportData();
foreach (Item item in insertData)
{
databaseConnector.InsertNewItem(item);
}
updateAvailableItems();
}
private static void LoadInitialExcelDataFromZipFile()
{
ExtractFilesFromZip();
var dataImporter = new ExcelDataImporter();
dataImporter.ImportDataFromDirectories("../../../DataSystem/ExtractedFiles");
}
