static void offlineTimer_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
DateTime MyScheduledRunTime = DateTime.Parse(WebConfigurationManager.AppSettings["timerStartTime"]);
DateTime CurrentSystemTime = DateTime.Now;
DateTime LatestRunTime = MyScheduledRunTime.AddMilliseconds(RulesTimerIntervalInMilliseconds);
if ((CurrentSystemTime.CompareTo(MyScheduledRunTime) >= 0) && (CurrentSystemTime.CompareTo(LatestRunTime) <= 0))
{
var db = new ApplicationDbContext();
var upRunningStatus = db.ProductionUnitStatus.Where(s => s.Id == 3).FirstOrDefault();
var offlineStatus = db.ProductionUnitStatus.Where(s => s.Id == 6).FirstOrDefault();
var upRunningProductionUnits = db.ProductionUnits.Include(p => p.owner.language).Where(p => p.productionUnitStatus.Id == upRunningStatus.Id).ToList();
var currentDate = DateTime.Now;
upRunningProductionUnits.ForEach(p =>
{
if (p.lastMeasureReceived == null || currentDate - p.lastMeasureReceived > TimeSpan.FromMinutes(30))
{
p.productionUnitStatus = offlineStatus;
}
if (p.owner.notificationPushKey != null)
{
NotificationPushManager.PioneerUnitOfflineMessage(p);
}
});
db.SaveChanges();
}
}
static void offlineTimer_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
var db = new ApplicationDbContext();
var upRunningStatus = db.ProductionUnitStatus.Where(s => s.Id == 3).FirstOrDefault();
var offlineStatus = db.ProductionUnitStatus.Where(s => s.Id == 6).FirstOrDefault();
var upRunningProductionUnits = db.ProductionUnits.Include(p => p.owner.language).Where(p => p.productionUnitStatus.Id == upRunningStatus.Id).ToList();
var currentDate = DateTime.Now;
var warningEventType = db.EventTypes.Where(p => p.Id == 1).FirstOrDefault();
upRunningProductionUnits.ForEach(p =>
{
if (p.lastMeasureReceived == null || currentDate - p.lastMeasureReceived > TimeSpan.FromMinutes(60))
{
p.productionUnitStatus = offlineStatus;
if (p.owner != null && p.owner.language != null)
{
switch (p.owner.language.description)
{
case "fr":
db.Events.Add(new Event()
{
date = DateTime.Now, description = "Serre déconnectée", isOpen = false, productionUnit = p, eventType = warningEventType, createdBy = "MyFood Bot"
});
break;
default:
db.Events.Add(new Event()
{
date = DateTime.Now, description = "Smart Greenhouse Offline", isOpen = false, productionUnit = p, eventType = warningEventType, createdBy = "MyFood Bot"
});
break;
}
}
if (p.owner.notificationPushKey != null)
{
NotificationPushManager.PioneerUnitOfflineMessage(p);
}
}
});
db.SaveChanges();
}
public ActionResult SendFeelingRequest()
{
var db = new ApplicationDbContext();
var upRunningStatus = db.ProductionUnitStatus.Where(s => s.Id == 3).FirstOrDefault();
var upRunningProductionUnits = db.ProductionUnits.Include(p => p.owner.language).Where(p => p.productionUnitStatus.Id == upRunningStatus.Id).ToList();
upRunningProductionUnits.ForEach(p =>
{
if (p.owner.notificationPushKey != null)
{
NotificationPushManager.PioneerUnitOwnerFeelingMessage(p);
}
});
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
private static void SendDailyMessage()
{
ApplicationDbContext db = new ApplicationDbContext();
var yesterdayDate = DateTime.Now.AddDays(-1);
var todayEvents = db.Events.Include(e => e.productionUnit.owner.user)
.Include(e => e.productionUnit.owner.language)
.Where(ev => ev.date > yesterdayDate).ToList();
var groupedEvents = todayEvents.GroupBy(ev => ev.productionUnit);
foreach (var item in groupedEvents)
{
var currentProductionUnit = item.Key;
if (currentProductionUnit.owner.notificationPushKey != null)
{
NotificationPushManager.PioneerUnitEventMessage(currentProductionUnit);
}
}
}
private static void SendDailyMessage()
{
ApplicationDbContext db = new ApplicationDbContext();
var yesterdayDate = DateTime.Now.AddDays(-1);
var todayEvents = db.Events.Include("productionUnit.owner.user").Where(ev => ev.date > yesterdayDate).ToList();
var groupedEvents = todayEvents.GroupBy(ev => ev.productionUnit);
foreach (var item in groupedEvents)
{
var productionUnitOwnerMail = item.Key.owner.user.Email;
var productionUnitOwnerName = item.Key.owner.pioneerCitizenName;
var notificationPushKey = item.Key.owner.notificationPushKey;
var productionUnitId = item.Key.Id;
var productionUnitInfo = item.Key.info;
var mailSubject = String.Format("Daily Events on your myfood Unit {0}", productionUnitInfo);
var mailContent = new StringBuilder();
NotificationPushManager.PushMessage(mailSubject, "Click to see your production unit's status", productionUnitId, notificationPushKey);
//mailContent.AppendLine(String.Format("Hello {0}, your unit reported few events today", productionUnitOwnerName));
//mailContent.AppendLine(String.Format(@"Get more details at https://hub.myfood.eu/ProductionUnits/Events/{0}", productionUnitId));
//var eventMessageList = item.ToList();
//try
//{
// MailManager.SendMail(productionUnitOwnerMail, mailSubject, mailContent.ToString());
//}
//catch (Exception ex)
//{
// db.Logs.Add(Log.CreateErrorLog(String.Format("Error with Rule Manager - Mail Sending"), ex));
// db.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();
}
}
