string WriteAll(KlasaGlowna context, Dane obiektyKlasy, string currency)
{
string retString = "";
var allDownloaded = context.ZestawyDanych.SqlQuery("select * from ZestawyDanych").ToList <Dane>();
foreach (var d in allDownloaded)
{
/*
* if (currency == "EUR")
* retString += d.date + " " + "EUR:" + (d.rates.EUR).ToString();
* else if (currency == "PLN")
* retString += d.date + " " + "PLN:" + (d.rates.PLN).ToString();
*/
retString = d.date + " " + (d.rates.PLN).ToString() + Environment.NewLine;
/*
* Console.WriteLine("Dane dla dnia: " + d.date);
* Console.WriteLine("PLN: {0}", d.rates.PLN);
* Console.WriteLine("EUR: {0}", d.rates.EUR);
* Console.WriteLine("BTC: {0}", d.rates.BTC);
* Console.WriteLine("COP: {0}", d.rates.COP);
*/
}
return(retString);
}
private async void button1_Click(object sender, EventArgs e)
{
var context = new KlasaGlowna();
string date_string = dateTimePicker1.Value.ToString("yyyy-MM-dd");
string currency = listBox1.GetItemText(listBox1.SelectedItem);
var ifExists = new List <Dane>();
ifExists = context.ZestawyDanych.Where(x => x.date == date_string).ToList <Dane>();
if (ifExists.Count != 0)
{
textBox1.Text = WriteByDay(context, date_string, currency);
}
else
{
//textBox1.Text = "przed pobraniem";
string call = "http://openexchangerates.org/api/historical/" + date_string + ".json?app_id=23e326842d4044d1a971b4fb0359c5a3";
HttpClient httpClient = new HttpClient();
string json = await httpClient.GetStringAsync(call);
//textBox1.Text = json;
Dane obiektKlasy = JsonConvert.DeserializeObject <Dane>(json);
obiektKlasy.date = date_string;
context.ZestawyDanych.Add(obiektKlasy);
context.SaveChanges();
textBox1.Text = WriteByDay(context, date_string, currency);
}
}
static void Main(string[] args)
{
var context = new KlasaGlowna();
var databaseName = context.Database.Connection.Database;
Console.WriteLine(databaseName);
//Database.Delete(databaseName);
Console.WriteLine("Enter day:");
string day = Console.ReadLine();
Console.WriteLine("Enter month:");
string month = Console.ReadLine();
Console.WriteLine("Enter year:");
string year = Console.ReadLine();
string date_of_data = year.ToString() + "-" + month.ToString() + "-" + day.ToString();
var ifExists = new List <Dane>();
ifExists = context.ZestawyDanych.Where(x => x.date == date_of_data).ToList <Dane>();
if (ifExists.Count != 0)
{
Console.WriteLine("Hej, mamy to już w DB! :)");
Console.WriteLine("Dane dla dnia: " + date_of_data);
foreach (var x in ifExists)
{
Console.WriteLine("PLN: {0}", x.rates.PLN);
}
Console.Read();
Environment.Exit(0);
}
Console.WriteLine("Hmm... Tego w naszej bazie nie ma, pobieranko...");
string call = "http://openexchangerates.org/api/historical/" + date_of_data + ".json?app_id=23e326842d4044d1a971b4fb0359c5a3";
Task <string> Task = LoadJSON(call);
string json = Task.Result;
Dane obiektKlasy = JsonConvert.DeserializeObject <Dane>(json);
obiektKlasy.date = date_of_data;
// Console.WriteLine(obiektKlasy.timestamp + " " + Convert.ToString(obiektKlasy.rates.PLN) + " " + Convert.ToString(obiektKlasy.rates.BTC));
// Console.Read();
context.ZestawyDanych.Add(obiektKlasy);
context.SaveChanges();
var justDownloaded = context.ZestawyDanych.Where(d => d.date == date_of_data).ToList <Dane>();
Console.WriteLine("Dane dla dnia: " + date_of_data);
// var rates = context.ZestawyDanych.SqlQuery("select * from ZestawyDanych").ToList<Dane>();
foreach (var d in justDownloaded)
{
Console.WriteLine("PLN: {0}", d.rates.PLN);
}
Console.Read();
}
void WriteByDay(KlasaGlowna context, Dane obiektyKlasy, string date_of_data)
{
var justDownloaded = context.ZestawyDanych.Where(d => d.date == date_of_data).ToList <Dane>();
Console.WriteLine("Dane dla dnia: " + date_of_data);
foreach (var d in justDownloaded)
{
Console.WriteLine("PLN: {0}", d.rates.PLN);
Console.WriteLine("EUR: {0}", d.rates.EUR);
Console.WriteLine("BTC: {0}", d.rates.BTC);
Console.WriteLine("COP: {0}", d.rates.COP);
}
}
string WriteByDay(KlasaGlowna context, string date_of_data, string currency)
{
string retString = "";
var justDownloaded = context.ZestawyDanych.Where(d => d.date == date_of_data).ToList <Dane>();
if (currency == "PLN")
{
retString = justDownloaded[0].date + " PLN: " + (justDownloaded[0].rates.PLN).ToString() + Environment.NewLine;
}
else if (currency == "EUR")
{
retString = justDownloaded[0].date + " EUR: " + (justDownloaded[0].rates.EUR).ToString() + Environment.NewLine;
}
else if (currency == "BTC")
{
retString = justDownloaded[0].date + " BTC: " + (justDownloaded[0].rates.BTC).ToString() + Environment.NewLine;
}
else if (currency == "COP")
{
retString = justDownloaded[0].date + " COP: " + (justDownloaded[0].rates.COP).ToString() + Environment.NewLine;
}
return(retString);
}
