public static clsListClient GetClients() { //Liste temporaire clsListClient tmpList = new clsListClient(); //Commande + Requete SQL OleDbCommand cmd = new OleDbCommand(); //commande cmd.Connection = clsGlobal.myCon; cmd.CommandText = "SELECT * FROM Clients"; OleDbDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { clsClient cl = new clsClient(rd["User"].ToString(), rd["Password"].ToString(), rd["Email"].ToString(), rd["RefClient"].ToString(), rd["Type"].ToString(), rd["Phone"].ToString(), rd["FirstName"].ToString(), rd["LastName"].ToString(), rd["RefEmployee"].ToString()); tmpList.Ajouter(cl); cl = null; } //fermer le reader rd.Close(); //fermer la connection // myCon.Close(); //retourne la valeur tmpList return(tmpList); }
public clsCompany(clsListEmployee Employee, clsListClient Client, clsListHouse House) { this.VEmployee = Employee; this.Cliente = Client; this.House = House; }