public void SaveData(DataModel data)
{
MySqlCommand command = _connection.CreateCommand();
command.CommandText = "INSERT INTO isp_conn_stats(date,ping,download,upload) VALUES(@date,@ping,@download,@upload);";
command.Parameters.AddWithValue("@date", data.DateTime.ToString("yyyy-MM-dd H:mm:ss"));
command.Parameters.AddWithValue("@ping", data.Ping);
command.Parameters.AddWithValue("@download", data.DownSpeed);
command.Parameters.AddWithValue("@upload", data.UpSpeed);
try
{
Logger.Log("Successful connection. Attempt to save data...");
_connection.Open();
command.ExecuteNonQuery();
Console.WriteLine("Data saved to database.");
Logger.Log("Data saved to database.");
Console.WriteLine();
}
catch (Exception ex)
{
Logger.Log("Error saving data to database: " + ex.Message);
}
finally
{
_connection.Close();
}
}
private void SaveResultsToDb(string[] results)
{
float ping, download, upload;
float.TryParse(results[0], out ping);
float.TryParse(results[1], out download);
float.TryParse(results[2], out upload);
DataModel data = new DataModel
{
Ping = ping,
DownSpeed = download,
UpSpeed = upload,
DateTime = DateTime.Now
};
Logger.Log("Saving results to database");
_database.SaveData(data);
}
