public class Garage
{
public Garage()
{
_cars = new List<Car>();
}
private readonly List<Car> _cars;
public void AddCar(string carModel, string color, double speed, int yearOfIssue)
{
var car = new Car(carModel, color, speed, yearOfIssue);
_cars.Add(car);
}
public void DeleteCar(string carModel, string color = "", double speed = 0, int yearOfIssue = 0)
{
var query = from c in _cars
where c.CarModel.StartsWith(carModel)
select c;
if (color != string.Empty)
query = query.Where(cl => cl.Color == color);
if (speed > 0)
query = query.Where(sp => Math.Abs(sp.Speed - speed) < 0.2);
if (yearOfIssue > 0)
query = query.Where(y => y.YearOfIssue == yearOfIssue);
var results = query.Select(f => f).ToList();
foreach (var car in results) _cars.Remove(car);
}
}
public class Car
{
public Car()
{
}
public Car(string carModel, string color, double speed, int yearOfIssue)
{
this._carModel = carModel;
this._color = color;
this._speed = speed;
this._yearOfIssue = yearOfIssue;
}
private string _carModel;
public string CarModel => _carModel;
private string _color;
public string Color => _color;
private double _speed;
public double Speed => _speed;
private int _yearOfIssue;
public int YearOfIssue => _yearOfIssue;
}SELECT
@N:=@N + 1 AS '',
(@N * 1) AS '1',
(@N * 2) AS '2',
(@N * 3) AS '3',
(@N * 4) AS '4',
(@N * 5) AS '5',
(@N * 6) AS '6',
(@N * 7) AS '7',
(@N * 8) AS '8',
(@N * 9) AS '9'
FROM
mysql.help_relation,
(SELECT @N:=0) dum
LIMIT 10;