public string[] GetCodes() { using (var db = new RatesContext(connectionStringName)) { return db.Countries.Select(x => x.Code).ToArray(); } }
public List<Country> GetCountries() { using (var db = new RatesContext(connectionStringName)) { return db.Countries.ToList(); } }
private void CheckDB(RatesContext db) { bool needSave = false; if (db.Countries.Count() == 0) { db.Countries.Add(new Country { Name = "USA", Currency = "USD", Code = "R01235" }); db.Countries.Add(new Country { Name = "Japan", Currency = "JPY", Code = "R01820" }); db.Countries.Add(new Country { Name = "China", Currency = "CNY", Code = "R01375" }); needSave = true; } if (db.Rates.Count() == 0) { var rates = GetRates(GetCodes()); db.Rates.AddRange(rates); needSave = true; } if (needSave) { db.SaveChanges(); } }
public string[] GetCodes() { using (var db = new RatesContext(connectionStringName)) { return(db.Countries.Select(x => x.Code).ToArray()); } }
public List <Country> GetCountries() { using (var db = new RatesContext(connectionStringName)) { return(db.Countries.ToList()); } }
public void AddRates(List<Rate> rates) { using (var db = new RatesContext(connectionStringName)) { db.Rates.AddRange(rates); db.SaveChanges(); } }
public List<Rate> GetRates() { using (var db = new RatesContext(connectionStringName)) { CheckDB(db); return db.Rates.ToList(); } }
public void AddRates(List <Rate> rates) { using (var db = new RatesContext(connectionStringName)) { db.Rates.AddRange(rates); db.SaveChanges(); } }
public List <Rate> GetRates() { using (var db = new RatesContext(connectionStringName)) { CheckDB(db); return(db.Rates.ToList()); } }
private void CheckDB(RatesContext db) { bool needSave = false; if (db.Countries.Count() == 0) { db.Countries.Add(new Country { Name = "USA", Currency = "USD", Code = "R01235" }); db.Countries.Add(new Country { Name = "Japan", Currency = "JPY", Code = "R01820" }); db.Countries.Add(new Country { Name = "China", Currency = "CNY", Code = "R01375" }); needSave = true; } if (db.Rates.Count() == 0) { var rates = GetRates(GetCodes()); db.Rates.AddRange(rates); needSave = true; } if (needSave) db.SaveChanges(); }