public static List <ServiceSocial> GetListPrets(int EmpID)
        {
            List <ServiceSocial> serviceSocials = new List <ServiceSocial>();
            PV            pv;   Service service; TypePret type; Bon_Cmd bon_Cmd; Facture facture;
            ServiceSocial serviceSocial;
            SqlConnection sqlConnection = new SqlConnection(constr);

            sqlConnection.Open();
            String     command    = "SELECT * FROM " + table + " WHERE EmpID = @emp ; ";
            SqlCommand sqlCommand = new SqlCommand(command, sqlConnection);

            using (sqlCommand)
            {
                sqlCommand.CommandType = CommandType.Text;
                sqlCommand.Parameters.AddWithValue("@emp", EmpID);
                SqlDataReader dataReader = sqlCommand.ExecuteReader();
                while (dataReader.Read())
                {
                    service = ConnectionService.GetService((int)dataReader[2]);
                    if (service.nom.Equals("Pret sociale"))
                    {
                        PretSociale pretSociale = new PretSociale();
                        type = new TypePret();
                        type = ConnectionTypes.GetTypePret((int)dataReader[26]);
                        pretSociale.setType(type);
                        serviceSocial = pretSociale;
                    }
                    else if (service.nom.Equals("Dons"))
                    {
                        Dons dons = new Dons();
                        type = ConnectionTypes.GetTypePret((int)dataReader[26]);
                        dons.setType(type);
                        serviceSocial = dons;
                    }
                    else if (service.nom.Equals("Credit Eledtromenager"))
                    {
                        Electromenager electromenager = new Electromenager();
                        try
                        {
                            bon_Cmd = ConnectionBonCmd.GetBonCmd((int)dataReader[0]);
                            electromenager.setBon_cmd(bon_Cmd);
                            facture = ConnectionFacture.GetFacture((int)dataReader[0]);
                            electromenager.setFournissure(facture.GetFournisseur());


                            electromenager.setFacture(facture);
                        }
                        catch { }

                        serviceSocial = electromenager;
                    }
                    else
                    {
                        serviceSocial = new Pret();
                        // Cette cas n'est pas valide
                        throw new Exception();
                    }
                    pv = ConnectionPV.GetPV((int)dataReader[3]);
                    serviceSocial.setPV(pv);
                    serviceSocial.setid((int)dataReader[0]);
                    serviceSocial.setEmployer((int)dataReader[1]);
                    serviceSocial.setPrix(Convert.ToDouble(dataReader[4]));
                    if (dataReader[25] != DBNull.Value)
                    {
                        serviceSocial.setobservation((string)dataReader[25]);
                    }
                    int             indice = 5;
                    List <Double>   prelev = new List <double>();
                    List <DateTime> dates  = new List <DateTime>();
                    while (indice < 25)
                    {
                        prelev.Add(Convert.ToDouble(dataReader[indice]));
                        indice++;
                        if (!(String.IsNullOrEmpty(dataReader[indice].ToString())))
                        {
                            dates.Add(Convert.ToDateTime(dataReader[indice]));
                        }
                        indice++;
                    }
                    serviceSocial.setDates(dates);
                    serviceSocial.setprelevements(prelev);
                    serviceSocials.Add(serviceSocial);
                }
                dataReader.Close();
            }
            sqlCommand.Dispose();
            sqlConnection.Close();
            return(serviceSocials);
        }