/// <summary>
/// Get Data from DB(last two minutes)
/// </summary>
/// <param name="sqldb">Database</param>
/// <returns>Return packet to send</returns>
public Hashtable retriveData(SQL_Wrapper sqldb)
{
Hashtable packet = new Hashtable();
ResultSet data = sqldb.get_last2mindata(numberP);
if (data.Data.Count != 0)
{
objson o = new objson("FEZ_46");
foreach (ArrayList dato in data.Data)
{
Misure m = new Misure();
m.sensor = (string)dato[0];
string id = dato[1].ToString();
m.sensor_id = Int32.Parse(id);
m.iso_timestamp = (string)dato[2];
m.value = (float)(double)dato[3];
m.status = (string)dato[4];
o.addMisure(m);
}
string json = JsonSerializer.SerializeObject(o.hastTable);
packet.Add(numberP, json);
numberP++;
}
else
{
packet = null;
}
//inviare questa stringa..
return(packet);
}
/// <summary>
/// Insert Misure into Database
/// </summary>
/// <param name="m">Misura</param>
/// <param name="numberP">Number of packet</param>
public void insert(Misure m, int numberP)
{
db.ExecuteNonQuery("INSERT INTO Misure(sensor,sensor_id, iso_timestamp, value, status, packet) VALUES('" + m.sensor + "','" + m.sensor_id + "','" + m.iso_timestamp + "','" + m.value + "','" + m.status + "','" + numberP + "')");
}
public void addMisure(Misure m)
{
measurements.Add(m);
}
