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); }