public void UpdateNewData(emsData data, int statId, int devId, string country, int?statCodeUp)
{
using (var context = new EsMonitorModels())
{
var last = context.EsMin.FirstOrDefault(d => d.DevId == devId);
if (last == null)
{
return;
}
last.TP = data.dust;
last.DB = data.noise;
last.Temperature = data.temperature;
last.Humidity = data.humidity;
last.WindDirection = data.windDirection;
last.WindSpeed = data.windSpeed;
context.EsMin.AddOrUpdate(last);
context.SaveChanges();
}
}
public void AddNewData(emsData data, int statId, int devId, string country, int?statCodeUp)
{
using (var context = new EsMonitorModels())
{
var newData = new T_ESMin
{
TP = data.dust,
DB = data.noise,
Temperature = data.temperature,
Humidity = data.humidity,
WindDirection = data.windDirection,
WindSpeed = data.windSpeed,
Airpressure = 0,
DevId = devId,
StatId = statId,
Country = country,
StatCode = statCodeUp,
DataStatus = "N"
};
context.EsMin.Add(newData);
context.SaveChanges();
}
}
