public void WriteCity(DatabaseCity city) { var id = city.Id; var name = city.Name; var countryIso = city.CountryIso; var timezoneShift = city.TimezoneShift; try { OpenDb(); var command = connection.CreateCommand(); // Bei Zeitumstellung ändert sich timezoneShift entsprechend. command.CommandText = $"INSERT INTO city VALUES({id}, '{name}', " + $"'{countryIso}', {timezoneShift}, 0) " + $"ON DUPLICATE KEY UPDATE timezone_shift = {timezoneShift}, " + $"suspended = 0"; command.ExecuteNonQuery(); } catch (MySqlException ex) { MessageBox.Show("WriteCity: " + ex.Message); } finally { CloseDb(); } }
// Nicht in Verwendung, deshalb private. public List <DatabaseCity> GetCityList() { var cityList = new List <DatabaseCity>(); try { OpenDb(); var command = connection.CreateCommand(); command.CommandText = "SELECT * FROM city"; var reader = command.ExecuteReader(); while (reader.Read()) { var city = new DatabaseCity( reader.GetInt32(0), !reader.IsDBNull(1) ? reader.GetString(1) : "", !reader.IsDBNull(2) ? reader.GetString(2) : "", !reader.IsDBNull(3) ? reader.GetInt32(3) : 0 ); cityList.Add(city); } } catch (MySqlException ex) { MessageBox.Show("GetCityList:\n\n" + ex.Message); } finally { CloseDb(); } return(cityList); }