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