public static void StatusUpdate(int PlantID, Char Status)
{
dbContectionDataContext context = new dbContectionDataContext();
var plant = context.Plants.Single(x => x.PlantID == PlantID);
plant.Status = Status;
context.SubmitChanges();
}
public JsonResult CompleteWateringPlants(int plantId)
{
dbContectionDataContext context = new dbContectionDataContext();
var plant = context.Plants.Single(x => x.PlantID == plantId);
plant.Status = 'W';
context.SubmitChanges();
return(Json("true", JsonRequestBehavior.AllowGet));
}
public JsonResult UnHoldWatering(int[] plantId)
{
dbContectionDataContext context = new dbContectionDataContext();
foreach (var id in plantId)
{
var plant = context.Plants.Single(x => x.PlantID == id);
plant.Status = 'W';
context.SubmitChanges();
RealTimeCalls.NotifyOnUnHoldPlants(plantId);
}
return(Json("true", JsonRequestBehavior.AllowGet));
}
public JsonResult HoldReWateringPlants(int[] plantId)
{
dbContectionDataContext context = new dbContectionDataContext();
foreach (var id in plantId)
{
var plant = context.Plants.Single(x => x.PlantID == id);
plant.Status = 'R';
plant.LastCompleted = DateTime.Now;
DateTime Reset = DateTime.Now.AddSeconds(30);
plant.Reset = Reset;
context.SubmitChanges();
}
RealTimeCalls.NotifyOnCompletePlants(plantId);
return(Json("true", JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
dbContectionDataContext dbContext = new dbContectionDataContext();
List <PlantModel> list = new List <PlantModel>();
var plants = dbContext.Plants.ToList();
foreach (var item in plants)
{
PlantModel model = new PlantModel();
model.PlantID = item.PlantID;
model.Status = item.Status.ToString();
//model.LastCompleted = item.LastCompleted;
list.Add(model);
}
return(View(list));
}
public JsonResult GetPlantList()
{
dbContectionDataContext dbContext = new dbContectionDataContext();
List <PlantModel> list = new List <PlantModel>();
var plants = dbContext.Plants.ToList();
foreach (var item in plants)
{
PlantModel model = new PlantModel();
model.PlantID = item.PlantID;
model.Status = item.Status.ToString();
model.PlantName = item.PlantName.ToString();
model.LastWateredTime = Common.GetPrettyDate(Convert.ToDateTime(item.LastCompleted));
DateTime Expired = Convert.ToDateTime(item.Reset);
if (Expired > DateTime.Now)
{
var diffInSeconds = (Expired - DateTime.Now).TotalSeconds;
model.TimeLeft = Convert.ToInt32(diffInSeconds);
}
list.Add(model);
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
public static void T_Elapsed(object sender, ElapsedEventArgs e)
{
dbContectionDataContext context = new dbContectionDataContext();
var plants = context.Plants.ToList();
foreach (var plant in plants)
{
if ((plant.LastCompleted < DateTime.Now.AddHours(-6)) && plant.Status == 'W')
{
RealTimeCalls.NotifyOnReminder(plant.PlantID);
Common.StatusUpdate(plant.PlantID, 'E');
}
else if ((plant.Reset < DateTime.Now.AddSeconds(-10)) && plant.Status == 'H')
{
Common.StatusUpdate(plant.PlantID, 'W');
RealTimeCalls.NotifyOnFreeToWater(plant.PlantID);
}
else if ((plant.Reset < DateTime.Now.AddSeconds(-30)) && plant.Status == 'R')
{
Common.StatusUpdate(plant.PlantID, 'W');
RealTimeCalls.NotifyOnFreeToWater(plant.PlantID);
}
}
}
