public List <humidity> GetAllHumidities()
{
var humidityList = new List <humidity>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlDependency.Start(connectionString);
string cmdText = "select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.humidity where [sensor_number] ='E110-sensortag-01' UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.humidity where [sensor_number] ='E110-sensortag-02' UNION " +
"select TOP(10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.humidity where[sensor_number] = 'E110-sensortag-03' UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.humidity where [sensor_number] ='E110-sensortag-04'UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.humidity where [sensor_number] ='E110-sensortag-05'";
SqlCommand cmd = new SqlCommand(cmdText, conn);
SqlDependency dependency = new SqlDependency(cmd);
dependency.OnChange += dbChangeNotification;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var humidityInfo = new humidity
{
name = reader["name"].ToString(),
time = Convert.ToInt64(reader["time"]),
sensor_number = reader["sensor_number"].ToString(),
sensor_type = reader["sensor_type"].ToString(),
value = (float)Convert.ToDouble(reader["value"])
};
humidityList.Add(humidityInfo);
}
}
return(humidityList);
}
public static void printHumidity(humidity h)
{
Console.WriteLine(h());
}
