public void TestMethodTempMaxiCarp()
{
var currentMeasures = new GroupedMeasure();
currentMeasures.waterTempvalue = 32;
currentMeasures.hydroponicTypeName = "Aquaponics - Carp";
Assert.IsFalse(AquaponicsRulesManager.ValidateRules(currentMeasures, productionUnitId, productionUnitOwnerMail));
}
public void TestMethodHumidityTempUnder30()
{
var currentMeasures = new GroupedMeasure();
currentMeasures.airTempvalue = 23;
currentMeasures.humidityvalue = 99;
currentMeasures.hydroponicTypeName = "Not applicable";
Assert.IsFalse(AquaponicsRulesManager.ValidateRules(currentMeasures, productionUnitId, productionUnitOwnerMail));
}
//[Authorize]
public void Post([FromBody] JObject data)
{
var content = data["content"].ToObject <string>();
var device = data["device"].ToObject <string>();
var db = new ApplicationDbContext();
var dbLog = new ApplicationDbContext();
NumberStyles style;
CultureInfo culture;
style = NumberStyles.AllowDecimalPoint;
culture = CultureInfo.CreateSpecificCulture("en-US");
var date = DateTime.Now;
content = content.Replace("a", "A");
Thread.CurrentThread.CurrentCulture = Thread.CurrentThread.CurrentUICulture = new CultureInfo("en");
try
{
var measureType = db.MessageTypes.Where(m => m.Id == 1).FirstOrDefault();
db.Messages.Add(new Message()
{
content = content, device = device, date = date, messageType = measureType
});
db.SaveChanges();
}
catch (Exception ex)
{
dbLog.Logs.Add(Log.CreateErrorLog("Error on Message from Sigfox", ex));
dbLog.SaveChanges();
}
try
{
var currentProductionUnit = db.ProductionUnits.Include(p => p.owner.user)
.Include(p => p.hydroponicType)
.Include(p => p.productionUnitStatus)
.Include(p => p.productionUnitType)
.Where(p => p.reference == device).FirstOrDefault();
if (currentProductionUnit == null)
{
db.Logs.Add(Log.CreateLog(String.Format("Production Unit not found - {0}", device), Log.LogType.Warning));
db.SaveChanges();
}
var upRunningStatus = db.ProductionUnitStatus.Where(p => p.Id == 3).FirstOrDefault();
currentProductionUnit.lastMeasureReceived = date;
currentProductionUnit.productionUnitStatus = upRunningStatus;
//var productionUnitOwnerMail = currentProductionUnit.owner.user.Email;
var currentMeasures = new GroupedMeasure();
currentMeasures.hydroponicTypeName = currentProductionUnit.hydroponicType.name;
var phSensor = db.SensorTypes.Where(s => s.Id == 1).FirstOrDefault();
var waterTemperatureSensor = db.SensorTypes.Where(s => s.Id == 2).FirstOrDefault();
var dissolvedOxySensor = db.SensorTypes.Where(s => s.Id == 3).FirstOrDefault();
var ORPSensor = db.SensorTypes.Where(s => s.Id == 4).FirstOrDefault();
var airTemperatureSensor = db.SensorTypes.Where(s => s.Id == 5).FirstOrDefault();
var airHumidity = db.SensorTypes.Where(s => s.Id == 6).FirstOrDefault();
var phContent = content.Substring(0, 4).Insert(3, ".");
var waterTempContent = content.Substring(4, 4).Insert(3, ".");
var dissolvedOxyContent = content.Substring(8, 4).Insert(3, ".");
var orpContent = content.Substring(12, 4).Insert(3, ".");
var airTempContent = content.Substring(16, 4).Insert(3, ".");
var airHumidityContent = content.Substring(20, 4).Insert(3, ".");
if (!(phContent.Contains("a") || phContent.Contains("A")))
{
decimal pHvalue = 0;
if (decimal.TryParse(phContent, style, culture, out pHvalue))
{
currentMeasures.pHvalue = pHvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = phSensor, value = pHvalue
});
db.SaveChanges();
}
else
{
dbLog.Logs.Add(Log.CreateLog("Error on Convert pH value", Log.LogType.Warning));
dbLog.SaveChanges();
}
}
if (!(waterTempContent.Contains("a") || waterTempContent.Contains("A")))
{
decimal waterTempvalue = 0;
if (decimal.TryParse(waterTempContent, style, culture, out waterTempvalue))
{
currentMeasures.waterTempvalue = waterTempvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = waterTemperatureSensor, value = waterTempvalue
});
db.SaveChanges();
}
else
{
dbLog.Logs.Add(Log.CreateLog("Error on Convert water temp. value", Log.LogType.Warning));
dbLog.SaveChanges();
}
}
if (!(dissolvedOxyContent.Contains("a") || dissolvedOxyContent.Contains("A")))
{
decimal DOvalue = 0;
if (decimal.TryParse(dissolvedOxyContent, style, culture, out DOvalue))
{
currentMeasures.DOvalue = DOvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = dissolvedOxySensor, value = DOvalue
});
db.SaveChanges();
}
else
{
dbLog.Logs.Add(Log.CreateLog("Error on Convert dissolved oxy. value", Log.LogType.Warning));
dbLog.SaveChanges();
}
}
if (!(orpContent.Contains("a") || orpContent.Contains("A")))
{
decimal ORPvalue = 0;
if (decimal.TryParse(orpContent, style, culture, out ORPvalue))
{
currentMeasures.ORPvalue = ORPvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = ORPSensor, value = ORPvalue
});
db.SaveChanges();
}
else
{
dbLog.Logs.Add(Log.CreateLog("Error on Convert ORP value", Log.LogType.Warning));
dbLog.SaveChanges();
}
}
if (!(airTempContent.Contains("a") || airTempContent.Contains("A")))
{
decimal airTempvalue = 0;
if (decimal.TryParse(airTempContent, style, culture, out airTempvalue))
{
currentMeasures.airTempvalue = airTempvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = airTemperatureSensor, value = airTempvalue
});
db.SaveChanges();
}
else
{
dbLog.Logs.Add(Log.CreateLog("Error on Convert air temp. value", Log.LogType.Warning));
dbLog.SaveChanges();
}
}
if (!(airHumidityContent.Contains("a") || airHumidityContent.Contains("A")))
{
decimal humidityvalue = 0;
if (decimal.TryParse(airHumidityContent, style, culture, out humidityvalue))
{
currentMeasures.humidityvalue = humidityvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = airHumidity, value = humidityvalue
});
db.SaveChanges();
}
else
{
dbLog.Logs.Add(Log.CreateLog("Error on Convert humidity value", Log.LogType.Warning));
dbLog.SaveChanges();
}
}
ExternalAirHumidityManager.GetExternalAirHumidityValues(currentProductionUnit.Id, date);
}
catch (Exception ex)
{
dbLog.Logs.Add(Log.CreateErrorLog("Error on Convert Message into Measure", ex));
dbLog.SaveChanges();
}
}
//[Authorize]
public void Post([FromBody] JObject data)
{
var content = data["content"].ToObject <string>();
var device = data["device"].ToObject <string>();
var lqi = data["data"].ToObject <string>();
var db = new ApplicationDbContext();
var dbLog = new ApplicationDbContext();
NumberStyles style;
CultureInfo culture;
style = NumberStyles.AllowDecimalPoint;
culture = CultureInfo.CreateSpecificCulture("en-US");
var date = DateTime.Now;
content = content.Replace("a", "A");
Thread.CurrentThread.CurrentCulture = Thread.CurrentThread.CurrentUICulture = new CultureInfo("en");
try
{
var measureType = db.MessageTypes.Where(m => m.Id == 1).FirstOrDefault();
db.Messages.Add(new Message()
{
content = content, device = device, date = date, messageType = measureType
});
}
catch (Exception ex)
{
dbLog.Logs.Add(Log.CreateErrorLog("Error on Message from Sigfox", ex));
dbLog.SaveChanges();
}
try
{
var currentProductionUnit = db.ProductionUnits.Include(p => p.owner.user)
.Include(p => p.owner.language)
.Include(p => p.hydroponicType)
.Include(p => p.productionUnitStatus)
.Include(p => p.productionUnitType)
.Where(p => p.reference == device).FirstOrDefault();
if (currentProductionUnit == null)
{
db.Logs.Add(Log.CreateLog(String.Format("Production Unit not found - {0}", device), Log.LogType.Warning));
db.SaveChanges();
return;
}
var infoEventType = db.EventTypes.Where(p => p.Id == 8).FirstOrDefault();
var upRunningStatus = db.ProductionUnitStatus.Where(p => p.Id == 3).FirstOrDefault();
var offlineStatus = db.ProductionUnitStatus.Where(p => p.Id == 6).FirstOrDefault();
if (currentProductionUnit.productionUnitStatus.Id == offlineStatus.Id)
{
if (currentProductionUnit.owner != null && currentProductionUnit.owner.language != null)
{
switch (currentProductionUnit.owner.language.description)
{
case "fr":
db.Events.Add(new Event()
{
date = DateTime.Now, description = "Serre Connectée", isOpen = false, productionUnit = currentProductionUnit, eventType = infoEventType, createdBy = "MyFood Bot"
});
break;
case "de":
db.Events.Add(new Event()
{
date = DateTime.Now, description = "Gewächshaus Online", isOpen = false, productionUnit = currentProductionUnit, eventType = infoEventType, createdBy = "MyFood Bot"
});
break;
default:
db.Events.Add(new Event()
{
date = DateTime.Now, description = "Smart Greenhouse Online", isOpen = false, productionUnit = currentProductionUnit, eventType = infoEventType, createdBy = "MyFood Bot"
});
break;
}
db.SaveChanges();
}
if (currentProductionUnit.owner.notificationPushKey != null)
{
NotificationPushManager.PioneerUnitOnlineMessage(currentProductionUnit);
}
if (currentProductionUnit.owner.contactMail != null && currentProductionUnit.owner.isMailNotificationActivated == true)
{
MailManager.PioneerUnitOnlineMessage(currentProductionUnit);
}
}
if (lqi == String.Empty)
{
currentProductionUnit.lastSignalStrenghtReceived = "Wifi";
}
else
{
currentProductionUnit.lastSignalStrenghtReceived = lqi;
}
currentProductionUnit.lastMeasureReceived = date;
currentProductionUnit.productionUnitStatus = upRunningStatus;
var currentMeasures = new GroupedMeasure();
currentMeasures.hydroponicTypeName = currentProductionUnit.hydroponicType.name;
var phSensor = db.SensorTypes.Where(s => s.Id == 1).FirstOrDefault();
var waterTemperatureSensor = db.SensorTypes.Where(s => s.Id == 2).FirstOrDefault();
var dissolvedOxySensor = db.SensorTypes.Where(s => s.Id == 3).FirstOrDefault();
var ORPSensor = db.SensorTypes.Where(s => s.Id == 4).FirstOrDefault();
var airTemperatureSensor = db.SensorTypes.Where(s => s.Id == 5).FirstOrDefault();
var airHumidity = db.SensorTypes.Where(s => s.Id == 6).FirstOrDefault();
var phContent = content.Substring(0, 4).Insert(3, ".");
var waterTempContent = content.Substring(4, 4).Insert(3, ".");
var dissolvedOxyContent = content.Substring(8, 4).Insert(3, ".");
var orpContent = content.Substring(12, 4).Insert(3, ".");
var airTempContent = content.Substring(16, 4).Insert(3, ".");
var airHumidityContent = content.Substring(20, 4).Insert(3, ".");
if (!(phContent.Contains("a") || phContent.Contains("A") || phContent.Contains("B") || phContent.Contains("C")))
{
decimal pHvalue = 0;
if (decimal.TryParse(phContent, style, culture, out pHvalue))
{
currentMeasures.pHvalue = pHvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = phSensor, value = pHvalue
});
}
else
{
dbLog.Logs.Add(Log.CreateLog(String.Format("Error on Convert pH value - {0} - {1}", currentProductionUnit.reference, pHvalue), Log.LogType.Warning));
dbLog.SaveChanges();
}
}
if (!(waterTempContent.Contains("a") || waterTempContent.Contains("A") || waterTempContent.Contains("B") || waterTempContent.Contains("C")))
{
decimal waterTempvalue = 0;
if (decimal.TryParse(waterTempContent, style, culture, out waterTempvalue))
{
currentMeasures.waterTempvalue = waterTempvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = waterTemperatureSensor, value = waterTempvalue
});
}
else
{
dbLog.Logs.Add(Log.CreateLog(String.Format("Error on Convert water temp value - {0} - {1}", currentProductionUnit.reference, waterTempvalue), Log.LogType.Warning));
dbLog.SaveChanges();
}
}
//if (!(dissolvedOxyContent.Contains("a") || dissolvedOxyContent.Contains("A")))
//{
// decimal DOvalue = 0;
// if (decimal.TryParse(dissolvedOxyContent, style, culture, out DOvalue))
// {
// currentMeasures.DOvalue = DOvalue;
// db.Measures.Add(new Measure() { captureDate = date, productionUnit = currentProductionUnit, sensor = dissolvedOxySensor, value = DOvalue });
// }
// else
// {
// dbLog.Logs.Add(Log.CreateLog("Error on Convert dissolved oxy. value", Log.LogType.Warning));
// dbLog.SaveChanges();
// }
//}
//if (!(orpContent.Contains("a") || orpContent.Contains("A")))
//{
// decimal ORPvalue = 0;
// if (decimal.TryParse(orpContent, style, culture, out ORPvalue))
// {
// currentMeasures.ORPvalue = ORPvalue;
// db.Measures.Add(new Measure() { captureDate = date, productionUnit = currentProductionUnit, sensor = ORPSensor, value = ORPvalue });
// }
// else
// {
// dbLog.Logs.Add(Log.CreateLog("Error on Convert ORP value", Log.LogType.Warning));
// dbLog.SaveChanges();
// }
//}
if (!(airTempContent.Contains("a") || airTempContent.Contains("A") || airTempContent.Contains("B") || airTempContent.Contains("C")))
{
decimal airTempvalue = 0;
if (decimal.TryParse(airTempContent, style, culture, out airTempvalue))
{
currentMeasures.airTempvalue = airTempvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = airTemperatureSensor, value = airTempvalue
});
}
else
{
dbLog.Logs.Add(Log.CreateLog(String.Format("Error on Convert air temp value - {0} - {1}", currentProductionUnit.reference, airTempvalue), Log.LogType.Warning));
dbLog.SaveChanges();
}
}
if (!(airHumidityContent.Contains("a") || airHumidityContent.Contains("A") || airHumidityContent.Contains("B") || airHumidityContent.Contains("C")))
{
decimal humidityvalue = 0;
if (decimal.TryParse(airHumidityContent, style, culture, out humidityvalue))
{
currentMeasures.humidityvalue = humidityvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = airHumidity, value = humidityvalue
});
}
else
{
dbLog.Logs.Add(Log.CreateLog(String.Format("Error on Convert air hum value - {0} - {1}", currentProductionUnit.reference, humidityvalue), Log.LogType.Warning));
dbLog.SaveChanges();
}
}
ExternalAirHumidityManager.GetExternalAirHumidityValues(currentProductionUnit.Id, date);
try
{
db.SaveChanges();
}
catch (Exception ex)
{
dbLog.Logs.Add(Log.CreateErrorLog("Error on Saving Measure and Message", ex));
dbLog.SaveChanges();
}
}
catch (Exception ex)
{
dbLog.Logs.Add(Log.CreateErrorLog("Error on Convert Message into Measure", ex));
dbLog.SaveChanges();
}
}
// POST api/<controller>
//[Authorize]
public void Post([FromBody] JObject data)
{
var content = data["content"].ToObject <string>();
var device = data["device"].ToObject <string>();
var db = new ApplicationDbContext();
var dbLog = new ApplicationDbContext();
var date = DateTime.Now;
try
{
var measureType = db.MessageTypes.Where(m => m.Id == 1).FirstOrDefault();
db.Messages.Add(new Message()
{
content = content, device = device, date = date, messageType = measureType
});
db.SaveChanges();
}
catch (Exception ex)
{
dbLog.Logs.Add(Log.CreateErrorLog("Error on Message from Sigfox", ex));
dbLog.SaveChanges();
}
try
{
var currentProductionUnit = db.ProductionUnits.Include("owner.user").Include("hydroponicType").Where(p => p.reference == device).FirstOrDefault();
if (currentProductionUnit == null)
{
db.Logs.Add(Log.CreateLog(String.Format("Production Unit not found - {0}", device), Log.LogType.Warning));
db.SaveChanges();
}
var productionUnitOwnerMail = currentProductionUnit.owner.user.Email;
var currentMeasures = new GroupedMeasure();
currentMeasures.hydroponicTypeName = currentProductionUnit.hydroponicType.name;
var phSensor = db.SensorTypes.Where(s => s.Id == 1).FirstOrDefault();
var waterTemperatureSensor = db.SensorTypes.Where(s => s.Id == 2).FirstOrDefault();
var dissolvedOxySensor = db.SensorTypes.Where(s => s.Id == 3).FirstOrDefault();
var ORPSensor = db.SensorTypes.Where(s => s.Id == 4).FirstOrDefault();
var airTemperatureSensor = db.SensorTypes.Where(s => s.Id == 5).FirstOrDefault();
var airHumidity = db.SensorTypes.Where(s => s.Id == 6).FirstOrDefault();
var phContent = content.Substring(0, 4).Insert(3, ".");
var waterTempContent = content.Substring(4, 4).Insert(3, ".");
var dissolvedOxyContent = content.Substring(8, 4).Insert(3, ".");
var orpContent = content.Substring(12, 4).Insert(3, ".");
var airTempContent = content.Substring(16, 4).Insert(3, ".");
var airHumidityContent = content.Substring(20, 4).Insert(3, ".");
if (!phContent.Contains("a"))
{
decimal pHvalue = 0;
if (decimal.TryParse(phContent, out pHvalue))
{
currentMeasures.pHvalue = pHvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = phSensor, value = pHvalue
});
db.SaveChanges();
}
}
if (!waterTempContent.Contains("a"))
{
decimal waterTempvalue = 0;
if (decimal.TryParse(waterTempContent, out waterTempvalue))
{
currentMeasures.waterTempvalue = waterTempvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = waterTemperatureSensor, value = waterTempvalue
});
db.SaveChanges();
}
}
if (!dissolvedOxyContent.Contains("a"))
{
decimal DOvalue = 0;
if (decimal.TryParse(dissolvedOxyContent, out DOvalue))
{
currentMeasures.DOvalue = DOvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = dissolvedOxySensor, value = DOvalue
});
db.SaveChanges();
}
}
if (!orpContent.Contains("a"))
{
decimal ORPvalue = 0;
if (decimal.TryParse(orpContent, out ORPvalue))
{
currentMeasures.ORPvalue = ORPvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = ORPSensor, value = ORPvalue
});
db.SaveChanges();
}
}
if (!airTempContent.Contains("a"))
{
decimal airTempvalue = 0;
if (decimal.TryParse(airTempContent, out airTempvalue))
{
currentMeasures.airTempvalue = airTempvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = airTemperatureSensor, value = airTempvalue
});
db.SaveChanges();
}
}
if (!airHumidityContent.Contains("a"))
{
decimal humidityvalue = 0;
if (decimal.TryParse(airHumidityContent, out humidityvalue))
{
currentMeasures.humidityvalue = humidityvalue;
db.Measures.Add(new Measure()
{
captureDate = date, productionUnit = currentProductionUnit, sensor = airHumidity, value = humidityvalue
});
db.SaveChanges();
}
}
DateTime lastDay = date.AddDays(-1);
var currentLastDayPHValue = db.Measures.Where(m => m.captureDate > lastDay &&
m.productionUnit.Id == currentProductionUnit.Id &&
m.sensor.Id == phSensor.Id).OrderBy(m => m.Id).FirstOrDefault();
if (currentLastDayPHValue == null)
{
currentMeasures.lastDayPHvariation = 0;
}
else
{
currentMeasures.lastDayPHvariation = Math.Abs(currentLastDayPHValue.value - currentMeasures.pHvalue);
}
AquaponicsRulesManager.ValidateRules(currentMeasures, currentProductionUnit.Id, productionUnitOwnerMail);
}
catch (Exception ex)
{
dbLog.Logs.Add(Log.CreateErrorLog("Error on Convert Message into Measure", ex));
dbLog.SaveChanges();
}
}