public static clsListHouse GetHouses()
{
//Liste temporaire
clsListHouse tmpList = new clsListHouse();
//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 Houses";
OleDbDataReader rdHouse = cmd.ExecuteReader();
while (rdHouse.Read())
{
clsAddress ad = new clsAddress(rdHouse["Region"].ToString(), rdHouse["City"].ToString(), rdHouse["Province"].ToString(), rdHouse["StreetAddress"].ToString(), rdHouse["PostalCode"].ToString(), Convert.ToInt32(rdHouse["aptnumber"]));
clsHouse eq = new clsHouse(rdHouse["RefHouse"].ToString(), rdHouse["Type"].ToString(), ad, Convert.ToInt32(rdHouse["NbRooms"]), Convert.ToInt32(rdHouse["NbBathroom"]), rdHouse["Size"].ToString(), rdHouse["YearBuilt"].ToString(), Convert.ToDecimal(rdHouse["Price"]), rdHouse["Description"].ToString(), rdHouse["RefEmployee"].ToString(), rdHouse["RefClient"].ToString());
tmpList.Ajouter(eq);
eq = null;
}
//fermer le reader
rdHouse.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;
}
