public bool uploadMonitors(Tree tree)
{
string query_start = "INSERT IGNORE INTO " + monitors_table + " (OWD_ID) VALUES ";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
if (tree.monitorsCount() > 100)
{
int i = 0;
while (i < tree.monitorsCount())
{
string query = query_start;
query += tree.getMonitorsAsString(100, i);
cmd.CommandText = query;
cmd.ExecuteNonQuery();
i += 100;
}
}
else
{
string query = query_start;
query += tree.getMonitorsAsString(0);
Debug.Write(query);
cmd.CommandText = query;
cmd.ExecuteNonQuery();
}
try
{
return true;
}
catch (MySqlException ex)
{
Debug.WriteLine(ex);
return false;
}
}
