Пример #1
0
        public static void ExportReportToMySQLDb()
        {
            MySQLContext db = new MySQLContext("MySQLConnStrDKostovLaptop");

            IList<ProductReport> reports = ProductReportsCreator.CreateReportForEveryProductFromSQLServer();

            using (db)
            {
                foreach (var report in reports)
                {
                    var newReport = new sexStoreReports()
                    {
                        //Id = report.Id,
                        ProductCode = report.ProductCode,
                        Name = report.Name,
                        SoldInShops = string.Join(" ", report.ShopNames),
                        TotalQuantitySold = report.TotalQuantitySold,
                        TotalIncomes = report.TotalIncomes
                    };
                    db.Add(newReport);
                }

                db.SaveChanges();
            }
        }
Пример #2
0
        public static List<ProductReport> CreateReportForEveryProductFromMySQL()
        {
            MySQLContext db = new MySQLContext("MySQLConnStrDKostovLaptop");

            var reports = new List<ProductReport>();

            using (db)
            {
                var productsCount = GetProductsCount(db);
                var productSalesData = GetProductsDataFromDb(db);
                var firstProductId = GetFirstProductId(db);

                reports = new List<ProductReport>(productsCount);

                var length = firstProductId + productsCount;
                for (int i = firstProductId; i < length; i++)
                {
                    var currentProduct = new ProductReport(i);
                    foreach (var product in productSalesData)
                    {
                        if (product.Id == currentProduct.Id)
                        {
                            currentProduct.ProductCode = product.ProductCode;
                            currentProduct.Name = product.Name;
                            currentProduct.ShopNames.Add(product.ShopName);
                            currentProduct.TotalQuantitySold += product.TotalQuantitySold;
                            currentProduct.TotalIncomes += product.TotalIncomes;
                        }
                    }

                    reports.Add(currentProduct);
                }
            }

            return reports;
        }
Пример #3
0
        private static int GetProductsCount(MySQLContext db)
        {
            db.sexStoreReports.Count();
            var productsCount = db.sexStoreReports.Count();

            return productsCount;
        }
Пример #4
0
 private static int GetFirstProductId(MySQLContext db)
 {
     var id = db.sexStoreReports.Select(x => x.Id).FirstOrDefault();
     return id;
 }
Пример #5
0
        private static List<DbDataHelpType> GetProductsDataFromDb(MySQLContext db)
        {
            var productsAndTheirSales = db.sexStoreReports
                .Select(r => new DbDataHelpType()
                {
                    Id = r.Id,
                    ProductCode = r.ProductCode,
                    Name = r.Name,
                    TotalQuantitySold = r.TotalQuantitySold,
                    TotalIncomes = r.TotalIncomes,
                    ShopName = r.SoldInShops
                }).ToList();

            return productsAndTheirSales;
        }