public static DataTable RapportPresence(RapportGlobal rg, int annee, int mois = 0, int jour = 0)
{
DataTable dt = new DataTable();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter da = new SqlDataAdapter();;
if (rg == RapportGlobal.RetardAnnee)
{
da = new SqlDataAdapter(EmployeDAL.selectRetardAnnuel, ct.Connection);
da.SelectCommand.Parameters.AddWithValue("@annee", annee);
}
if (rg == RapportGlobal.AbsenceAnnee)
{
da = new SqlDataAdapter(EmployeDAL.selectAbsenceAnnuelle, ct.Connection);
da.SelectCommand.Parameters.AddWithValue("@annee", annee);
}
if (rg == RapportGlobal.PresenceMois & mois > 0)
{
da = new SqlDataAdapter(EmployeDAL.selectPresenceMensuelle, ct.Connection);
da.SelectCommand.Parameters.AddWithValue("@annee", annee);
da.SelectCommand.Parameters.AddWithValue("@mois", mois);
}
if (rg == RapportGlobal.PresenceJour & jour > 0)
{
da = new SqlDataAdapter(EmployeDAL.selectPresenceJournaliere, ct.Connection);
DateTime date = DateTime.Parse(mois + "-" + jour + "-" + annee);
da.SelectCommand.Parameters.AddWithValue("@date", date);
}
dt = new DataTable();
ct.Connection.Open();
if (da.SelectCommand.CommandText.Length > 0)
{
da.Fill(dt);
}
return(dt);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
public static DataTable Rapport(RapportGlobal rg)
{
DataTable dt = new DataTable();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter da = new SqlDataAdapter();;
if (rg == RapportGlobal.EmployeAvecStatut)
{
da = new SqlDataAdapter(EmployeDAL.selectEmployeWithStatut, ct.Connection);
}
else if (rg == RapportGlobal.ComptageEmployeParDepartement)
{
da = new SqlDataAdapter(EmployeDAL.selectComptageEmployeParDepartement, ct.Connection);
}
else if (rg == RapportGlobal.ContactEmploye)
{
da = new SqlDataAdapter(EmployeDAL.selectContactEmploye, ct.Connection);
}
else if (rg == RapportGlobal.Emplois)
{
da = new SqlDataAdapter(EmployeDAL.selectEmplois, ct.Connection);
}
else if (rg == RapportGlobal.EmployesEnConge)
{
da = new SqlDataAdapter(EmployeDAL.selectEmployesEnConge, ct.Connection);
}
else if (rg == RapportGlobal.AnniversaireProche)
{
da = new SqlDataAdapter(EmployeDAL.selectAnniversaireProche, ct.Connection);
}
dt = new DataTable();
ct.Connection.Open();
if (da.SelectCommand.CommandText.Length > 0)
{
da.Fill(dt);
}
return(dt);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
