public static Boolean EditSesnor(TblSensors sensor)
 {
     try
     {
         using (var db = new DBContextModel())
         {
             var old = db.TblSensors.Find(sensor.ID);
             if (old.RoomFK != sensor.RoomFK)
             {
                 var oldroom = db.TblRooms.Find(old.RoomFK);
                 if (db.TblSensors.Where(x => x.RoomFK == oldroom.ID).Count() <= 1)
                 {
                     oldroom.HasSensor       = false;
                     db.Entry(oldroom).State = EntityState.Modified;
                     db.SaveChanges();
                 }
                 var room = db.TblRooms.Find(sensor.RoomFK);
                 room.HasSensor       = true;
                 db.Entry(room).State = EntityState.Modified;
                 db.SaveChanges();
             }
             db.Entry(sensor).State = EntityState.Modified;
             db.SaveChanges();
             return(true);
         }
     }
     catch (Exception) { return(false); }
 }
Exemple #2
0
        public Object PutProfile([FromBody] TblSensors sensor)
        {
            Payload payload = BAccount.ConfirmToken(this.Request);

            if (payload == null || !payload.rol.Contains(6))
            {
                return(new { result = false, info = "Não autorizado." });
            }
            if (!BSensor.EditSesnor(sensor))
            {
                return(new { result = false, info = "Não foi possível alterar dados do sensor." });
            }
            return(new { result = true });
        }
Exemple #3
0
        public Object Post([FromBody] TblSensors sensor)
        {
            Payload payload = BAccount.ConfirmToken(this.Request);

            if (payload == null || !payload.rol.Contains(6))
            {
                return(new { result = false, info = "Não autorizado." });
            }
            if (!BSensor.CreateSesnor(sensor))
            {
                return(new { result = false, info = "Não foi possível registar a turma." });
            }
            return(new { result = true });
        }
 public static Boolean CreateSesnor(TblSensors sensor)
 {
     try
     {
         using (var db = new DBContextModel())
         {
             db.TblSensors.Add(sensor);
             db.SaveChanges();
             var room = db.TblRooms.Find(sensor.RoomFK);
             room.HasSensor       = true;
             db.Entry(room).State = EntityState.Modified;
             db.SaveChanges();
             return(true);
         }
     }
     catch (Exception) { return(false); }
 }