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