public static Boolean rapport(DataBaseConnect conn, String[] file, Storage sensor_info)
{
foreach (String lines in file)
{
string[] entries = lines.Split(' ');
int id = int.Parse(Regex.Replace(entries[0], "[^0-9 ]", ""));
DateTime date = System.DateTime.Parse(entries[1] + " " + entries[2]);
double temp = double.Parse(Regex.Replace(entries[3], "[^0-9., ]", "").Replace(".", ","));
double humidity = double.Parse(Regex.Replace(entries[4], "[^0-9., ]", "").Replace(".", ","));
try
{
MySqlCommand cmd = new MySqlCommand("INSERT INTO `dataline` (`idSensor`, `dateTime`, `humidity`, `temperature`,`place`) VALUES(@id, @date, @humidity, @temp, @place)", conn.conn);
cmd.Parameters.AddWithValue("@idSensor", sensor_info.id_sensor);
cmd.Parameters.AddWithValue("@date", date);
cmd.Parameters.AddWithValue("@temp", temp);
cmd.Parameters.AddWithValue("@humidity", humidity);
cmd.Parameters.AddWithValue("@place", sensor_info.sensor_place);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
return(false);
}
}
return(true);
}
public static DataBaseConnect getInstance()
{
if (connection == null)
{
connection = new DataBaseConnect();
}
return(connection);
}
public static MySqlCommand WithParameter(String parameter, DataBaseConnect conn)
{
return(new MySqlCommand(parameter, conn.conn));
}
public static MySqlCommand Data(DataBaseConnect connection)
{
return(new MySqlCommand("SELECT * ", connection.conn));
}
