public static Poste GetPoste(int code_poste)
{
Poste d = new Poste();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter dae = new SqlDataAdapter(StatutCarriereDAL.selectPoste, ct.Connection);
dae.SelectCommand.Parameters.AddWithValue("@CodePoste", code_poste);
DataTable dt = new DataTable("Poste");
ct.Connection.Open();
dae.Fill(dt);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
StatutCarriereDAL.Hydrate(d, dr);
}
return(d);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
public static StatutCarriere GetStatutCarriereActuel(string code)
{
StatutCarriere s = new StatutCarriere();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter dae = new SqlDataAdapter(StatutCarriereDAL.selectActualEmployeStatutCarriere, ct.Connection);
dae.SelectCommand.Parameters.AddWithValue("@CodeEmploye", code);
DataTable dt = new DataTable("StatutCarriere");
ct.Connection.Open();
dae.Fill(dt);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
StatutCarriereDAL.Hydrate(s, dr);
}
return(s);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
public static Departement GetDepartement(string code_departement)
{
Departement d = new Departement();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter dae = new SqlDataAdapter(StatutCarriereDAL.selectDepartement, ct.Connection);
dae.SelectCommand.Parameters.AddWithValue("@CodeDepartement", code_departement);
DataTable dt = new DataTable("Departement");
ct.Connection.Open();
dae.Fill(dt);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
StatutCarriereDAL.Hydrate(d, dr);
}
return(d);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
public static List <StatutCarriere> GetStatutCarrieres(string code)
{
List <StatutCarriere> lCarriere = new List <StatutCarriere>();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter dae = new SqlDataAdapter(StatutCarriereDAL.selectEmployeStatutCarrieres, ct.Connection);
dae.SelectCommand.Parameters.AddWithValue("@CodeEmploye", code);
DataTable dt = new DataTable("StatutCarriere");
ct.Connection.Open();
dae.Fill(dt);
StatutCarriere s;
foreach (DataRow dr in dt.Rows)
{
s = new StatutCarriere();
StatutCarriereDAL.Hydrate(s, dr);
lCarriere.Add(s);
}
return(lCarriere);
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}
