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);
}
