public int AddCarRow(Car car)
{
string qInsert = "INSERT INTO car ('regNr', 'make', 'model', 'year', 'forSale') VALUES (@regNr, @make, @model, @year, @forSale); ";
SQLiteCommand dbCommand = new SQLiteCommand(qInsert, dbConn);
OpenConnection();
dbCommand.Parameters.AddWithValue("@regNr", car.GetRegNr());
dbCommand.Parameters.AddWithValue("@make", car.GetMake());
dbCommand.Parameters.AddWithValue("@model", car.GetModel());
dbCommand.Parameters.AddWithValue("@year", car.GetYear());
if (car.GetForSale())
{
dbCommand.Parameters.AddWithValue("@forSale", 1);
}
else
{
dbCommand.Parameters.AddWithValue("@forSale", 0);
}
int result = dbCommand.ExecuteNonQuery();
CloseConnection();
return(result);
}
private void AddCarToListview(Car car)
{
ListViewItem item = CreateListViewItem(car.GetRegNr(), car.GetMake(), car.GetModel(), car.GetYear().ToString(), car.GetForSale());
lsvCars.Items.Add(item);
}
