private void FormStatistics_Load(object sender, EventArgs e) { Services.FiliereService filiereService = new Services.FiliereService(); Services.EtudiantService etudiantService = new Services.EtudiantService(); Color[] colors = new Color[] { Color.Red, Color.Blue, Color.Green, Color.BlueViolet, Color.Orange, Color.Lime, }; DataTable dataFiliere = filiereService.getAll(); DataTable dataEtudiant = etudiantService.getAll(); Dictionary <String, int> nbEtudiantFiliere = new Dictionary <String, int>(); double nbTotalEtudiant = Convert.ToDouble(dataEtudiant.Rows.Count); for (int i = 0; i < dataFiliere.Rows.Count; i++) { nbEtudiantFiliere.Add(dataFiliere.Rows[i]["FiliereName"].ToString(), 0); } for (int i = 0; i < dataEtudiant.Rows.Count; i++) { int idFiliere = Convert.ToInt32(dataEtudiant.Rows[i]["ID_Filiere"]); String nomFiliere = dataFiliere.Rows[idFiliere - 1]["FiliereName"].ToString(); nbEtudiantFiliere[nomFiliere] += 1; } int k = 0; foreach (KeyValuePair <string, int> kvp in nbEtudiantFiliere) { this.chart1.Series["NombreEtudiant"].Points.AddXY(kvp.Key, kvp.Value); this.chart1.Series["NombreEtudiant"].Points[k].Label = Math.Round((kvp.Value / nbTotalEtudiant) * 100, 2) + "%"; this.chart1.Series["NombreEtudiant"].Points[k].Color = colors[k]; Legend legend = new Legend(); legend.Name = kvp.Key; legend.ForeColor = colors[k]; this.chart1.Legends.Add(legend); this.chart1.Legends[0].CustomItems.Add(colors[k], kvp.Key); k++; } }
void fillFiliereCombo() { comboBox12.DataSource = filiereService.getAll(); comboBox12.ValueMember = "ID_Filiere"; comboBox12.DisplayMember = "FiliereName"; }