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