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