string sql = "INSERT INTO wallets (steamid,balance) VALUES (@id , @bal);";
using (var connection = new SqlConnection(info))
{
var affectedRows = connection.Execute(sql, new {id, bal});
Console.WriteLine(affectedRows);
sql = "UPDATE wallets SET balance=0 WHERE steamid=@id";
var id =76561198928736885;
var affectedRows = connection.Execute(sql, new {id});
}
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;
}