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