public static TemperatureByDay GetTemperatureByEventTime(string city_id, string date, string eventTime)
{
ISession session = SessionManager.GetSession();
TemperatureByDay temp = new TemperatureByDay();
if (session == null)
{
return(null);
}
Row TemperatureData = session.Execute("select * from \"temperature_by_day\" where \"city_id\"='" + city_id + "' and \"date\"='" + date + "' and \"event_time\"='" + eventTime + "'").FirstOrDefault();
if (TemperatureData != null)
{
temp.cityID = TemperatureData["city_id"] != null ? TemperatureData["city_id"].ToString() : string.Empty;
temp.date = TemperatureData["date"] != null?DateTime.Parse(TemperatureData["date"].ToString()) : DateTime.Parse(string.Empty);
temp.eventTime = TemperatureData["event_time"] != null?DateTime.Parse(TemperatureData["event_time"].ToString()) : DateTime.Parse(string.Empty);
temp.temperature = TemperatureData["temperature"] != null ? TemperatureData["temperature"].ToString() : string.Empty;
}
return(temp);
}
public static List <TemperatureByDay> GetTemperature()
{
ISession session = SessionManager.GetSession();
List <TemperatureByDay> temp = new List <TemperatureByDay>();
if (session == null)
{
return(null);
}
var TemperatureData = session.Execute("select * from \"temperature_by_day\"");
foreach (var hd in TemperatureData)
{
TemperatureByDay h = new TemperatureByDay();
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.temperature = hd["temperature"] != null ? hd["temperature"].ToString() : string.Empty;
temp.Add(h);
}
return(temp);
}
