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