public List <Car> SelectCarsFromDb(TableModelsCars tableModels) { mySqlCommand.CommandText = "CALL cars_select_all()"; MySqlDataReader reader = mySqlCommand.ExecuteReader(); cars.Clear(); while (reader.Read()) { cars.Add(new Car() { Id = reader.GetInt32("id"), idModel = reader.GetInt32("id_model"), Body = reader.GetString("body"), Year = reader.GetDateTime("year"), Balance = reader.GetInt32("balance"), Price = reader.GetInt32("price"), Credit = reader.GetBoolean("credit"), model = tableModels.Rows.Find(item => item.Id == reader.GetInt32("id_model")) }); } reader.Close(); return(cars); }
public TableCars(MySqlCommand mySqlCommand, TableModelsCars modelsCars) { this.mySqlCommand = mySqlCommand; cars = new List <Car>(); cars = SelectCarsFromDb(modelsCars); }