/// <summary>
/// Executes a query without a return. 27/11/15
/// </summary>
private static bool ExecuteNonQuery(string query)
{
if (connectionOpen())
{
// Creates a database command from the query and existing connection
OdbcCommand cmd = new OdbcCommand(query, connection);
try
{
cmd.ExecuteNonQueryAsync(); // Executes the command
return true;
}
catch (OdbcException ex)
{
// Displays an error if something bad occurs while executing the command
error = ex.Message;
return false;
}
}
else
{
return false;
}
}
private void fixAllNames(object state)
{
try
{
if (!CanConnect)
return;
using (OdbcCommand comID = new OdbcCommand("select distinct Id from trafikverket.weather where isnull(MeasurePoint);", MySqlConnection))
{
using (OdbcDataReader drID = comID.ExecuteReader())
{
string strUpdateText = "";
while (drID.Read())
{
Thread.Sleep(100);
if (bAbort)
return;
string strId = drID.GetString(0);
using (OdbcCommand comName = new OdbcCommand("select distinct MeasurePoint from trafikverket.weather where Id='" + strId + "' and not isnull(MeasurePoint);", MySqlConnection))
using (OdbcDataReader drName = comName.ExecuteReader())
{
if (drName.Read())
{
string strName = drName.GetString(0);
strUpdateText += "update trafikverket.weather set MeasurePoint='" + strName + "' where Id='" + strId + "' and isnull(MeasurePoint);\r\n";
}
}
}
if (!string.IsNullOrEmpty(strUpdateText))
{
try
{
using (OdbcCommand updateName = new OdbcCommand(strUpdateText, MySqlConnection))
updateName.ExecuteNonQueryAsync();
}
catch
{
}
}
}
}
}
catch { }
}
