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); } }
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 }); }
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); } }