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 clsHouse()
{
RefHouse = "Undefined";
Type = "Undefined";
Address = new clsAddress();
NumberRoom = 00;
NumberBathroom = 00;
Size = "Undefined";
YearBuilt = "Undefined";
Price = 000;
Description = "Undefined";
RefEmployee = "Undefined";
RefClient = "Undefined";
}
public clsHouse(string RefHouse, string Type, clsAddress Address, int NumberRoom, int NumberBathromm, string Size,
string YearBuilt, decimal Price, string Description, string RefEmployee, string RefClient)
{
this.RefHouse = RefHouse;
this.Type = Type;
this.Address = Address;
this.NumberRoom = NumberRoom;
this.NumberBathroom = NumberBathromm;
this.Size = Size;
this.YearBuilt = YearBuilt;
this.Price = Price;
this.Description = Description;
this.RefEmployee = RefEmployee;
this.RefClient = RefClient;
}