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