public bool CreeCompte(Ensignant e) { MySqlConnection connexion = new MySqlConnection("database=bibliotheque; server=localhost; user id=root; pwd=1898;"); bool res = false; List <Ensignant> test = ListEnsignant(); for (int i = 0; i < test.Count; i++) { if (test[i].Matricule.Equals(e.Matricule)) { return(false); } } DateTime d = DateTime.Now; try { connexion.Open(); MySqlCommand sql1 = new MySqlCommand("insert into emprenteur (matricule,type,nom,prenom,password,grade,sanction) values('" + e.Matricule + "','ensignant','" + e.Nom + "','" + e.Prenom + "','" + e.Password + "','" + e.Grade + "','" + d.Year + "-" + d.Month + "-" + d.Day + "')", connexion); MySqlDataReader rd1; rd1 = sql1.ExecuteReader(); connexion.Close(); res = true; } catch { Console.WriteLine("erreuer"); } return(res); }
public List <Ensignant> ListEnsignant() { List <Ensignant> ensignant = new List <Ensignant>(); MySqlConnection connexion = new MySqlConnection("database=bibliotheque; server=localhost; user id=root; pwd=1898;"); try { connexion.Open(); MySqlCommand sqlet = new MySqlCommand("select * from emprenteur where type='ensignant' ", connexion); MySqlDataReader rd; rd = sqlet.ExecuteReader(); while (rd.Read()) { Ensignant e = new Ensignant(); e.Matricule = rd["matricule"].ToString(); e.Nom = rd["nom"].ToString(); e.Prenom = rd["prenom"].ToString(); e.Password = rd["password"].ToString(); e.Sanction = Convert.ToDateTime(rd["sanction"]); e.EtatSanction = Convert.ToBoolean(rd["etatsanction"]); e.EtatCompte = Convert.ToBoolean(rd["etatcompte"]); e.NbNonReserve = int.Parse(rd["nonConfirme"].ToString()); e.Grade = rd["grade"].ToString(); ensignant.Add(e); } connexion.Close(); } catch (MySqlException e) { } return(ensignant); }
public bool Connexion(Ensignant e) { bool res = false; List <Ensignant> test = ListEnsignant(); for (int i = 0; i < test.Count; i++) { if (test[i].Matricule.Equals(e.Matricule)) { if (test[i].Password.Equals(e.Password)) { return(true); } else { return(false); } } } return(res); }
public bool ConfirmerCompte(Ensignant e) { MySqlConnection connexion = new MySqlConnection("database=bibliotheque; server=localhost; user id=root; pwd=1898;"); bool res = false; List <Ensignant> test = ListEnsignant(); for (int i = 0; i < test.Count; i++) { if (test[i].Matricule.Equals(e.Matricule)) { if (test[i].EtatCompte == false) { try { connexion.Open(); MySqlCommand sql1 = new MySqlCommand("update emprenteur set etatcompte=1 where matricule='" + e.Matricule + "' ", connexion); MySqlDataReader rd1; rd1 = sql1.ExecuteReader(); connexion.Close(); return(true); } catch { Console.WriteLine("erreuer"); } } else { return(false); } } } return(res); }