private static void GenerateJSONReports(FactoryDbContext context, string resultFilesPath) { Console.WriteLine("Generating Json Reports..."); var spaceships = context.Spaceships.ToList(); var sales = context.Sales.ToList(); var reports = new List <ProductReport>(); var jsonWriter = new JsonReportsHandler(spaceships, sales, reports); jsonWriter.WriteReportsToJson(resultFilesPath); }
private static void PopulateMySQLDataBase(FactoryDbContext sqlContext, FactoryMySqlDbContext mySqlContext) { Console.WriteLine("Populating MySql Database..."); var spaceships = sqlContext.Spaceships.ToList(); var sales = sqlContext.Sales.ToList(); var reports = new List <ProductReport>(); var jsonHandler = new JsonReportsHandler(spaceships, sales, reports); var jsonData = jsonHandler.GetReportsInJsonFormat(); if (mySqlContext.ProductsReports.Count() == 0) { foreach (var json in jsonData) { var report = JsonConvert.DeserializeObject <MySqlReport>(json); mySqlContext.Add(report); } mySqlContext.SaveChanges(); } }