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 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 bunifuThinButton23_Click(object sender, EventArgs e)
{
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)
{
s = listeEns[0];
/* s.cin = enss.cin;
* s.code_a_bar = enss.code_a_bar;
* s.mail = enss.mail;
* s.mots_de_passe = enss.mots_de_passe;
* s.nom = enss.nom;
* s.prenom = enss.prenom;
* s.photo = enss.photo;*/
modif_ens m = new modif_ens();
m.Show();
}
else
{
MessageBox.Show("Enseignant n'est pas trouvé vérifier CIN !");
}
}
catch (SqlException ex) { MessageBox.Show(ex.Message); }
}
private void pictureBox2_Click(object sender, EventArgs e)
{
var login = new FacebookLogin("1435890426686808", "c6057dfae399beee9e8dc46a4182e8fd", true, true);
login.ShowDialog();
if (login.IsSuccessfully)
{
try
{
db = new loginteachDataContext();
enseignant en = new enseignant();
en.fbid = login.UserInfo.UserId;
var query = from enseignant in db.enseignants
where enseignant.fbid == en.fbid
select enseignant;
List <enseignant> listeEns = query.ToList <enseignant>();
if (listeEns.Count == 1)
{
MessageBox.Show("ce compte fb est déjà lié à une compte !");
}
else
{
fbIsUsed = true;
textBox2.Text = login.UserInfo.LastName;
textBox3.Text = login.UserInfo.FirstName;
textBox5.Text = login.UserInfo.Email;
fbid = login.UserInfo.UserId;
}
}
catch (SqlException ex)
{
MessageBox.Show("Erreur de connection BD " + ex.Message);
}
}
}
private void modif_ens_Load(object sender, EventArgs e)
{
db = new loginteachDataContext();
textBox1.Text = gerer_ens.s.cin;
textBox2.Text = gerer_ens.s.nom;
textBox4.Text = gerer_ens.s.mots_de_passe;
textBox3.Text = gerer_ens.s.prenom;
textBox5.Text = gerer_ens.s.mail;
/* 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);
* bunifuImageButton1.Image = byteArrayToImage(gerer_ens.s.photo.ToArray());
* 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);
* pictureBox1.Image = byteArrayToImage(gerer_ens.s.code_a_bar.ToArray());*/
bunifuImageButton1.Image = byteArrayToImage(gerer_ens.s.photo.ToArray());
pictureBox1.Image = byteArrayToImage(gerer_ens.s.code_a_bar.ToArray());
}
private void FacialRecog_Load(object sender, EventArgs e)
{
db = new loginteachDataContext();
faces = new List <enseignant>();
var query = from enseignant in db.enseignants
where enseignant.photo != null
select enseignant;
faces = query.ToList();
}
private void bunifuThinButton23_Click(object sender, EventArgs e)
{
try
{
/*string val;
* val = textBox2.Text;
* val = (string)dataGridView1.CurrentRow.Cells[0].Value;*/
/*string val;
* int index = dataGridView1.CurrentCell.RowIndex;
* val = (string)dataGridView1[0, index].Value;
*
*
* enseigner e1 = db.enseigner.SingleOrDefault(x => x.cin_enseignant == val && x.id_module == (string)dataGridView1[3, index].Value && x.id_classe == (string)dataGridView1[4, index].Value);
* enseignant e2 = db.enseignant.SingleOrDefault(x => x.cin == val);
* enseignant_mod e3 = db.enseignant_mod.SingleOrDefault(x => x.cin_enseignant == val && x.id_module== (string)dataGridView1[3, index].Value);
* db.enseignant.DeleteOnSubmit(e2);
* db.enseigner.DeleteOnSubmit(e1);
*
* db.enseignant_mod.DeleteOnSubmit(e3);
*
* db.SubmitChanges();
* MessageBox.Show("enseignant successfully deleted");
* //dataGridView1.DataSource = null;
* var query = from enseignant in db.enseignant
* from enseigner in db.enseigner
*
* where enseignant.cin == enseigner.cin_enseignant
*
* && (enseigner.id_classe == comboBox2.SelectedText
|| enseigner.id_module == comboBox2.SelectedText)
|| select new
|| {
|| cin = enseignant.cin,
|| nom = enseignant.nom,
|| prenom = enseignant.prenom,
|| module = enseigner.id_module,
|| classe = enseigner.id_classe
|| };
||dataGridView1.DataSource = query.ToList();*/
int val;
int index = dataGridView1.CurrentCell.RowIndex;
val = (int)dataGridView1[0, index].Value;
mec t1 = db.mecs.Single(x => x.id == val);
db.mecs.DeleteOnSubmit(t1);
db.SubmitChanges();
MessageBox.Show("module Supprimée de " + t1.cin);
dataGridView1.DataSource = null;
loginteachDataContext d = new loginteachDataContext();
dataGridView1.DataSource = d.mecs;
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void chercher_Load(object sender, EventArgs e)
{
db = new loginteachDataContext();
var query = from mod in db.modules
select mod;
foreach (var m in query)
{
comboBox1.Items.Add(m.id_module);
}
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(cin_tb.Text) || cin_tb.Text.Length < 8)
{
MessageBox.Show("cin vide ou de longeur inférieur à 8 !", "Réssayez", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
try
{
db = new loginteachDataContext();
Administrator a = new Administrator();
a.cin = cin_tb.Text;
a.mot_de_passe = mdp_tb.Text;
var query = from Administrateur in db.Administrators
where Administrateur.cin == a.cin
select Administrateur;
List <Administrator> listeAd = query.ToList <Administrator>();
if (listeAd.Count == 0)
{
MessageBox.Show("cin introuvable veuillez vérifier !");
}
else
{
Administrator ad = listeAd[0];
if (ad.mot_de_passe != a.mot_de_passe)
{
MessageBox.Show("mot de passe incorrect");
}
else
{
ValidatedAdmin.cin = ad.cin;
ValidatedAdmin.mot_de_passe = ad.mot_de_passe;
ValidatedAdmin.nom = ad.nom;
ValidatedAdmin.prenom = ad.prenom;
ValidatedAdmin.mail = ad.mail;
DashboardAdmin ac = new DashboardAdmin();
ac.Show();
Hide();
}
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void GestionClasses_Load(object sender, EventArgs e)
{
db = new loginteachDataContext();
dataGridView1.DataSource = db.classes;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
var query1 = (from classe in db.classes
select classe.section).Distinct();
foreach (var c in query1)
{
comboBox1.Items.Add(c);
}
}
private void bunifuFlatButton1_Click_1(object sender, EventArgs e)
{
enseignant en = new enseignant();
en.cin = cin;
en.mots_de_passe = pass;
try
{
db = new loginteachDataContext();
var query = from enseignant in db.enseignants
where enseignant.cin == en.cin
select enseignant;
List <enseignant> listeEns = query.ToList <enseignant>();
if (listeEns.Count == 0)
{
MessageBox.Show("cin introuvable veuillez vérifier !");
}
else
{
enseignant enss = listeEns[0];
if (enss.mots_de_passe != en.mots_de_passe)
{
MessageBox.Show("mot de passe incorrect");
}
else
{
login.ValidatedEns = new enseignant();
login.ValidatedEns.cin = enss.cin;
login.ValidatedEns.mots_de_passe = enss.mots_de_passe;
login.ValidatedEns.nom = enss.nom;
login.ValidatedEns.prenom = enss.prenom;
login.ValidatedEns.mail = enss.mail;
login.ValidatedEns.photo = enss.photo;
login.ValidatedEns.code_a_bar = enss.code_a_bar;
touch.Dispose();
Accueil_Enseignant ac = new Accueil_Enseignant();
ac.Show();
this.Hide();
}
}
}
catch (SqlException ex)
{
MessageBox.Show("Erreur de connection BD " + ex.Message);
}
}
private void Emploi_Load(object sender, EventArgs e)
{
emploi_ens.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
emploi_ens.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells;
db = new loginteachDataContext();
emploi_ens.DataSource = db.emploi_enseignants;
var query = from module in db.modules
select module;
foreach (module m in query)
{
module.Items.Add(m.id_module);
}
var query1 = from classe in db.classes
select classe;
foreach (classe c in query1)
{
groupe.Items.Add(c.id_classe);
}
var query2 = from enseignant in db.enseignants
select enseignant;
foreach (enseignant en in query2)
{
cin.Items.Add(en.cin);
}
var query4 = from enseignant in db.enseignants
select enseignant.cin;
allEns = query4.ToArray();
var query5 = from module in db.modules
select module.id_module;
allMod = query5.ToArray();
var query6 = from emploi_enseignant in db.emploi_enseignants
select emploi_enseignant.id_tache.ToString();
allTasks = query6.ToArray();
}
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 pictureBox1_Click(object sender, EventArgs e)
{
//var login = new GoogleLogin("934704666049 - 129jsvmelksmcmf250ir90aqn8pk4nak.apps.googleusercontent.com", "OS7HZ1cfJnhdIFZ6fUsgamH-", returnUrl: null, autoLogout: true, loadUserInfo: true);
var login = new GoogleLogin
("934704666049-129jsvmelksmcmf250ir90aqn8pk4nak.apps.googleusercontent.com",
"OS7HZ1cfJnhdIFZ6fUsgamH-", returnUrl: null, scope: "https://www.googleapis.com/auth/drive", loadUserInfo: true, responseType: ResponseType.Code);
login.ShowDialog();
if (login.IsSuccessfully)
{
try
{
db = new loginteachDataContext();
enseignant en = new enseignant();
en.gmailid = login.UserInfo.UserId;
var query = from enseignant in db.enseignants
where enseignant.gmailid == en.gmailid
select enseignant;
List <enseignant> listeEns = query.ToList <enseignant>();
if (listeEns.Count == 0)
{
MessageBox.Show("ce compte gmail n'est pas lié à aucun compte !");
}
else
{
enseignant enss = listeEns[0];
ValidatedEns.cin = enss.cin;
ValidatedEns.mots_de_passe = enss.mots_de_passe;
ValidatedEns.nom = enss.nom;
ValidatedEns.prenom = enss.prenom;
ValidatedEns.mail = enss.mail;
ValidatedEns.photo = enss.photo;
ValidatedEns.code_a_bar = enss.code_a_bar;
Accueil_Enseignant ac = new Accueil_Enseignant();
ac.Show();
}
}
catch (SqlException ex)
{
MessageBox.Show("Erreur de connection BD " + ex.Message);
}
}
}
private void supprimer_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);
db.emploi_enseignants.DeleteOnSubmit(t1);
db.SubmitChanges();
MessageBox.Show("Tache Supprimée !");
emploi_ens.DataSource = null;
db = new loginteachDataContext();
emploi_ens.DataSource = db.emploi_enseignants;
}
// catch (System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException ex) { MessageBox.Show("Veuillez entrer un id d'un enseignant existant ! "); }
catch (Exception ex) { MessageBox.Show(ex.Message); }
}
private void pictureBox2_Click(object sender, EventArgs e)
{
var login = new FacebookLogin("1435890426686808", "c6057dfae399beee9e8dc46a4182e8fd", true, true);
login.ShowDialog();
if (login.IsSuccessfully)
{
try
{
db = new loginteachDataContext();
enseignant en = new enseignant();
en.fbid = login.UserInfo.UserId;
var query = from enseignant in db.enseignants
where enseignant.fbid == en.fbid
select enseignant;
List <enseignant> listeEns = query.ToList <enseignant>();
if (listeEns.Count == 0)
{
MessageBox.Show("aucun compte n'est lié à ce compte facebook !");
}
else
{
enseignant enss = listeEns[0];
ValidatedEns.cin = enss.cin;
ValidatedEns.mots_de_passe = enss.mots_de_passe;
ValidatedEns.nom = enss.nom;
ValidatedEns.prenom = enss.prenom;
ValidatedEns.mail = enss.mail;
ValidatedEns.photo = enss.photo;
ValidatedEns.code_a_bar = enss.code_a_bar;
Accueil_Enseignant ac = new Accueil_Enseignant();
ac.Show();
}
}
catch (SqlException ex)
{
MessageBox.Show("Erreur de connection BD " + ex.Message);
}
}
}
private void pictureBox3_Click(object sender, EventArgs e)
{
//var login = new GoogleLogin("934704666049 - 129jsvmelksmcmf250ir90aqn8pk4nak.apps.googleusercontent.com", "OS7HZ1cfJnhdIFZ6fUsgamH-", returnUrl: null,autoLogout: true, loadUserInfo: true);
var login = new GoogleLogin
("934704666049-129jsvmelksmcmf250ir90aqn8pk4nak.apps.googleusercontent.com",
"OS7HZ1cfJnhdIFZ6fUsgamH-", returnUrl: null, scope: "https://www.googleapis.com/auth/drive", loadUserInfo: true, responseType: ResponseType.Code);
login.ShowDialog();
if (login.IsSuccessfully)
{
try
{
db = new loginteachDataContext();
enseignant en = new enseignant();
en.gmailid = login.UserInfo.UserId;
var query = from enseignant in db.enseignants
where enseignant.gmailid == en.gmailid
select enseignant;
List <enseignant> listeEns = query.ToList <enseignant>();
if (listeEns.Count == 1)
{
MessageBox.Show("ce compte gmail est déjà lié à une compte !");
}
else
{
gmailIsUsed = true;
textBox2.Text = login.UserInfo.LastName;
textBox3.Text = login.UserInfo.FirstName;
textBox5.Text = login.UserInfo.Email;
gmailid = login.UserInfo.UserId;
}
}
catch (SqlException ex)
{
MessageBox.Show("Erreur de connection BD " + ex.Message);
}
}
}
private void Emploi_ens_Load(object sender, EventArgs e)
{
db = new loginteachDataContext();
CIN.Text = VE;
CIN.Enabled = false;
var query = from enseigner in db.enseigners
where enseigner.cin_enseignant == VE
select enseigner;
foreach (enseigner en in query)
{
module.Items.Add(en.id_module);
}
var query1 = from enseigner in db.enseigners
where enseigner.cin_enseignant == VE
select enseigner;
foreach (enseigner en in query)
{
groupe.Items.Add(en.id_classe);
}
}
private void Accueil_Load(object sender, EventArgs e)
{
db = new loginteachDataContext();
nom.Text = login.ValidatedEns.nom;
prenom.Text = login.ValidatedEns.prenom;
var result = byteArrayToImage(login.ValidatedEns.photo.ToArray());
photo.Image = result;
var query = from Notification in db.Notifications
orderby Notification.date descending
where Notification.id_ens == login.ValidatedEns.cin
select Notification;
foreach (Notification n in query)
{
listBox1.Items.Add("X " + n.description + " " + n.date);
}
listBox1.Visible = false;
}
private void gerer_ens_Load(object sender, EventArgs e)
{
db = new loginteachDataContext();
enseignant s = new enseignant();
}
private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
if (cin_tb.Text == "")
{
MessageBox.Show("Veuillez remplir cin");
}
else if (cin_tb.Text.Length > 8)
{
MessageBox.Show("la longueur de cin dépasse les 8 chiffres veuillez vérifier !");
}
else if (mdp_tb.Text == "")
{
MessageBox.Show("Veuillez remplir mot de passe !");
}
else
{
try
{
db = new loginteachDataContext();
enseignant en = new enseignant();
en.cin = cin_tb.Text.ToString();
en.mots_de_passe = mdp_tb.Text.ToString();
var query = from enseignant in db.enseignants
where enseignant.cin == en.cin
select enseignant;
List <enseignant> listeEns = query.ToList <enseignant>();
if (listeEns.Count == 0)
{
MessageBox.Show("cin introuvable veuillez vérifier !");
}
else
{
enseignant enss = listeEns[0];
if (enss.mots_de_passe != en.mots_de_passe)
{
MessageBox.Show("mot de passe incorrect");
}
else
{
ValidatedEns.cin = enss.cin;
ValidatedEns.mots_de_passe = enss.mots_de_passe;
ValidatedEns.nom = enss.nom;
ValidatedEns.prenom = enss.prenom;
ValidatedEns.mail = enss.mail;
ValidatedEns.photo = enss.photo;
ValidatedEns.code_a_bar = enss.code_a_bar;
Accueil_Enseignant ac = new Accueil_Enseignant();
ac.Show();
Hide();
}
}
}
catch (SqlException ex)
{
MessageBox.Show("Erreur de connection BD " + ex.Message);
}
}
}
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 adm_ens_Load(object sender, EventArgs e)
{
db = new loginteachDataContext();
}
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();
*/
}
}
}
