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();
}
