public static void InitializeStockExchange(StockportfolioDbContext context)
{
// Hvis databasen er fyldt, returner metoden.
if (context.StockExchanges.Any())
{
return;
}
using (var webClient = new System.Net.WebClient())
{
// Gem JSON reply som string
string json = webClient.DownloadString("https://api.stockdio.com/data/financial/prices/v1/getStockExchangesInfo?app-key=E617E051095142DF8B044DB452EA9799");
// Parse string til JObject
JObject jsonObject = JObject.Parse(json);
// Filtrer relevant data fra JSON fil og angiv som List af JTokens
IList <JToken> results = jsonObject["data"]["exchanges"]["values"].Children().ToList();
// Iterer igennem alle JTokens
foreach (JToken result in results)
{
// Forhindre nullpointer exception ved start og s**t af JToken
if (result[0] != null && result[1] != null)
{
// Filtrer Crypto, Bonds, Delete og Commodities fra.
if ((string)result[0] != "crypto" && (string)result[0] != "bonds" && (string)result[0] != "delete" && (string)result[0] != "commodities")
{
// Opret objekter udfra JSON og gem i context (Database)
context.StockExchanges.Add(new StockExchange()
{
Name = (string)result[1], Symbol = (string)result[0]
});
}
}
}
// Gem ændringer i databasen
context.SaveChanges();
}
}
public StockExchangesController(StockportfolioDbContext context, IMapper mapper)
{
this.mapper = mapper;
this.context = context;
}
public UsersStocksController(StockportfolioDbContext context, IMapper mapper)
{
this.mapper = mapper;
this.context = context;
}
public static void InitializeStocks(StockportfolioDbContext context)
{
// TODO: Opret Stocks fra API.
}
