private void Form1_Load(object sender, EventArgs e) { DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); var lesClasses = (from c in dc.classe select c).ToList(); foreach (var n in lesClasses) { comboBoxClasses.Items.Add(n); } }
private void buttonEnregistrer_Click(object sender, EventArgs e) { DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); noter laNote = comboBoxDevoir.SelectedItem as noter; if (laNote != null) { //laNote.note = textBoxNote.Text; //impossible de convertire string en double } dc.SubmitChanges(); }
private void buttonEnregistrer_Click(object sender, EventArgs e) { DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); eleve EleveSelectionne = listBoxClasses.SelectedItem as eleve; if (EleveSelectionne != null) { EleveSelectionne.nom = textBox1.Text; EleveSelectionne.prenom = textBox2.Text; EleveSelectionne.mail = textBox3.Text; EleveSelectionne.mdp = textBox4.Text; } dc.SubmitChanges(); }
private void listBoxEleve_SelectedIndexChanged(object sender, EventArgs e) { eleve EleveSelectionne = listBoxEleve.SelectedItem as eleve; DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); if (EleveSelectionne != null) { textBoxNom.Text = EleveSelectionne.nom; textBoxPrenom.Text = EleveSelectionne.prenom; comboBoxDevoir.Enabled = true; buttonEnregistrer.Enabled = true; textBoxNote.Enabled = true; textBoxNote.Text = " "; } }
private void listBoxClasses_SelectedIndexChanged(object sender, EventArgs e) { eleve EleveSelectionne = listBoxClasses.SelectedItem as eleve; DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); var lesNotes = (from n in dc.noter select n).ToList(); if (EleveSelectionne != null) { textBox1.Text = EleveSelectionne.nom; textBox2.Text = EleveSelectionne.prenom; textBox3.Text = EleveSelectionne.mail; textBox4.Text = EleveSelectionne.mdp; textBox5.Text = lesNotes.Average(m => m.note).ToString(); } }
private void Form2_Load_1(object sender, EventArgs e) { comboBoxDevoir.Enabled = false; listBoxEleve.Enabled = false; textBoxNom.Enabled = false; textBoxNote.Enabled = false; textBoxPrenom.Enabled = false; buttonEnregistrer.Enabled = false; DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); var lesClasses = (from c in dc.classe select c).ToList(); foreach (var n in lesClasses) { comboBoxClasse.Items.Add(n); } }
private void comboBoxMatiere_SelectedIndexChanged(object sender, EventArgs e) { matiere lesMatieres = comboBoxMatiere.SelectedItem as matiere; DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); var lesDevoirs = (from b in dc.devoir where b.id_matiere == lesMatieres.id_matiere select b).ToList(); listBoxEleve.Enabled = true; comboBoxDevoir.Items.Clear(); if (lesDevoirs != null) { foreach (var n in lesDevoirs) { comboBoxDevoir.Items.Add(n); } } }
private void comboBoxDevoir_SelectedIndexChanged(object sender, EventArgs e) { eleve EleveSelectionne = listBoxEleve.SelectedItem as eleve; devoir lesDevoirs = comboBoxDevoir.SelectedItem as devoir; DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); var laNote = (from b in dc.noter where b.id_devoir == lesDevoirs.id_devoir && b.id_eleve == EleveSelectionne.id_eleve select b).ToList(); textBoxNote.Text = " "; if (laNote != null) { foreach (var n in laNote) { textBoxNote.Text = n.note.ToString(); } } }
private void comboBoxClasse_SelectedIndexChanged(object sender, EventArgs e) { classe laClasse = comboBoxClasse.SelectedItem as classe; DataContextGestionNotesDataContext dc = new DataContextGestionNotesDataContext(); var lesMatieres = (from c in dc.matiere select c).ToList(); textBoxNote.Enabled = false; if (laClasse != null) { listBoxEleve.Items.Clear(); comboBoxMatiere.Items.Clear(); textBoxNom.Text = " "; textBoxPrenom.Text = " "; textBoxNote.Text = " "; if (laClasse.eleve.Count == 0) { MessageBox.Show("Pas d'élèves dans cette classe !"); } else { comboBoxDevoir.Enabled = false; foreach (var c in laClasse.eleve) { listBoxEleve.Items.Add(c); } foreach (var n in lesMatieres) { comboBoxMatiere.Items.Add(n); } } } }