public bool CreateExcelReport()
{
bool result;
try
{
var mySQLManager = new MySQLManager();
var reports = mySQLManager.GetAllReports();
var sqliteManager = new SQLiteManager();
var discountInformations = sqliteManager.GetDiscountPercentagesPerCompany();
var reportsWithDiscounts = from r in reports
join di in discountInformations on r.CompanyID equals di.CompanyID
select new DiscountedReport
{
CompanyName = r.CompanyName,
ProductName = r.ProductName,
Price = r.Price * (decimal)(1 - (di.DiscountPercent / 100.00)),
Quantity = r.Quantity,
TotalRevenue = r.TotalRevenue * (decimal)(1 - (di.DiscountPercent / 100.00)),
TotalDiscount = r.TotalRevenue * (decimal)(di.DiscountPercent / 100.00)
};
var file = CreateDirAndFile();
WriteReportDataToFile(file, reportsWithDiscounts);
result = true;
}
catch (Exception)
{
result = false;
}
return result;
}
private void ToMySQLButton_Click(object sender, RoutedEventArgs e)
{
bool result = false;
var mySqlManager = new MySQLManager();
mySqlManager.ClearMySqlDb();
result = mySqlManager.LoadAllReportsDataFromSQLServer();
var sqLiteManager = new SQLiteManager();
sqLiteManager.DeleteAllEntities("Discounts");
var reportsEngine = new ReportsEngine();
var discounts = reportsEngine.GetDiscountsInfo();
foreach (var discount in discounts)
{
result = sqLiteManager.CreateDiscountForCompany(discount.CompanyId, discount.TypeID);
}
if (result)
{
Result.Text = "Import to MySQL has been successfully completed!";
Result.Foreground = Brushes.Green;
}
else
{
Result.Text = "Import to MySQL failed!";
Result.Foreground = Brushes.Red;
}
}
