public void LoadChart(bool first)
{
WGSchart.Series.Clear();
WGSchart.ResetAutoValues();
foreach (var series in WGSchart.Series)
{
series.Points.Clear();
}
var series1 = new System.Windows.Forms.DataVisualization.Charting.Series
{
Name = "Windsnelheid"
};
var series2 = new System.Windows.Forms.DataVisualization.Charting.Series
{
Name = "Sterfte"
};
var series3 = new System.Windows.Forms.DataVisualization.Charting.Series
{
Name = "Geboorte"
};
WGSchart.Series.Add(series1);
WGSchart.Series.Add(series2);
WGSchart.Series.Add(series3);
WGSchart.ChartAreas[0].AxisX.Interval = 1;
if (first == true)
{
string MyConnectionString = "Server=localhost;Database=school;UID=homestead;PWD=secret;PORT=33060;SslMode=none;";
MySqlConnection connection = new MySqlConnection(MyConnectionString);
MySqlCommand cmd;
connection.Open();
try
{
cmd = connection.CreateCommand();
cmd.CommandText = "Select Month(Bevolking_per_maand.Perioden) Months, avg(Bevolking_per_maand.Levendgeborenen) as Geboren, avg(Bevolking_per_maand.Overledenen) as Overledenen, round(avg(kmni.windsnelheid)) * 100 as Windsnelheid from Bevolking_per_maand join kmni on Bevolking_per_maand.Perioden = kmni.Date group by Month(Bevolking_per_maand.Perioden)";
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
DataSet geboorte = new DataSet();
adap.Fill(geboorte, "geboorte");
DataTable dt = new DataTable();
dt = geboorte.Tables["geboorte"];
foreach (DataRow dr in dt.Rows)
{
var newMaand = new Data
{
Maand = dr["Months"].ToString(),
Geboorte = dr["Geboren"].ToString(),
Sterfte = dr["Overledenen"].ToString(),
Windsnelheid = dr["Windsnelheid"].ToString()
};
Maanden.Add(newMaand);
}
}
catch (Exception e)
{
throw;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Clone();
}
}
}
foreach (var data in Maanden)
{
if (Jan.Checked == true && data.Maand == "1")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"Januari", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"Januari", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"Januari", data.Geboorte);
}
else if (feb.Checked == true && data.Maand == "2")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"Februari", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"Februari", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"Februari", data.Geboorte);
}
else if (mrt.Checked == true && data.Maand == "3")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"Maart", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"Maart", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"Maart", data.Geboorte);
}
else if (apr.Checked == true && data.Maand == "4")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"April", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"April", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"April", data.Geboorte);
}
else if (mei.Checked == true && data.Maand == "5")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"Mei", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"Mei", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"Mei", data.Geboorte);
}
else if (jun.Checked == true && data.Maand == "6")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"Juni", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"Juni", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"Juni", data.Geboorte);
}
else if (jul.Checked == true && data.Maand == "7")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"Juli", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"Juli", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"Juli", data.Geboorte);
}
else if (aug.Checked == true && data.Maand == "8")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"Augustus", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"Augustus", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"Augustus", data.Geboorte);
}
else if (sep.Checked == true && data.Maand == "9")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"September", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"September", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"September", data.Geboorte);
}
else if (okt.Checked == true && data.Maand == "10")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"October", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"October", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"October", data.Geboorte);
}
else if (nov.Checked == true && data.Maand == "11")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"November", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"November", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"November", data.Geboorte);
}
else if (dec.Checked == true && data.Maand == "12")
{
WGSchart.Series["Windsnelheid"].Points.AddXY($"December", data.Windsnelheid);
WGSchart.Series["Sterfte"].Points.AddXY($"December", data.Sterfte);
WGSchart.Series["Geboorte"].Points.AddXY($"December", data.Geboorte);
}
else
{
Console.WriteLine("log_1 ");
}
}
return;
}
public void LoadChart(bool first)
{
WGSchart.Series.Clear();
WGSchart.ResetAutoValues();
foreach (var series in WGSchart.Series)
{
series.Points.Clear();
}
var series1 = new System.Windows.Forms.DataVisualization.Charting.Series
{
Name = "MaxTemp"
};
var series2 = new System.Windows.Forms.DataVisualization.Charting.Series
{
Name = "GestolenFietsen"
};
WGSchart.Series.Add(series1);
WGSchart.Series.Add(series2);
WGSchart.ChartAreas[0].AxisX.Interval = 1;
if (first == true)
{
string MyConnectionString = "Server=localhost;Database=school;UID=homestead;PWD=secret;PORT=33060;SslMode=none;";
MySqlConnection connection = new MySqlConnection(MyConnectionString);
MySqlCommand cmd;
connection.Open();
try
{
cmd = connection.CreateCommand();
cmd.CommandText = "Select Month(fietsen_diefstal.datum) Months, count(fietsen_diefstal.merk) as aantal, round(max(kmni.max_temp)) as max_temp from fietsen_diefstal join kmni on fietsen_diefstal.datum = kmni.Date group by Month(fietsen_diefstal.datum)";
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
DataSet fietsen = new DataSet();
adap.Fill(fietsen, "fietsen");
DataTable dt = new DataTable();
dt = fietsen.Tables["fietsen"]; //table exactly like sql table.
foreach (DataRow dr in dt.Rows)
{
var newMaand = new Data
{
Maand = dr["Months"].ToString(),
FietsenDiefstal = dr["aantal"].ToString(),
MaxTemp = dr["max_temp"].ToString()
};
Maanden.Add(newMaand);
}
}
catch (Exception)
{
throw;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Clone();
}
}
}
foreach (var data in Maanden)
{
if (Jan.Checked == true && data.Maand == "1")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Januari", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (feb.Checked == true && data.Maand == "2")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Februari", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (apr.Checked == true && data.Maand == "4")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"April", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (mrt.Checked == true && data.Maand == "3")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Maart", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (mei.Checked == true && data.Maand == "5")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Mei", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (jun.Checked == true && data.Maand == "6")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Juni", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (jul.Checked == true && data.Maand == "7")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Juli", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (aug.Checked == true && data.Maand == "8")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Augustus", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (sep.Checked == true && data.Maand == "9")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"September", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (okt.Checked == true && data.Maand == "10")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Oktober", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (nov.Checked == true && data.Maand == "11")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"November", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else if (dec.Checked == true && data.Maand == "12")
{
WGSchart.Series["MaxTemp"].Points.AddXY($"Decmeber", data.MaxTemp);
WGSchart.Series["GestolenFietsen"].Points.AddXY($"{data.Maand}", data.FietsenDiefstal);
}
else
{
Console.WriteLine("Shouldn't be here but it still looks nice with a extra console line D: ");
}
}
return;
}
public void LoadChart(bool first)
{
WGSchart.Series.Clear();
WGSchart.ResetAutoValues();
foreach (var series in WGSchart.Series)
{
series.Points.Clear();
}
var series1 = new System.Windows.Forms.DataVisualization.Charting.Series
{
Name = "Neerslag in mm"
};
var series2 = new System.Windows.Forms.DataVisualization.Charting.Series
{
Name = "Google stock price in euro's"
};
WGSchart.Series.Add(series1);
WGSchart.Series.Add(series2);
WGSchart.ChartAreas[0].AxisX.Interval = 1;
if (first == true)
{
string MyConnectionString = "Server=localhost;Database=school;UID=homestead;PWD=secret;PORT=33060;SslMode=none;";
MySqlConnection connection = new MySqlConnection(MyConnectionString);
MySqlCommand cmd;
connection.Open();
try
{
cmd = connection.CreateCommand();
cmd.CommandText = "Select Month(stocks.Date) Months, round(avg(stocks.Open)) as stock_price, round(avg(kmni.neerslag)) as neerslag from stocks join kmni on stocks.Date = kmni.Date group by Month(stocks.Date)";
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
DataSet stocks = new DataSet();
adap.Fill(stocks, "stocks");
DataTable dt = new DataTable();
dt = stocks.Tables["stocks"]; //table exactly like sql table.
foreach (DataRow dr in dt.Rows)
{
var newMaand = new Data
{
Maand = dr["Months"].ToString(),
Neerslag = dr["neerslag"].ToString(),
Stock = dr["stock_price"].ToString()
};
Maanden.Add(newMaand);
}
}
catch (Exception)
{
throw;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Clone();
}
}
}
foreach (var data in Maanden)
{
if (Jan.Checked == true && data.Maand == "1")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"Januari", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (feb.Checked == true && data.Maand == "2")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"Februari", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (mrt.Checked == true && data.Maand == "3")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"Maart", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (apr.Checked == true && data.Maand == "4")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"April", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (mei.Checked == true && data.Maand == "5")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"Mei", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (jun.Checked == true && data.Maand == "6")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"Juni", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (jul.Checked == true && data.Maand == "7")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"Juli", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (aug.Checked == true && data.Maand == "8")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"Augustus", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (sep.Checked == true && data.Maand == "9")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"September", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (okt.Checked == true && data.Maand == "10")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"October", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (nov.Checked == true && data.Maand == "11")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"November", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else if (dec.Checked == true && data.Maand == "12")
{
WGSchart.Series["Neerslag in mm"].Points.AddXY($"December", data.Neerslag);
WGSchart.Series["Google stock price in euro's"].Points.AddXY($"{data.Maand}", data.Stock);
}
else
{
Console.WriteLine("Shouldn't be here but it still looks nice with a extra console line D: ");
}
}
return;
}
