public async Task <ActionResult> GetByParams(string sensorId, DateTimeOffset from, DateTimeOffset to)
{
var listOfPollution = _session.Execute("SELECT * FROM pollution_data WHERE sensorid='" + sensorId + "' AND collecttime>" + from.ToUnixTimeMilliseconds() + " AND collecttime<" + to.ToUnixTimeMilliseconds() + "");
IList <PollutionDTO> pollutions = new List <PollutionDTO>();
foreach (var res in listOfPollution)
{
PollutionDTO p = new PollutionDTO();
p.SensorId = res.GetValue <string>("sensorid");
p.CollectTime = res.GetValue <DateTimeOffset>("collecttime");
p.SensorData = res.GetValue <float>("sensordata");
pollutions.Add(p);
}
return(Ok(pollutions));
}
public async Task DeleteByKey([FromBody] PollutionDTO poll)
{
_session.Execute("DELETE FROM pollution_data WHERE sensorid='" + poll.SensorId + "' AND collecttime=" + poll.CollectTime.ToUnixTimeMilliseconds() + "");
}
public async Task Post([FromBody] PollutionDTO pollution)
{
string about = "Need to be solved";
_session.Execute("INSERT INTO alertPollution (sensorid, sensordata, collecttime, about) VALUES ('" + pollution.SensorId + "', " + pollution.SensorData + ", " + pollution.CollectTime.ToUnixTimeMilliseconds() + ", 'Need to be solved')");
}
