public static List <AirHumidityByDay> GetHumidity()
{
ISession session = SessionManager.GetSession();
List <AirHumidityByDay> humidity = new List <AirHumidityByDay>();
if (session == null)
{
return(null);
}
var HumidityData = session.Execute("select * from \"air_humidity_by_day\"");
foreach (var hd in HumidityData)
{
AirHumidityByDay h = new AirHumidityByDay();
h.cityID = hd["city_id"] != null ? hd["city_id"].ToString() : string.Empty;
h.date = hd["date"] != null?DateTime.Parse(hd["date"].ToString()) : DateTime.Parse(string.Empty);
h.eventTime = hd["event_time"] != null?DateTime.Parse(hd["event_time"].ToString()) : DateTime.Parse(string.Empty);
h.airHumidity = hd["air_humidity"] != null ? hd["air_humidity"].ToString() : string.Empty;
humidity.Add(h);
}
return(humidity);
}
public static AirHumidityByDay GetAirHumidityByEventTime(string city_id, string date, string eventTime)
{
ISession session = SessionManager.GetSession();
AirHumidityByDay h = new AirHumidityByDay();
if (session == null)
{
return(null);
}
Row AirHumidityData = session.Execute("select * from \"air_humidity_by_day\" where \"city_id\"='" + city_id + "' and \"date\"='" + date + "' and \"event_time\"='" + eventTime + "'").FirstOrDefault();
if (AirHumidityData != null)
{
h.cityID = AirHumidityData["city_id"] != null ? AirHumidityData["city_id"].ToString() : string.Empty;
h.date = AirHumidityData["date"] != null?DateTime.Parse(AirHumidityData["date"].ToString()) : DateTime.Parse(string.Empty);
h.eventTime = AirHumidityData["event_time"] != null?DateTime.Parse(AirHumidityData["event_time"].ToString()) : DateTime.Parse(string.Empty);
h.airHumidity = AirHumidityData["air_humidity"] != null ? AirHumidityData["air_humidity"].ToString() : string.Empty;
}
return(h);
}
public static void DeleteHumidityByEventTime(string city_id, string date, string eventTime)
{
ISession session = SessionManager.GetSession();
AirHumidityByDay Humidity = new AirHumidityByDay();
if (session == null)
{
return;
}
RowSet HumidityData = session.Execute("delete from \"air_humidity_by_day\" where \"city_id\" = '" + city_id + "' and \"date\" = '" + date + "' and \"event_time\" = '" + eventTime + "'");
}
