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(); } }