Ejemplo n.º 1
0
  public ArrayList<String> ListaSala() {
    BDIntraMovil helper = new BDIntraMovil(this);
    SQLiteDatabase db = helper.getReadableDatabase();
    ArrayList<String> dev = null;
    try {
      helper.openDataBase();
      dev = new ArrayList<String>();
      Cursor c = db.rawQuery("SELECT nombre FROM sala ORDER BY nombre ASC", null);
      if (c.moveToFirst()) {
        do {
          String nombre = c.getString(0);
          dev.add(nombre);
        } while (c.moveToNext());
      }
      c.close();
      helper.close();

    } catch (Exception ex) {
      ex.printStackTrace();
      helper.close();
      return null;
    }
    return dev;
  }
Ejemplo n.º 2
0
  public void cargaSala() {
    BDIntraMovil helper = new BDIntraMovil(this);
    SQLiteDatabase db = helper.getReadableDatabase();
    String ss = spn.getSelectedItem().toString();
    helper.openDataBase();
    Cursor c = db.rawQuery("SELECT Nombre FROM sala WHERE Nombre='" + ss + "';", null);
    try {
      if (c.moveToFirst()) {
        String pi = c.getString(0);
        if (pi.equals("Sala A1")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa1);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A2")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa2);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A3")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa3);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A4")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa4);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A5")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa5);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A6")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa6);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A7")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa7);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A8")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa8);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A9")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa9);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A10")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sa10);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A11")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.s11);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A12")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.s12);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala A13")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.s11);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B1")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb1);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B2")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb2);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B3")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb3);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B4")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb4);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B5")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb5);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B6")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb6);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B7")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb7);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B8")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb8);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B9")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb9);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B10")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb10);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B11")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb11);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B12")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb12);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala B13")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sb13);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Laboratorio PG01")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.lbpg01);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Laboratorio TC3")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.lbtc3);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C1")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc1);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C2")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc2);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C4")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc3);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C4")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc4);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C5")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc5);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C6")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc6);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C7")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc7);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C8")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc8);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C9")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc9);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C10")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc10);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C11")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc11);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C12")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc12);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala C13")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sc13);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala D1")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sd1);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
        if (pi.equals("Sala F1")) {
          Matrix matrix = new Matrix();
          matrix.postRotate(90.0f);
          Bitmap original = BitmapFactory.decodeResource(getResources(), R.drawable.sf1);
          Bitmap rotatedBitmap =
              Bitmap.createBitmap(
                  original, 0, 0, original.getWidth(), original.getHeight(), matrix, true);
          ImageView imgRotate = (ImageView) findViewById(R.id.MapaSala);
          imgRotate.setImageBitmap(rotatedBitmap);
          imgRotate.setVisibility(View.VISIBLE);
        }
      }

      c.close();
      helper.close();
    } catch (Exception ex) {
      ex.printStackTrace();
      helper.close();
    }
  }