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); }