public static void SeedDatabase(SimpleStockAppDataContext dataContext) { System.Diagnostics.Debug.WriteLine("Start Creating Dow"); var dow = new StockIndex() { Name = "Dow Jones Industrial Average", Symbol = "^DJI" }; dow.StockStockIndex = CreateStocksInDow(dow, dataContext); dataContext.StockIndexes.Add(dow); dataContext.SaveChanges(); System.Diagnostics.Debug.WriteLine("Dow Done"); System.Diagnostics.Debug.WriteLine("Start Creating Dax"); var dax = new StockIndex() { Name = "DAX", Symbol = "^GDAXI" }; dax.StockStockIndex = CreateStocksInDax(dax, dataContext); dataContext.StockIndexes.Add(dax); dataContext.SaveChanges(); System.Diagnostics.Debug.WriteLine("Dax Done"); System.Diagnostics.Debug.WriteLine("Adding quotes started"); AddRealTimeData(dataContext); System.Diagnostics.Debug.WriteLine("Adding Done"); }
private static void AddRealTimeData(SimpleStockAppDataContext dataContext) { var realTimePirces = new List <TradingQuotes> { new TradingQuotes { Symbol = "AAPL", Volume = 57191620, LastValue = 172.50m, DaysLow = 104.08m, DaysHigh = 174.24m, Change = 4.39m, ChangeInPercent = 2.52 }, new TradingQuotes { Symbol = "AXP", LastValue = 96.43m, Change = 0.45m, ChangeInPercent = 0.47, DaysHigh = 96.43m, DaysLow = 95.78m }, new TradingQuotes { Symbol = "BA", LastValue = 261.75m, Change = -0.88m, ChangeInPercent = -0.34, DaysLow = 260.08m, DaysHigh = 263.79m }, new TradingQuotes { Symbol = "CSCO", LastValue = 34.47m, Change = 0.26m, ChangeInPercent = 0.76, DaysLow = 34.03m, DaysHigh = 34.49m }, new TradingQuotes { Symbol = "GE", LastValue = 20.14m, Change = 0.2m, ChangeInPercent = 1, DaysLow = 19.86m, DaysHigh = 20.33m }, new TradingQuotes { Symbol = "IBM", LastValue = 151.58m, Change = -1.77m, ChangeInPercent = -1.15 }, new TradingQuotes { Symbol = "INTC", LastValue = 46.34m, Change = -0.76m, ChangeInPercent = -1.61 }, new TradingQuotes { Symbol = "JNJ", LastValue = 140.08m, Change = 0.15m, ChangeInPercent = +0.11 }, new TradingQuotes { Symbol = "JPM", LastValue = 101.41m, Change = -0.18m, ChangeInPercent = -0.18 }, new TradingQuotes { Symbol = "MMM", LastValue = 86.58m, Change = 0.07m, ChangeInPercent = +0.08 }, new TradingQuotes { Symbol = "MSFT", LastValue = 84.14m, Change = 0.09m, ChangeInPercent = +0.11 }, new TradingQuotes { Symbol = "NKE", LastValue = 55.71m, Change = 0.59m, ChangeInPercent = +1.07 }, new TradingQuotes { Symbol = "ADS.DE", LastValue = 187.00m, Change = -0.15m, ChangeInPercent = -0.08 }, new TradingQuotes { Symbol = "ALV.DE", LastValue = 202.85m, Change = -1.05m, ChangeInPercent = -0.51 }, new TradingQuotes { Symbol = "BAS.DE", LastValue = 97.01m, Change = 1.02m, ChangeInPercent = +1.06 }, new TradingQuotes { Symbol = "BAYN.DE", LastValue = 116.00m, Change = 1.60m, ChangeInPercent = +1.40 }, new TradingQuotes { Symbol = "BEI.DE", LastValue = 97.88m, Change = 0.83m, ChangeInPercent = +0.86 }, new TradingQuotes { Symbol = "BMW.DE", LastValue = 89.57m, Change = -0.30m, ChangeInPercent = -0.33 }, new TradingQuotes { Symbol = "CBK.DE", LastValue = 11.785m, Change = -0.210m, ChangeInPercent = -1.751 }, new TradingQuotes { Symbol = "CON.DE", LastValue = 222.25m, Change = 0.10m, ChangeInPercent = +0.05 }, new TradingQuotes { Symbol = "DAI.DE", LastValue = 73.25m, Change = 0.16m, ChangeInPercent = +0.22 }, new TradingQuotes { Symbol = "DB1.DE", LastValue = 91.03m, Change = 1.08m, ChangeInPercent = +1.20 }, new TradingQuotes { Symbol = "DBK.DE", LastValue = 14.51m, Change = -0.12m, ChangeInPercent = -0.85 }, new TradingQuotes { Symbol = "DPW.DE", LastValue = 40.215m, Change = 0.085m, ChangeInPercent = +0.212 }, new TradingQuotes { Symbol = "DTE.DE", LastValue = 15.64m, Change = 0.19m, ChangeInPercent = +1.23 }, new TradingQuotes { Symbol = "FME.DE", LastValue = 83.20m, Change = 0.75m, ChangeInPercent = +0.91 }, new TradingQuotes { Symbol = "FRE.DE", LastValue = 69.77m, Change = 0.46m, ChangeInPercent = +0.66 }, new TradingQuotes { Symbol = "HEI.DE", LastValue = 85.45m, Change = -1.07m, ChangeInPercent = -1.24 }, new TradingQuotes { Symbol = "LHA.DE", LastValue = 28.04m, Change = -0.04m, ChangeInPercent = -0.16 }, new TradingQuotes { Symbol = "LIN.DE", LastValue = 188.65m, Change = 0.95m, ChangeInPercent = +0.51 }, new TradingQuotes { Symbol = "SAP.DE", LastValue = 98.85m, Change = 0.06m, ChangeInPercent = +0.06 }, new TradingQuotes { Symbol = "SIE.DE", LastValue = 124.20m, Change = -0.30m, ChangeInPercent = -0.24 }, new TradingQuotes { Symbol = "TKA.DE", LastValue = 23.35m, Change = -0.09m, ChangeInPercent = -0.38 } }; dataContext.StockQuotes.AddRange(realTimePirces); dataContext.SaveChanges(); }