public static List <Conge> getConges(string code_employe)
{
List <Conge> lCarriere = new List <Conge>();
Connecteur ct = new Connecteur();
try
{
SqlDataAdapter da = new SqlDataAdapter(CongeDAL.selectEmployeConges, ct.Connection);
da.SelectCommand.Parameters.AddWithValue("@CodeEmploye", code_employe);
DataTable dt = new DataTable("Conge");
ct.Connection.Open();
da.Fill(dt);
Conge s;
foreach (DataRow dr in dt.Rows)
{
s = new Conge();
CongeDAL.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();
}
}
public static void Insert(Conge c)
{
Connecteur ct = new Connecteur();
//Proceed Database Command-------------------------------------
if (ct.Connection.State == ConnectionState.Closed)
{
ct.Connection.Open();
}
SqlCommand cmd =
new SqlCommand(CongeDAL.insertConge, ct.Connection);
try
{
//1 - INSERT Conge
//Conge Params - Insert
CongeDAL.setCongeParameters(cmd.Parameters, c);
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new Exception("Error: " + ex.Message + " - Code: " + ex.Number + " - Couche(DAL)");
}
finally
{
ct.Connection.Close();
}
}