public static void AddCurrency(string currencyName, string currencyService, double currencyValue) { using (var context = new CurrencyEntities()) { var result = context.Currencies.Where(x => x.CurrencyName == currencyName && x.CurrencyService == currencyService).FirstOrDefault(); if (result != null) { result.CurrencyLastUpdate = DateTime.Now; result.CurrencyValue = currencyValue; } else { context.Currencies.Add(new Currency() { CurrencyLastUpdate = DateTime.Now, CurrencyName = currencyName, CurrencyService = currencyService, CurrencyValue = currencyValue }); } context.SaveChanges(); } }
public static async Task <IEnumerable <CurrencyDO> > GetCurrenciesAsync(provider provider) { using (var context = new CurrencyEntities()) { List <Currency> Currencies = await context.Currencies .Where(x => x.CurrencyService == provider.ToString()) .ToListAsync(); return(Currencies.Select(x => new CurrencyDO() { CurrencyLastUpdate = x.CurrencyLastUpdate, CurrencyName = x.CurrencyName, CurrencyService = EnumUtility.ToEnum <provider>(x.CurrencyService), CurrencyValue = x.CurrencyValue }).ToList()); } }