public static clsListEmployee GetEmployee()
{
//Liste temporaire
clsListEmployee tmpListEmployee = new clsListEmployee();
//Connection a la BDD
//OleDbConnection myCon = new OleDbConnection(); //connection
//myCon.ConnectionString = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\Users\pc\Documents\Visual Studio 2015\Projects\prjCSWinADONET\prjCSWinADONET\bin\Debug\data\Sport.mdb";
//myCon.Open();
//Commande + Requete SQL
OleDbCommand cmd = new OleDbCommand(); //commande
cmd.Connection = clsGlobal.myCon;
cmd.CommandText = "SELECT * FROM Employees";
OleDbDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
clsEmployee eq = new clsEmployee(rd["User"].ToString(),
rd["Password"].ToString(), rd["Email"].ToString(),
rd["RefEmployee"].ToString(), rd["Poste"].ToString(),
rd["RefCompany"].ToString(), rd["Phone"].ToString(),
rd["FirstName"].ToString(), rd["LastName"].ToString());
tmpListEmployee.Ajouter(eq);
eq = null;
}
//fermer le reader
rd.Close();
//fermer la connection
// myCon.Close();
//retourne la valeur tmpList
return(tmpListEmployee);
}
public clsCompany(clsListEmployee Employee, clsListClient Client, clsListHouse House)
{
this.VEmployee = Employee;
this.Cliente = Client;
this.House = House;
}