public List <Office> OfficesList()
{
List <Office> list = new List <Office>();
SqlDataReader data = MyConnexion.ExecuteReaderMyC("Select * from OfficesSales;");
while (data.Read())
{
list.Add(new Office(data.GetInt32(0), data.GetString(1)));
}
MyConnexion.Close();
return(list);
}
public List <Apartements> ApartementsList()
{
List <Apartements> list = new List <Apartements>();
SqlDataReader data = MyConnexion.ExecuteReaderMyC("select * from Apartements ");
while (data.Read())
{
//list.Add(new Group(int.Parse(data["Id"].ToString()),data["Nom"].ToString()));
list.Add(new Apartements(data.GetInt32(0), data.GetFloat(1), data.GetString(2), data.GetInt32(3),
data.GetInt32(4)));
}
MyConnexion.Close();
return(list);
}
public List <Customers> CustomerList()
{
List <Customers> list = new List <Customers>();
SqlDataReader data = MyConnexion.ExecuteReaderMyC("select * from Customers ");
while (data.Read())
{
//list.Add(new Group(int.Parse(data["Id"].ToString()),data["Nom"].ToString()));
list.Add(new Customers(data.GetInt32(0), data.GetString(1), data.GetString(2), data.GetInt32(3),
data.GetString(4), data.GetString(5), data.GetInt32(6)));
}
MyConnexion.Close();
return(list);
}
