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