private void GenerateMySqlDb_Click(object sender, EventArgs e)
{
var mySqlRepo = new MySQLRepository();
try
{
mySqlRepo.GenerateMySqlDb();
MessageBox.Show("MySQL db generated successffully");
}
catch (Exception dbe)
{
MessageBox.Show("MySQL db generation failed: " + dbe);
}
}
public IRepository CreateRepository()
{
IRepository instance = null;
switch (databaseType)
{
case ProviderType.MySQL:
instance = new MySQLRepository();
break;
case ProviderType.SQLite:
instance = new SQLiteRepository();
break;
}
return(instance);
}
private void ExportMsSqlToMySql_Click(object sender, EventArgs e)
{
var msSqlRepo = new MSSQLRepository();
var mySqlRepo = new MySQLRepository();
try
{
var productsData = msSqlRepo.GetFullProductsData();
mySqlRepo.AddSqlProductsToMySql(productsData);
MessageBox.Show("MySQL data seeded from MSSQL Server!");
}
catch (Exception dbe)
{
MessageBox.Show("MySQL db seed failed: " + dbe);
}
}
private void ExportExcelReport_Click(object sender, EventArgs e)
{
var mySqlRepo = new MySQLRepository();
var sqLiteRepo = new SQLLiteRepository();
try
{
var vendorsData = mySqlRepo.GetVendorSalesData();
var taxes = sqLiteRepo.GetProductTaxData();
ExcelUtility.GenerateExcelReportFile(taxes, vendorsData);
MessageBox.Show("Excel report exported!");
}
catch (Exception ex)
{
MessageBox.Show("Error exporting report: " + ex.Message);
}
}
public static IRepository CreateRepository <T>(string provider) where T : DbContext, new()
{
IRepository repository = new PostgreSQLRepository <T>();
switch (provider)
{
case "postgresql":
repository = new PostgreSQLRepository <T>();
break;
case "mysql":
repository = new MySQLRepository <T>();
break;
default:
repository = new PostgreSQLRepository <T>();
break;
}
return(repository);
}
public static IRepository CreateRepository <T>(string provider) where T : DbContext, new()
{
IRepository repository = new MySQLRepository <T>();
return(repository);
}
