private void modifier_Click(object sender, EventArgs e) { try { int val; int index = emploi_ens.CurrentCell.RowIndex; val = (int)emploi_ens[0, index].Value; emploi_enseignant t1 = db.emploi_enseignants.Single(x => x.id_tache == val); t1.id_tache = (int)emploi_ens[0, index].Value; var query = from emploi_enseignant in db.emploi_enseignants where emploi_enseignant.id_tache == t1.id_tache select emploi_enseignant; foreach (emploi_enseignant emp in query) { emp.type = (string)emploi_ens[1, index].Value; emp.date = (DateTime)emploi_ens[2, index].Value; emp.heure_deb = (string)emploi_ens[3, index].Value; emp.heure_fin = (string)emploi_ens[4, index].Value; emp.salle = (string)emploi_ens[5, index].Value; emp.id_ens = (string)emploi_ens[6, index].Value; } // modifier une notification après chaque modification d'une tache existante Notification n = new Notification(); var query2 = from Notification in db.Notifications select Notification; foreach (Notification not in query2) { not.description = (string)emploi_ens[1, index].Value + " (a été modifiée !!)"; not.date = (DateTime)emploi_ens[2, index].Value; } db.SubmitChanges(); MessageBox.Show("Tache et notification Modifiées !"); emploi_ens.DataSource = null; emploi_ens.DataSource = db.emploi_enseignants; } catch (SqlException ex) { MessageBox.Show("ID enseignant est non compatible "); } }
private void bunifuThinButton21_Click(object sender, EventArgs e) { try { db = new loginteachDataContext(); int val; int index = dataGridView1.CurrentCell.RowIndex; val = (int)dataGridView1[0, index].Value; mec t1 = new mec(); t1.id = (int)dataGridView1[0, index].Value; t1.cin = (string)dataGridView1[1, index].Value; t1.module = (string)dataGridView1[2, index].Value; t1.classe = (int)dataGridView1[3, index].Value; if (t1 == null) { MessageBox.Show("veuillez saisir les champs"); } else { db.mecs.InsertOnSubmit(t1); db.SubmitChanges(); MessageBox.Show("Module affecté à " + t1.cin); dataGridView1.DataSource = null; dataGridView1.DataSource = db.mecs; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void ajouter_Click(object sender, EventArgs e) { try { db = new loginteachDataContext(); int val; int index = emploi_ens.CurrentCell.RowIndex; val = (int)emploi_ens[0, index].Value; emploi_enseignant t1 = new emploi_enseignant(); t1.id_tache = (int)emploi_ens[0, index].Value; t1.type = (string)emploi_ens[1, index].Value; t1.date = (DateTime)emploi_ens[2, index].Value; t1.heure_deb = (string)emploi_ens[3, index].Value; t1.heure_fin = (string)emploi_ens[4, index].Value; t1.salle = (string)emploi_ens[5, index].Value; t1.id_ens = (string)emploi_ens[6, index].Value; db.emploi_enseignants.InsertOnSubmit(t1); // ajouter une notification après chaque insertion d'une nouvelle tache Notification n = new Notification(); n.description = (string)emploi_ens[1, index].Value + " ( Nouvelle !!!) "; n.date = (DateTime)emploi_ens[2, index].Value; n.id_ens = (string)emploi_ens[6, index].Value; db.Notifications.InsertOnSubmit(n); db.SubmitChanges(); MessageBox.Show("Tache et notification ajoutées"); emploi_ens.DataSource = null; emploi_ens.DataSource = db.emploi_enseignants; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bunifuThinButton22_Click(object sender, EventArgs e) { try { string val = (string)textBox1.Text; /*mec t2 = db.mec.Single(x => x.cin == val); * if (t2 != null) * db.mec.DeleteOnSubmit(t2);*/ var query = from enseignant in db.enseignants where enseignant.cin == val select enseignant; List <enseignant> ListeEns = query.ToList(); if (ListeEns.Count == 0) { MessageBox.Show("Enseignant n'est pas trouvé vérifier CIN !"); } else { enseignant sup = ListeEns[0]; db.enseignants.DeleteOnSubmit(sup); db.SubmitChanges(); MessageBox.Show("Enseignant supprimé!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bunifuThinButton22_Click(object sender, EventArgs e) { try { int val; int index = dataGridView1.CurrentCell.RowIndex; val = (int)dataGridView1[0, index].Value; classe t1 = db.classes.Single(x => x.id_classe == val); db.classes.DeleteOnSubmit(t1); db.SubmitChanges(); MessageBox.Show("Classe Supprimé !"); dataGridView1.DataSource = null; db = new loginteachDataContext(); dataGridView1.DataSource = db.classes; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bunifuThinButton22_Click(object sender, EventArgs e) { int val; int index = dataGridView1.CurrentCell.RowIndex; string cin = ""; if (index < 0) { MessageBox.Show("selectionnez une ligne svp!"); } else { val = (int)dataGridView1[0, index].Value; mec t1 = db.mecs.Single(x => x.id == val); t1.id = (int)dataGridView1[0, index].Value; var query = from mec in db.mecs where mec.id == t1.id select mec; foreach (mec emp in query) { //emp.cin_enseignant = (string)dataGridView1[0, index].Value; emp.cin = (string)dataGridView1[1, index].Value; cin = emp.cin; emp.module = (string)dataGridView1[2, index].Value; emp.classe = (int)dataGridView1[3, index].Value; //emp.classe = (string)dataGridView1[4, index].Value; } db.SubmitChanges(); MessageBox.Show(text: "Module Modifiée pour " + cin); dataGridView1.DataSource = null; dataGridView1.DataSource = db.mecs; } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { allgood = true; foreach (Control c in panel1.Controls) { if (c is TextBox) { if (c.Text.Length == 0) { MessageBox.Show("veuillez remplir tout les champs !"); c.Focus(); allgood = false; break; } else if (c == textBox1 && textBox1.Text.Length < 8) { MessageBox.Show("cin doit être composé de 8 chiffres !", "erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); allgood = false; } } } if (allgood) { bool emailverif = true; try { var m = new System.Net.Mail.MailAddress(textBox5.Text); } catch (System.FormatException f) { MessageBox.Show("email incorrect !"); emailverif = false; } if (emailverif) { if (gerer_ens.s.mots_de_passe != textBox4.Text && qrgenerated == false) { MessageBox.Show("générer votre QR code svp !", "erreur", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { try { db = new loginteachDataContext(); enseignant ens = new enseignant(); ens.cin = textBox1.Text; var query = from enseignant in db.enseignants where enseignant.cin == ens.cin select enseignant; List <enseignant> listeEns = query.ToList <enseignant>(); foreach (enseignant ex in query) { ex.nom = textBox2.Text; ex.prenom = textBox3.Text; ex.mots_de_passe = textBox4.Text; ex.mail = textBox5.Text; MemoryStream ms = new MemoryStream(); bunifuImageButton1.Image.Save(ms, ImageFormat.Jpeg); byte[] pic_array = new byte[ms.Length]; ms.Position = 0; ms.Read(pic_array, 0, pic_array.Length); ex.photo = pic_array; MemoryStream mss = new MemoryStream(); pictureBox1.Image.Save(mss, ImageFormat.Bmp); byte[] qr_array = new byte[mss.Length]; mss.Position = 0; mss.Read(qr_array, 0, qr_array.Length); ex.code_a_bar = qr_array; } db.SubmitChanges(); // len = ens.photo.ToString().Length; MessageBox.Show("modification réussite !"); } catch (Exception exx) { MessageBox.Show(text: "erreur d'insertion " + exx.Message, caption: "Erreur", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); } } } } }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { allgood = true; foreach (Control c in panel1.Controls) { if (c is TextBox) { if (c.Text.Length == 0) { MessageBox.Show("veuillez remplir tout les champs !"); c.Focus(); allgood = false; break; } else if (c == textBox1 && textBox1.Text.Length < 8) { MessageBox.Show("cin doit être composé de 8 chiffres !", "erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); allgood = false; } } } if (allgood) { bool emailverif = true; try { var m = new System.Net.Mail.MailAddress(textBox5.Text); } catch (System.FormatException f) { MessageBox.Show("email incorrect !"); emailverif = false; } if (emailverif) { if (picturechanged == false && pictureBox1.Image == null) { MessageBox.Show("insérer votre image et votre QR code svp !", "erreur", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (picturechanged == false) { MessageBox.Show("insérer votre image svp !", "erreur", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (pictureBox1.Image == null) { MessageBox.Show("générer votre QR code svp !", "erreur", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { try { db = new loginteachDataContext(); enseignant ens = new enseignant(); ens.cin = textBox1.Text; var query = from enseignant in db.enseignants where enseignant.cin == ens.cin select enseignant; List <enseignant> listeEns = query.ToList <enseignant>(); if (listeEns.Count != 0) { MessageBox.Show("vous êtes déjà inscrit !"); } else { ens.mail = textBox5.Text; ens.mots_de_passe = textBox4.Text; ens.nom = textBox2.Text; ens.prenom = textBox3.Text; MemoryStream ms = new MemoryStream(); photo.Image.Save(ms, ImageFormat.Jpeg); byte[] pic_array = new byte[ms.Length]; ms.Position = 0; ms.Read(pic_array, 0, pic_array.Length); ens.photo = pic_array; MemoryStream mss = new MemoryStream(); pictureBox1.Image.Save(mss, ImageFormat.Bmp); byte[] qr_array = new byte[mss.Length]; mss.Position = 0; mss.Read(qr_array, 0, qr_array.Length); ens.code_a_bar = qr_array; if (fbIsUsed) //si facebook est utilisé dans l'inscription { ens.fbid = fbid; } if (gmailIsUsed) { ens.gmailid = gmailid; } db.enseignants.InsertOnSubmit(ens); db.SubmitChanges(); // len = ens.photo.ToString().Length; MessageBox.Show("inscription réussite !"); } } catch (Exception exx) { MessageBox.Show(text: "erreur d'insertion " + exx.Message, caption: "Erreur", buttons: MessageBoxButtons.OK, icon: MessageBoxIcon.Error); } } //MessageBox.Show(len.ToString()); /* * var optionss = new ZXing.Common.EncodingOptions * { * PureBarcode = true, * Height = 30, * Width = 100, * }; * * var writerr = new BarcodeWriter(); * writerr.Format = BarcodeFormat.CODE_128; * writerr.Options = optionss; * var qrr = new BarcodeWriter(); * qrr.Options = optionss; * qrr.Format = ZXing.BarcodeFormat.CODE_128; * var resultt = new Bitmap(qrr.Write(textBox1.Text.Trim())); * pictureBox2.Image = resultt; * * var reader = new BarcodeReader(); * var x=reader.Decode(resultt); * textBox6.Text= x.ToString(); */ } } }