public static void TransferSQLiteData()
{
string path = @"..\..\..\Excel-Reports\{0}.xlsx";
string dbPath = @"..\..\..\..\SQLiteDB\ComputersFactory.db";
var excelHandler = new ExcelHandler();
excelHandler.TransferToExcel(ReadTable(dbPath, "Computers"), string.Format(path, "Computers"), "Sheet1");
excelHandler.TransferToExcel(ReadTable(dbPath, "Manufacturers"), string.Format(path, "Manufacturers"), "Sheet1");
excelHandler.TransferToExcel(ReadTable(dbPath, "ComputerTypes"), string.Format(path, "ComputerTypes"), "Sheet1");
excelHandler.TransferToExcel(ReadTable(dbPath, "Memories"), string.Format(path, "Memories"), "Sheet1");
excelHandler.TransferToExcel(ReadTable(dbPath, "Processors"), string.Format(path, "Processors"), "Sheet1");
excelHandler.TransferToExcel(ReadTable(dbPath, "VideoCards"), string.Format(path, "VideoCards"), "Sheet1");
}
public ExcelExporter(ExcelHandler excelHandler, MySQLHandler mySqlHandler)
{
this.excelHandler = excelHandler;
this.mySqlHandler = mySqlHandler;
}
