예제 #1
0
 private void ImportExcelFile_Click(object sender, EventArgs e)
 {
     if (dt.Rows.Count > 0)
     {
         int addedRows = 0;
         foreach (DataRow dr in dt.Rows)
         {
             if (!StudentExist(dr[0].ToString()))
             {
                 addedRows++;
                 Etudiant etudiant = new Etudiant();
                 etudiant.cne            = dr[0].ToString();
                 etudiant.nom            = dr[1].ToString();
                 etudiant.prenom         = dr[2].ToString();
                 etudiant.sexe           = Convert.ToChar(dr[3]);
                 etudiant.date_naissance = (DateTime)dr[4];
                 etudiant.adresse        = dr[5].ToString();
                 etudiant.tele           = dr[6].ToString();
                 etudiant.id_filiere     = Convert.ToInt32(dr[7]);
                 cl.Etudiant.InsertOnSubmit(etudiant);
                 cl.SubmitChanges();
             }
         }
         this.Hide();
         MessageBox.Show(addedRows + " étudiant été ajouté(s) et " + dt.Rows.Count + " déjà existe");
     }
     else
     {
         MessageBox.Show("Nothing To Import");
     }
 }
예제 #2
0
        private void listeCne_SelectedIndexChanged(object sender, EventArgs e)
        {
            Etudiant a = selectedEtudiant();

            cne.Text    = a.Cne.ToString();
            Nom.Text    = a.Nom;
            prenom.Text = a.Prenom;
            if (a.Sexe == 'F')
            {
                female.Checked = true;
            }
            else
            {
                male.Checked = true;
            }
            dateN.Text     = a.DateNaissance;
            adresse.Text   = a.Adresse;
            telephone.Text = a.Telephone;
            var fil = (from etd in db.etudiants
                       join f in db.Filieres on
                       etd.id_fil equals f.id_Filiere
                       where etd.id_fil == a.Filiere
                       select f);

            foreach (Filiere f in fil)
            {
                comboBox1.SelectedItem = f.nom_Filiere;
                break;
            }
        }
예제 #3
0
        public Etudiant selectedEtudiant()
        {
            int cneSelected = Convert.ToInt32(listeCne.SelectedItem.ToString());
            var etdSelected = (from etd in db.etudiants
                               where etd.cne == cneSelected
                               select etd).SingleOrDefault();
            etudiant e1      = etdSelected as etudiant;
            Etudiant student = 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(student);
        }
예제 #4
0
        void FillTextBox_Etudiant(Etudiant e)
        {
            cne_textBox.Text     = e.cne;
            nom_textbox.Text     = e.nom;
            prenom_textbox.Text  = e.prenom;
            adresse_textbox.Text = e.adresse;

            if (e.sexe == 'M')
            {
                male_radio.Checked = true;
            }
            else
            {
                female_radio.Checked = true;
            }
            tele_textbox.Text      = e.tele;
            date_naissance.Value   = (DateTime)e.date_naissance;
            choixFiliereCombo.Text = e.filiere.nom_filiere;
        }
예제 #5
0
        private void Ajouter_Click(object sender, EventArgs e)
        {
            var cne = cne_textBox.Text;
            var x   = from et in cl.Etudiant
                      where et.cne == cne
                      select et;

            if (x.Count() > 0)
            {
                MessageBox.Show("Le CNE existe déjà dans la base de données!");
                return;
            }


            if (female_radio.Checked)
            {
                choix = "M";
            }
            else
            {
                choix = "F";
            }
            var etu = new Etudiant();

            etu.cne            = cne;
            etu.nom            = nom_textbox.Text;
            etu.prenom         = prenom_textbox.Text;
            etu.adresse        = adresse_textbox.Text;
            etu.sexe           = choix[0];
            etu.date_naissance = date_naissance.Value;

            etu.tele = tele_textbox.Text;
            ComboBoxItem cnb = (ComboBoxItem)choixFiliereCombo.SelectedItem;

            etu.id_filiere = cnb.Value1;
            cl.Etudiant.InsertOnSubmit(etu);
            cl.SubmitChanges();
            MessageBox.Show("L'étudiant a été ajouté avec succès.");
            dataGridView1.Refresh();
            CleanTextBoxs();
        }
        public string AddStudent(string Cin, string Nom, string Prenom, string Email, string Tel, string NomFiliere)
        {
            var db          = new SQLiteConnection(dbPath);
            var newEtudiant = new Etudiant();

            newEtudiant.Cin = Cin;


            newEtudiant.Nom    = Nom;
            newEtudiant.Prenom = Prenom;
            newEtudiant.Email  = Email;
            newEtudiant.Tel    = Tel;

            //adding filiere
            var f = db.Query <Filiere>("SELECT * FROM Filiere WHERE NomFiliere = ?", NomFiliere);

            if (f.Count() == 0)
            {
                return("Cette filière n'existe pas");
            }
            else
            {
                newEtudiant.IdFiliere = f[0].IdFiliere;
            }
            //adding all infos in db
            var tables = db.Table <Etudiant>().FirstOrDefault(x => x.Cin == Cin);

            if (tables == null)
            {
                db.Insert(newEtudiant);
                return("Ajouté avec succès");
            }
            else
            {
                return("Déjà ajouté");
            }
        }
예제 #7
0
 private void detach_Etudiant(Etudiant entity)
 {
     this.SendPropertyChanging();
     entity.filiere = null;
 }
예제 #8
0
 private void attach_Etudiant(Etudiant entity)
 {
     this.SendPropertyChanging();
     entity.filiere = this;
 }
예제 #9
0
 partial void DeleteEtudiant(Etudiant instance);
예제 #10
0
 partial void UpdateEtudiant(Etudiant instance);
예제 #11
0
 partial void InsertEtudiant(Etudiant instance);