public static Payroll CalculerPayroll()
{
DataTable dt = new DataTable("EmployeSalaire");
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter dae = new SqlDataAdapter(EmployeDAL.selectEmployeSalaire, ct.Connection);
ct.Connection.Open();
dae.Fill(dt);
Payroll payroll = new Payroll();
foreach (DataRow dr in dt.Rows)
{
payroll.AjouterPaiement(dr["CodeEmploye"].ToString(), dr["Nom"].ToString(),
dr["Prenom"].ToString(), double.Parse(dr["SalaireMensuelle"].ToString()));
}
return(payroll);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
