public static List <Client> GetList() { List <Client> listeClient = new List <Client>(); //SqlConnection oConn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\marilou\Documents\mdsb3.mdf;Integrated Security=True;Connect Timeout=30"); //oConn.Open(); SqlConnection oConn = SingleConnection.CreateInstance().GetConnection(); oConn.Open(); SqlCommand oCmd = oConn.CreateCommand(); oCmd.CommandText = "SELECT * FROM CLIENT"; // notre objet contient le resultat de la req SqlDataReader oReader = oCmd.ExecuteReader(); while (oReader.Read()) { var client = Client.CreateObject(TypeClient.NORMAL); client.Id = Convert.ToInt32(oReader["Id"]); client.Name = Convert.ToString(oReader["NOM"]); //client.Type = oReader["TYPE"]; client.MtEncours = Convert.ToInt32(oReader["MtEnCours"]); listeClient.Add(client); } oReader.Close(); oConn.Close(); return(listeClient); }
public static SingleConnection CreateInstance() { if (Instance == null) { Instance = new SingleConnection(); } return(Instance); }