public int AddCarRow(Car car)
{
string qInsert = "INSERT INTO CAR ('regNr', 'brand', 'model', 'year', 'forSale') VALUES (@regNr, @brand, @model, @year, @forSale);";
SQLiteCommand dbCommand = new SQLiteCommand(qInsert, dbConn);
OpenConnection();
dbCommand.Parameters.AddWithValue(@"regNr", car.GetRegNr());
dbCommand.Parameters.AddWithValue(@"brand", car.GetBrand());
dbCommand.Parameters.AddWithValue(@"model", car.GetModel());
dbCommand.Parameters.AddWithValue(@"year", car.GetYear());
dbCommand.Parameters.AddWithValue(@"forSale", Convert.ToInt32(car.GetForSale()));
int result = dbCommand.ExecuteNonQuery();
CloseConnection();
return(result);
}
