public Etudiant selectedEtudiant() { int cneSelected = Convert.ToInt32(listeCne.SelectedItem.ToString()); var etdSelected = (from etd in cl.etudiants where etd.cne == cneSelected select etd).SingleOrDefault(); etudiant e1 = etdSelected as etudiant; Etudiant a = new Etudiant(e1.nom, e1.prenom, e1.date_naiss, e1.adresse, e1.telephone, e1.cne, Convert.ToInt32(e1.id_fil), Convert.ToChar(e1.sexe)); return(a); }
private void ajouter_Click(object sender, EventArgs e) { var x = (from etd in cl.etudiants where etd.cne == Convert.ToInt32(cne.Text) select etd).SingleOrDefault(); etudiant etdd = x as etudiant; if (etdd == null) { char sex = ' '; if (male.Checked) { sex = 'M'; } else { sex = 'F'; } Etudiant a = new Etudiant(Nom.Text, prenom.Text, dateN.Text, adresse.Text, telephone.Text, Convert.ToInt32(cne.Text), Convert.ToInt32(filiere.Text), sex); etudiant etd = new etudiant(); etd.cne = a.Cne; etd.date_naiss = a.DateNaissance; etd.adresse = a.Adresse; etd.sexe = a.Sexe; etd.nom = a.Nom; etd.prenom = a.Prenom; etd.id_fil = a.Filiere; etd.telephone = a.Telephone; cl.etudiants.InsertOnSubmit(etd); cl.SubmitChanges(); } else { MessageBox.Show("Etudiant existe dèja"); } }
partial void Deleteetudiant(etudiant instance);
partial void Updateetudiant(etudiant instance);
partial void Insertetudiant(etudiant instance);
private void detach_etudiants(etudiant entity) { this.SendPropertyChanging(); entity.Filiere = null; }
private void attach_etudiants(etudiant entity) { this.SendPropertyChanging(); entity.Filiere = this; }