private void Form14_Load(object sender, EventArgs e) { using (StraatrovenEntities db = new StraatrovenEntities()) { var data = db.hsp200k(); Hcol = new ColumnSeries() { Title = "Overvallen per buurt", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; HcolO = new ColumnSeries() { Title = "Prijzen in euro(x1000)", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; Axis ax = new Axis() { Separator = new Separator() { Step = 1, IsEnabled = false } }; ax.Labels = new List <string>(); ax.LabelsRotation = 45; foreach (var x in data) { Hcol.Values.Add(x.ov); HcolO.Values.Add(x.hsp); ax.Labels.Add(x.bn); //ax.Labels.Add(x.bn); } cartesianChart1.Series.Add(Hcol); cartesianChart1.Series.Add(HcolO); cartesianChart1.LegendLocation = LegendLocation.Bottom; //cartesianChart1.Series = new SeriesCollection //{ // Hcol, // HcolO, //}; cartesianChart1.AxisX.Add(ax); cartesianChart1.AxisY.Add(new Axis { LabelFormatter = value => value.ToString(), Separator = new Separator() }); } }
private void Form4_Load(object sender, EventArgs e) { using (StraatrovenEntities db = new StraatrovenEntities()) { var data = db.wr(); LineSeries col = new LineSeries() { Title = "Gemiddelde temperatuur bij overvallen in graden Celsius per dag", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; LineSeries colO = new LineSeries() { Title = "Gemiddelde temperatuur in graden Celsius per dag", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; Axis ax = new Axis() { Separator = new Separator() { Step = 1, IsEnabled = false } }; ax.Labels = new List <string>(); ax.LabelsRotation = 45; foreach (var a in data) { col.Values.Add(a.ov); colO.Values.Add(a.tmp); ax.Labels.Add(a.mnd.ToString()); } cartesianChart1.Series.Add(col); cartesianChart1.Series.Add(colO); cartesianChart1.LegendLocation = LegendLocation.Bottom; cartesianChart1.AxisX.Add(ax); cartesianChart1.AxisY.Add(new Axis { LabelFormatter = value => value.ToString(), Separator = new Separator() }); } }
private void Form6_Load(object sender, EventArgs e) { using (StraatrovenEntities db = new StraatrovenEntities()) { var data = db.wzA(); Col = new LineSeries() { Title = "Werkzoekende totaal", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; ColO = new LineSeries() { Title = "Werkzoekenden 15 t/m 24 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; ColT = new LineSeries() { Title = "Werkzoekenden 25 t/m 34 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; ColTr = new LineSeries() { Title = "Werkzoekenden 35 t/m 44 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; ColF = new LineSeries() { Title = "Werkzoekenden 45 t/m 54 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; ColFi = new LineSeries() { Title = "Werkzoekenden 55 t/m 65 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; ColS = new LineSeries() { Title = "Overvallen per buurt", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; Axis ax = new Axis() { Separator = new Separator() { Step = 1, IsEnabled = false } }; ax.Labels = new List <string>(); ax.LabelsRotation = 45; foreach (var x in data) { Col.Values.Add(x.wzA); ColO.Values.Add(x.wz15); ColT.Values.Add(x.wz25); ColTr.Values.Add(x.wz35); ColF.Values.Add(x.wz45); ColFi.Values.Add(x.wz55); ColS.Values.Add(x.ov); ax.Labels.Add(x.bn); //ax.Labels.Add(x.bn); } cartesianChart1.Series.Add(Col); cartesianChart1.Series.Add(ColO); cartesianChart1.Series.Add(ColT); cartesianChart1.Series.Add(ColTr); cartesianChart1.Series.Add(ColF); cartesianChart1.Series.Add(ColFi); cartesianChart1.Series.Add(ColS); cartesianChart1.LegendLocation = LegendLocation.Bottom; //cartesianChart1.Series = new SeriesCollection //{ // Col, // ColO, // ColT, // ColTr, // ColF, // ColFi, // ColS, //}; cartesianChart1.AxisX.Add(ax); cartesianChart1.AxisY.Add(new Axis { LabelFormatter = value => value.ToString(), Separator = new Separator() }); } }
private void Form11_Load(object sender, EventArgs e) { using (StraatrovenEntities db = new StraatrovenEntities()) { var data = db.wrP(); PieSeries col = new PieSeries() { Title = "Rest", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries colO = new PieSeries() { Title = "Sneeuw", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries colT = new PieSeries() { Title = "IJsvorming", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries colTr = new PieSeries() { Title = "Regen", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries colF = new PieSeries() { Title = "Mist", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries colFi = new PieSeries() { Title = "Onweer", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; //Axis ax = new Axis() { Separator = new Separator() { Step = 1, IsEnabled = false } }; //ax.Labels = new List<string>(); //ax.LabelsRotation = 45; foreach (var a in data) { col.Values.Add(a.rest); colO.Values.Add(a.sneeuw); colT.Values.Add(a.ijsvorming); colTr.Values.Add(a.regen); colF.Values.Add(a.mist); colFi.Values.Add(a.onweer); //ax.Labels.Add(a.mnd.ToString()); } pieChart1.Series.Add(col); pieChart1.Series.Add(colO); pieChart1.Series.Add(colT); pieChart1.Series.Add(colTr); pieChart1.Series.Add(colF); pieChart1.Series.Add(colFi); pieChart1.LegendLocation = LegendLocation.Bottom; //cartesianChart1.AxisX.Add(ax); //cartesianChart1.AxisY.Add(new Axis //{ // LabelFormatter = value => value.ToString(), // Separator = new Separator() //}); } }
private void Form5_Load(object sender, EventArgs e) { using (StraatrovenEntities db = new StraatrovenEntities()) { var data = db.wzP(); //PieSeries Col = new PieSeries() { Title = "Werkzoekende totaal", DataLabels = true, Values = new ChartValues<int>(), LabelPoint = point => point.Y.ToString() }; PieSeries ColO = new PieSeries() { Title = "Werkzoekenden 15 t/m 24 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries ColT = new PieSeries() { Title = "Werkzoekenden 25 t/m 34 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries ColTr = new PieSeries() { Title = "Werkzoekenden 35 t/m 44 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries ColF = new PieSeries() { Title = "Werkzoekenden 45 t/m 54 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries ColFi = new PieSeries() { Title = "Werkzoekenden 55 t/m 65 jaar oud", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; PieSeries ColS = new PieSeries() { Title = "Totaal overvallen", DataLabels = true, Values = new ChartValues <int>(), LabelPoint = point => point.Y.ToString() }; //RowSeries ColSe = new RowSeries() { Title = "Werkzoekende 15 jaar oud", DataLabels = true, Values = new ChartValues<int>(), LabelPoint = point => point.Y.ToString() }; //RowSeries ColE = new RowSeries() { Title = "Werkzoekende 25 jaar oud", DataLabels = true, Values = new ChartValues<int>(), LabelPoint = point => point.Y.ToString() }; //RowSeries ColN = new RowSeries() { Title = "Werkzoekende 35 jaar oud", DataLabels = true, Values = new ChartValues<int>(), LabelPoint = point => point.Y.ToString() }; //RowSeries ColTe = new RowSeries() { Title = "Werkzoekende 45 jaar oud", DataLabels = true, Values = new ChartValues<int>(), LabelPoint = point => point.Y.ToString() }; //RowSeries ColEl = new RowSeries() { Title = "Werkzoekende 55 jaar oud", DataLabels = true, Values = new ChartValues<int>(), LabelPoint = point => point.Y.ToString() }; //RowSeries ColTw = new RowSeries() { Title = "Overvallen", DataLabels = true, Values = new ChartValues<int>(), LabelPoint = point => point.Y.ToString() }; //Axis ax = new Axis() { Separator = new Separator() { Step = 1, IsEnabled = false } }; //ax.Labels = new List<string>(); //ax.LabelsRotation = 45; //cartesianChart1.AxisY.Add(new Axis //{ // Labels = new[] { "werkzoekende 15", "werkzoekende 25", "werkzoekende 35", "werkzoekende 45", "werkzoekende 55"} //}); //cartesianChart1.AxisX.Add(new Axis //{ // LabelFormatter = value => value.ToString("N") //}); foreach (var x in data) { //Col.Values.Add(x.wzA); ColO.Values.Add(x.wz15); ColT.Values.Add(x.wz25); ColTr.Values.Add(x.wz35); ColF.Values.Add(x.wz45); ColFi.Values.Add(x.wz55); ColS.Values.Add(x.overvallen); //ColSe.Values.Add(x.wz15); //ColE.Values.Add(x.wz25); //ColN.Values.Add(x.wz35); //ColTe.Values.Add(x.wz45); //ColEl.Values.Add(x.wz55); //ColTw.Values.Add(x.overvallen); //ax.Labels.Add(x.bn); //ax.Labels.Add(x.bn); } //pieChart1.Series.Add(Col); pieChart1.Series.Add(ColO); pieChart1.Series.Add(ColT); pieChart1.Series.Add(ColTr); pieChart1.Series.Add(ColF); pieChart1.Series.Add(ColFi); pieChart1.Series.Add(ColS); pieChart1.LegendLocation = LegendLocation.Bottom; //cartesianChart1.Series.Add(ColSe); //cartesianChart1.Series.Add(ColE); //cartesianChart1.Series.Add(ColN); //cartesianChart1.Series.Add(ColTe); //cartesianChart1.Series.Add(ColEl); //cartesianChart1.Series.Add(ColTw); //cartesianChart1.LegendLocation = LegendLocation.Bottom; //pieChart1.Series = new SeriesCollection //{ // Col, // ColO, // ColT, // ColTr, // ColF, // ColFi, // ColS, //}; //cartesianChart1.AxisX.Add(ax); //cartesianChart1.AxisY.Add(new Axis //{ // LabelFormatter = value => value.ToString(), // Separator = new Separator() //}); } }