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();
}
}
public static void Insert(Employe emp, StatutCarriere stc)
{
Connecteur ct = new Connecteur();
if (ct.Connection.State == ConnectionState.Closed)
{
ct.Connection.Open();
}
//----Begin Transaction---
SqlTransaction trans = ct.Connection.BeginTransaction();
try
{
//Proceed Database Command-------------------------------------
SqlCommand employeCmd =
new SqlCommand(EmployeDAL.insertEmploye, ct.Connection, trans);
SqlCommand carriereCmd =
new SqlCommand(StatutCarriereDAL.InsertStatutCarriere, ct.Connection, trans);
//1 - INSERT Employe
//Employe Params - Insert
EmployeDAL.setEmployeParameters(employeCmd.Parameters, emp);
employeCmd.ExecuteNonQuery();
//2 - INSERT StatutCarriere
//StatutCarriere Params - Insert
StatutCarriereDAL.setStatutCarriereParameters(carriereCmd.Parameters, stc);
carriereCmd.ExecuteNonQuery();
//Commit Transaction
trans.Commit();
//-------------------------------------------------------------
}
catch (SqlException ex)
{
trans.Rollback();
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
public static void AjouterStatut(StatutCarriere stc)
{
Connecteur ct = new Connecteur();
//Proceed Database Command-------------------------------------
if (ct.Connection.State == ConnectionState.Closed)
{
ct.Connection.Open();
}
//----Begin Transaction---
SqlTransaction trans = ct.Connection.BeginTransaction();
SqlCommand ancienCarriereCmd =
new SqlCommand(StatutCarriereDAL.updateAncienStatut, ct.Connection, trans);
SqlCommand carriereCmd =
new SqlCommand(StatutCarriereDAL.insertStatutCarriere, ct.Connection, trans);
try
{
//1 - Update FinStatut de l'Ancien Statut
//Employe Params - Insert
ancienCarriereCmd.Parameters.AddWithValue("@CodeEmploye", stc.CodeEmploye);
ancienCarriereCmd.Parameters.AddWithValue("@FinStatut", stc.Debut);
ancienCarriereCmd.ExecuteNonQuery();
//2 - INSERT StatutCarriere
//StatutCarriere Params - Insert
StatutCarriereDAL.setStatutCarriereParameters(carriereCmd.Parameters, stc);
carriereCmd.ExecuteNonQuery();
//Commit Transaction
trans.Commit();
//-------------------------------------------------------------
}
catch (SqlException ex)
{
trans.Rollback();
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
public static int AnneeFiscaleActuelle()
{
Connecteur ct = new Connecteur();
try
{
ct.Connection.Open();
SqlDataAdapter dap = new SqlDataAdapter(CongeDAL.anneFiscaleActuelle, ct.Connection);
int annee = int.Parse(dap.SelectCommand.ExecuteScalar().ToString());
return(annee);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
public static DataTable AllPostes()
{
Connecteur ct = new Connecteur();
DataTable dt = new DataTable();
try
{
SqlDataAdapter dap = new SqlDataAdapter(DAL.selectPostes, ct.Connection);
ct.Connection.Open();
dap.Fill(dt);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
return(dt);
}
public static DataTable RechercherParCodeEtNom(string keyWords)
{
DataTable dt = new DataTable("Employe");
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter dae = new SqlDataAdapter(EmployeDAL.selectEmployeByCodeAndNom, ct.Connection);
dae.SelectCommand.Parameters.AddWithValue("@Name", "%" + keyWords + "%");
ct.Connection.Open();
dae.Fill(dt);
return(dt);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
