public static Employe TrouverEmploye(string code)
{
Employe e = new Employe();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter dae = new SqlDataAdapter(EmployeDAL.selectOneEmploye, ct.Connection);
dae.SelectCommand.Parameters.AddWithValue("@CodeEmploye", code);
DataTable dt = new DataTable("Employe");
ct.Connection.Open();
dae.Fill(dt);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
EmployeDAL.Hydrate(e, dr);
}
return(e);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
public static List <Employe> All()
{
List <Employe> employeList = new List <Employe>();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter dap = new SqlDataAdapter(EmployeDAL.selectAllEmploye, ct.Connection);
DataTable dt = new DataTable("Employe");
ct.Connection.Open();
dap.Fill(dt);
Employe e;
foreach (DataRow dr in dt.Rows)
{
e = new Employe();
EmployeDAL.Hydrate(e, dr);
employeList.Add(e);
}
return(employeList);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}