public AzusifiedCube GetLatestEuroExchangeRates()
{
if (getLatestEuroExchangeRatesCommand == null)
{
SQLiteConnection conn = GetConnectionForTable("azusa.euro_exchange_rates");
getLatestEuroExchangeRatesCommand = conn.CreateCommand();
getLatestEuroExchangeRatesCommand.CommandText = "SELECT * FROM euro_exchange_rates ORDER BY dateAdded DESC";
}
SQLiteDataReader dataReader = getLatestEuroExchangeRatesCommand.ExecuteReader();
AzusifiedCube cube = new AzusifiedCube();
if (dataReader.Read())
{
cube.CubeDate = dataReader.GetDateTime(0);
cube.DateAdded = dataReader.GetDateTime(1);
cube.USD = dataReader.GetDouble(2);
cube.JPY = dataReader.GetDouble(3);
cube.GBP = dataReader.GetDouble(4);
dataReader.Close();
return(cube);
}
else
{
dataReader.Close();
cube.CubeDate = new DateTime(2021, 4, 5);
cube.DateAdded = DateTime.Now;
cube.USD = 1.1746;
cube.JPY = 130.03;
cube.GBP = 0.85195;
return(cube);
}
}
public void ExecutePostConnectionTask()
{
AzusaContext context = AzusaContext.GetInstance();
context.Splash.SetLabel("Frage €-Umrechungskurse ab...");
if (!context.DatabaseDriver.CanUpdateExchangeRates)
{
return;
}
AzusifiedCube cube = context.DatabaseDriver.GetLatestEuroExchangeRates();
if (cube == null)
{
cube = new AzusifiedCube();
cube.DateAdded = DateTime.MinValue;
}
cube.DateAdded = cube.DateAdded.Date;
if (DateTime.Today > cube.DateAdded)
{
EcbClient ecbClient = EcbClient.GetInstance();
Cube ecbCube = ecbClient.DownloadCube();
cube = ecbClient.AzusifyCube(ecbCube);
context.DatabaseDriver.InsertEuroExchangeRate(cube);
}
}
public AzusifiedCube AzusifyCube(Cube cube)
{
AzusifiedCube result = new AzusifiedCube();
result.CubeDate = cube.Date;
result.DateAdded = DateTime.Now;
result.GBP = cube.Currencies.Find(x => x.Name.Equals("GBP")).ExchangeRate;
result.JPY = cube.Currencies.Find(x => x.Name.Equals("JPY")).ExchangeRate;
result.USD = cube.Currencies.Find(x => x.Name.Equals("USD")).ExchangeRate;
return(result);
}
public CurrencyConverterTextBox()
{
InitializeComponent();
context = AzusaContext.GetInstance();
if (context != null)
{
if (context.DatabaseDriver != null)
{
cube = context.DatabaseDriver.GetLatestEuroExchangeRates();
}
}
jPYEURToolStripMenuItem.Enabled = cube != null;
uSDEURToolStripMenuItem.Enabled = cube != null;
gBPEURToolStripMenuItem.Enabled = cube != null;
}
public void InsertEuroExchangeRate(AzusifiedCube cube)
{
throw new NotImplementedException();
}
