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