public void ChargerDiplome()
{
MySqlDataReader data;
MySqlCommand cmsql = new MySqlCommand();
cmsql.Connection = cnx;
cmsql.CommandText = "diplome";
cmsql.CommandType = CommandType.TableDirect;
cmsql.Connection.Open();
data = cmsql.ExecuteReader();
while (data.Read())
{
Diplome d = new Diplome((int)data[0], (string)data[1]);
lesDiplomes.Add(d);
}
cnx.Close();
}
public void ChargerDiplomes()
{
MySqlConnection cnx = ConnexionBDD();
cnx.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = cnx;
cmd.CommandText = "diplome";
cmd.CommandType = CommandType.TableDirect;
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Diplome dm = new Diplome((int)reader[0], (string)reader[1]);
LesDiplomes.Add(dm);
}
cnx.Close();
}
public void LesDiplomeEmployeAdd(Diplome diplome)
{
lesDiplomes.Add(diplome);
}
public void AddDiplomeEmploye(Diplome d)
{
lesDiplomes.Add(d);
}
