/// <summary>
/// Downloads and Saves the meta's of all created and modified Images on the database based on sycdays.
/// Also sets the imageupdate to 1 if it needs to be udpated.
/// </summary>
public void UpdateLocalExchangeRates()
{
logger.Info("Update of Local Exchange Rates Started");
var webServiceUrl = "https://openexchangerates.org/api/latest.json?app_id=" + AppID;
var request = (HttpWebRequest)WebRequest.Create(webServiceUrl);
var response = (HttpWebResponse)request.GetResponse();
var rawJson = new StreamReader(response.GetResponseStream()).ReadToEnd();
var json = JObject.Parse(rawJson); //Turns your raw string into a key value lookup
var rates = json["rates"];
JToken USDrate;
JToken CADrate;
string stringUSD = null;
string stringCAD = null;
foreach (var data in rates)
{
var country = ((Newtonsoft.Json.Linq.JProperty)(data)).Name;
var rate = ((Newtonsoft.Json.Linq.JProperty)(data)).Value;
if (country == "CAD")
{
CADrate = rate;
stringCAD = CADrate.ToString();
}
if (country == "USD")
{
USDrate = rate;
stringUSD = USDrate.ToString();
}
}
ExchangeRateDataContext ctx = new ExchangeRateDataContext(ConnectionString);
ctx.ExchangeRate_Insert(null, stringUSD, stringCAD, DateTime.Now);
logger.Info("Latest Exchange Rate has been saved");
logger.Info("Update of Exchange Rates Ended");
}
