Exemplo n.º 1
0
        private void Execute(SensorTask task)
        {
            task.repeatingDoneCount++;

            if (!task.isRepeating)
                task.isCompleted = true;
            else
            {
                if (task.repeatingNeededCount!=0
                    && task.repeatingDoneCount >= task.repeatingNeededCount)
                    task.isCompleted = true;

                if (task.executionValue == task.repeatingAValue)
                    task.executionValue = task.repeatingBValue;
                else
                    task.executionValue = task.repeatingAValue;

                if (!task.isCompleted)
                    task.executionDate = DateTime.Now.AddMilliseconds(task.repeatingInterval);
            }

            //we should not update the whole record, because other parts of the record can be updated from outside
            db.UpdateTask(
                task.db_Id,
                task.isCompleted,
                task.executionDate,
                task.executionValue,
                task.repeatingDoneCount);

            gateway.SendSensorState(task.nodeId, task.sensorId, task.executionValue);
        }
        public int AddOrUpdateTask(SensorTask task)
        {
            int db_Id=task.db_Id;

            SensorTask oldTask = GetTask(task.db_Id);

            if (oldTask == null)
                db_Id= AddTask(task);
            else
                UpdateTask(task);

            return db_Id;
        }
        public int AddTask(SensorTask task)
        {
            int db_Id;
            using (var db = new SqlConnection(connectionString))
            {
                db.Open();

                var sqlQuery = "INSERT INTO SensorsTasks (enabled,isCompleted,description, nodeId, sensorId, sensorDbId,sensorDescription, executionDate,dataType, executionValue,  isRepeating ,repeatingInterval,repeatingAValue,repeatingBValue,repeatingNeededCount,repeatingDoneCount) "
                             + "VALUES(@enabled,@isCompleted,@description, @nodeId, @sensorId, @sensorDbId,@sensorDescription, @executionDate, @dataType, @executionValue,  @isRepeating, @repeatingInterval, @repeatingAValue, @repeatingBValue, @repeatingNeededCount,@repeatingDoneCount); "
                            + "SELECT CAST(SCOPE_IDENTITY() as int)";

                db_Id = db.Query<int>(sqlQuery, task).Single();
            }
            return db_Id;
        }
Exemplo n.º 4
0
        public ActionResult New(SensorTask task)
        {
            Sensor sensor = gatewayDb.GetSensor(task.nodeId, task.sensorId);

            if (sensor == null)
                return new HttpNotFoundResult();

            if (task.isRepeating)
                task.executionValue = task.repeatingBValue;

            tasksDb.AddTask(task);
            context.Clients.Client(GatewayHubStaticData.gatewayId).updateSensorsTasks();
            return RedirectToAction("List",new {id1= task.nodeId,id2=task.sensorId});
        }
Exemplo n.º 5
0
        public ActionResult New(int? id1 = null, int? id2 = null)
        {
            if (id1 != null && id2 != null)
            {
                Sensor sensor = gatewayDb.GetSensor(id1.Value, id2.Value);

                if (sensor == null)
                    return new HttpNotFoundResult();

                Node node = gatewayDb.GetNodeByNodeId(sensor.ownerNodeId);
                ViewBag.description = sensor.GetSimpleName1();

                SensorTask task = new SensorTask
                {
                    nodeId = id1.Value,
                    sensorId = id2.Value,
                    sensorDbId = sensor.db_Id,
                    sensorDescription = string.Format("{0} {1}", node.GetSimpleName1(), sensor.GetSimpleName1()),
                    executionDate = DateTime.Now,
                    repeatingInterval = 1000,
                    enabled = true
                };

                SensorDataType? dataType = sensor.GetAllData()[0].dataType;
                task.dataType = dataType;

                if (dataType == SensorDataType.V_ARMED ||
                    dataType == SensorDataType.V_TRIPPED)
                {
                    task.executionValue = "1";
                    task.repeatingAValue = "0";
                    task.repeatingBValue = "1";
                }
                else if (dataType == SensorDataType.V_RGB)
                {
                    task.executionValue = "#FFFFFF";
                    task.repeatingAValue = "#000000";
                    task.repeatingBValue = "#FFFFFF";
                }
                else if (dataType == SensorDataType.V_RGBW)
                {
                    task.executionValue = "#FFFFFFFF";
                    task.repeatingAValue = "#FFFFFF00";
                    task.repeatingBValue = "#FFFFFFFF";
                }
                else if (dataType == SensorDataType.V_PERCENTAGE ||
                         dataType == SensorDataType.V_DIMMER)
                {
                    task.executionValue = "100";
                    task.repeatingAValue = "0";
                    task.repeatingBValue = "100";
                }
                return View(task);
            }
            else if (RouteData.Values.Count <= 2)
            {
                return RedirectToAction("NewSelect");
            }
            return new HttpNotFoundResult();
        }
 public void UpdateTask(SensorTask task)
 {
     using (var db = new SqlConnection(connectionString))
     {
         db.Open();
         var sqlQuery =
             "UPDATE SensorsTasks SET " +
             "enabled = @enabled, " +
             "isCompleted = @isCompleted, " +
             "description = @description, " +
             //"nodeId = @nodeId, " +
             //"sensorId = @sensorId, " +
             //"sensorDbId = @sensorDbId, " +
             //"sensorDescription = @sensorDescription, " +
             "executionDate = @executionDate, " +
             "dataType = @dataType, " +
             "executionValue = @executionValue, " +
             "isRepeating = @isRepeating, " +
             "repeatingInterval = @repeatingInterval, " +
             "repeatingAValue = @repeatingAValue, " +
             "repeatingBValue = @repeatingBValue, " +
             "repeatingNeededCount = @repeatingNeededCount, " +
             "repeatingDoneCount = @repeatingDoneCount " +
             "WHERE db_Id = @db_Id";
         db.Execute(sqlQuery, task);
     }
 }
Exemplo n.º 7
0
        public ActionResult New(SensorTask task)
        {
            Sensor sensor = gatewayDb.GetSensor(task.nodeId, task.sensorId);

            if (sensor == null)
                return new HttpNotFoundResult();

            if (task.isRepeating)
                task.executionValue = task.repeatingBValue;

            tasksDb.AddTask(task);

            GatewayAPIController gatewayApi = new GatewayAPIController();
            gatewayApi.UpdateSensorsTasks();

            return RedirectToAction("List", new { id = task.nodeId, id2 = task.sensorId });
        }
Exemplo n.º 8
0
        private void UpdateTasks(object sender, ElapsedEventArgs e)
        {
            updateTasksTimer.Stop();

            try
            {
                //to prevent changing of collection while writing to db is not yet finished
                SensorTask[] tasksTemp = new SensorTask[tasks.Count];
                tasks.CopyTo(tasksTemp);

                foreach (var task in tasksTemp)
                {
                    if (!task.isCompleted && task.enabled && task.executionDate <= DateTime.Now)
                        Execute(task);
                }
            }
            catch{}

            updateTasksTimer.Start();
        }