public static List <Employe> Employes()
{
List <Employe> AllEmployes = new List <Employe>();
try
{
DbConnect db = new DbConnect();
db.Command.CommandText = "GetAllEmploye";
MySqlDataReader reader = db.Command.ExecuteReader();
while (reader.Read())
{
Employe employe = new Employe();
if (reader.IsDBNull(0))
{
employe.Matr = -1;
}
else
{
employe.Matr = (int)reader["Matr"];
}
if (reader.IsDBNull(1))
{
employe.NomE = null;
}
else
{
employe.NomE = (string)reader["NomE"];
}
if (reader.IsDBNull(2))
{
employe.Poste = null;
}
else
{
employe.Poste = (string)reader["Poste"];
}
if (reader.IsDBNull(3))
{
employe.DateEmb = null;
}
else
{
employe.DateEmb = (string)reader["DateEmb"];
}
if (reader.IsDBNull(4))
{
employe.Emp_Sup = new Employe();
}
else
{
employe.Emp_Sup = new Employe();
employe.Emp_Sup = GetEmploye((int)reader["Sup"]);
}
if (reader.IsDBNull(5))
{
employe.Salaire = 0;
}
else
{
employe.Salaire = (int)reader["Salaire"];
}
if (reader.IsDBNull(6))
{
employe.Comm = 0;
}
else
{
employe.Comm = (int)reader["Comm"];
}
if (reader.IsDBNull(7))
{
employe._Departement = null;
}
else
{
employe._Departement = new Departement();
employe._Departement = Departement.GetDepartement((int)reader["NumDept"]);
}
AllEmployes.Add(employe);
}
db.Connection.Close();
}
catch (MySqlException ex)
{
Console.WriteLine($"MyError :{ex.ToString()}");
}
return(AllEmployes);
}
public static Employe GetEmploye(int id)
{
Employe employe = new Employe();
try
{
DbConnect db = new DbConnect();
db.Command.CommandText = "GetOneEmploye";
db.Command.Parameters.AddWithValue("_Matr", id);
MySqlDataReader reader = db.Command.ExecuteReader();
reader.Read();
if (reader.IsDBNull(0))
{
employe.Matr = -1;
}
else
{
employe.Matr = (int)reader["Matr"];
}
if (reader.IsDBNull(1))
{
employe.NomE = null;
}
else
{
employe.NomE = (string)reader["NomE"];
}
if (reader.IsDBNull(2))
{
employe.Poste = null;
}
else
{
employe.Poste = (string)reader["Poste"];
}
if (reader.IsDBNull(3))
{
employe.DateEmb = null;
}
else
{
employe.DateEmb = (string)reader["DateEmb"];
}
if (reader.IsDBNull(4))
{
employe.Emp_Sup = new Employe();
}
else
{
employe.Emp_Sup = new Employe();
employe.Emp_Sup = GetEmploye((int)reader["Sup"]);
}
if (reader.IsDBNull(5))
{
employe.Salaire = 0;
}
else
{
employe.Salaire = (int)reader["Salaire"];
}
if (reader.IsDBNull(6))
{
employe.Comm = 0;
}
else
{
employe.Comm = (int)reader["Comm"];
}
if (reader.IsDBNull(7))
{
employe._Departement = null;
}
else
{
employe._Departement = new Departement();
employe._Departement = Departement.GetDepartement((int)reader["NumDept"]);
}
db.Connection.Close();
}
catch
{
}
return(employe);
}