private static void UpdateDbWithNewCoin()
{
using (MySqlConnection connection = new MySqlConnection(Properties.Settings.Default.DefaultConnection))
{
try
{
AppDbContext myContext = new AppDbContext(connection, false);
Database.SetInitializer <AppDbContext>(null);
//List of coins saved in db
List <KuCoin> dbKuCoinList = myContext.KuCoin.ToList();
List <binance> dbBinanceList = myContext.Binance.ToList();
//List of coins from ZuCoin and BinanceCoin API
List <KuCoinCoin> kuCoinList = KucoinApi.GetZuCoinCoin(uriKucoin);
List <BinanceCoin> bianceCoinList = BinanceApi.GetData(uriBinance);
//Update KuCoin table
foreach (var token in kuCoinList)
{
if (dbKuCoinList.Where(p => p.kuCoinCoin == token.Coin).Select(p => p.Id).FirstOrDefault() == 0)
{
myContext.KuCoin.Add(new Model.KuCoin()
{
kuCoinName = token.Name,
kuCoinCoin = token.Coin,
DateAdded = DateTime.Now
});
}
}
//Update Binance table
foreach (var token in bianceCoinList)
{
if (dbBinanceList.Where(p => p.binanceSymbol == token.Symbol).Select(p => p.Id).FirstOrDefault() == 0)
{
myContext.Binance.Add(new binance()
{
binanceSymbol = token.Symbol,
binanceBaseAsset = token.BaseAsset,
binanceQuoteAsset = token.QuoteAsset,
DateAdded = DateTime.Now
});
}
}
myContext.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
};
}
