Android Open Source - bodyapps-android Measurement Manager

From Project

License

The source code is released under:
GNU Lesser General Public License
If you think the Android project bodyapps-android listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

/*
 * Copyright (c) 2014, Fashiontec (http://fashiontec.org)
 * Licensed under LGPL, Version 3//from ww w  . j  av a  2  s .co  m
 */

package fossasia.valentina.bodyapp.managers;

import java.util.ArrayList;
import java.util.List;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import fossasia.valentina.bodyapp.db.DBContract;
import fossasia.valentina.bodyapp.db.DatabaseHandler;
import fossasia.valentina.bodyapp.models.Measurement;
import fossasia.valentina.bodyapp.models.MeasurementListModel;
import fossasia.valentina.bodyapp.models.User;

/**
 * Manages the DB requests to measurements table
 */
public class MeasurementManager {
  private SQLiteDatabase database;
  private DatabaseHandler dbHandler;
  private Context context;
  private static MeasurementManager measurementManager;

  private MeasurementManager(Context context) {
    dbHandler = DatabaseHandler.getInstance(context);
    this.context = context;
  }

  public static MeasurementManager getInstance(Context context) {
    if (measurementManager == null) {
      measurementManager = new MeasurementManager(context);
    }
    return measurementManager;
  }

  public void addMeasurement(Measurement measurement) {
    Log.d("measurementmanager", "addMeasurement");
    this.database = this.dbHandler.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(DBContract.Measurement.COLUMN_NAME_ID, measurement.getID());
    values.put(DBContract.Measurement.COLUMN_NAME_USER_ID,
        measurement.getUserID());
    values.put(DBContract.Measurement.COLUMN_NAME_PERSON_ID,
        measurement.getPersonID());
    values.put(DBContract.Measurement.COLUMN_NAME_CREATED,
        measurement.getCreated());
    values.put(DBContract.Measurement.COLUMN_NAME_LAST_SYNC,
        measurement.getLastSync());
    values.put(DBContract.Measurement.COLUMN_NAME_LAST_EDIT,
        measurement.getLastEdit());
    values.put(DBContract.Measurement.COLUMN_NAME_UNIT,
        measurement.getUnit());
    values.put(DBContract.Measurement.COLUMN_NAME_MID_NECK_GIRTH,
        measurement.getMid_neck_girth());
    values.put(DBContract.Measurement.COLUMN_NAME_BUST_GIRTH,
        measurement.getBust_girth());
    values.put(DBContract.Measurement.COLUMN_NAME_WAIST_GIRTH,
        measurement.getWaist_girth());
    values.put(DBContract.Measurement.COLUMN_NAME_HIP_GIRTH,
        measurement.getHip_girth());
    values.put(
        DBContract.Measurement.COLUMN_NAME_ACROSS_BACK_SHOULDER_WIDTH,
        measurement.getAcross_back_shoulder_width());
    values.put(DBContract.Measurement.COLUMN_NAME_SHOULDER_DROP,
        measurement.getShoulder_drop());
    values.put(DBContract.Measurement.COLUMN_NAME_SHOULDER_SLOPE_DEGREES,
        measurement.getShoulder_slope_degrees());
    values.put(DBContract.Measurement.COLUMN_NAME_ARM_LENGTH,
        measurement.getArm_length());
    values.put(DBContract.Measurement.COLUMN_NAME_UPPER_ARM_GIRTH,
        measurement.getUpper_arm_girth());
    values.put(DBContract.Measurement.COLUMN_NAME_ARMSCYE_GIRTH,
        measurement.getArmscye_girth());
    values.put(DBContract.Measurement.COLUMN_NAME_HEIGHT,
        measurement.getHeight());
    values.put(DBContract.Measurement.COLUMN_NAME_HIP_HEIGHT,
        measurement.getHip_height());
    values.put(DBContract.Measurement.COLUMN_NAME_WRIST_GIRTH,
        measurement.getWrist_girth());

    database.insert(DBContract.Measurement.TABLE_NAME, null, values);
    database.close();
  }

  public void getch(String id) {
    Log.d("measurementmanager", "checkMeasurement");
    this.database = this.dbHandler.getReadableDatabase();
    Cursor cursor = database
        .query(DBContract.Measurement.TABLE_NAME,
            new String[] { DBContract.Measurement.COLUMN_NAME_MID_NECK_GIRTH },
            DBContract.Measurement.COLUMN_NAME_ID + " ='" + id
                + "'", null, null, null, null);

    if (cursor.moveToFirst()) {

      String out = cursor.getString(0);
      System.out.println(out);
      cursor.close();
      database.close();
    }
  }

  public List<MeasurementListModel> getList() {

    List<MeasurementListModel> measurementList = new ArrayList<MeasurementListModel>();

    String user = UserManager.getInstance(this.context).getCurrent();
    String selectQuery;
    if (user == null) {
      Log.d("measurementmanager", "user null");
      selectQuery = "SELECT  C." + DBContract.Measurement.COLUMN_NAME_ID
          + ", " + DBContract.Measurement.COLUMN_NAME_PERSON_ID
          + " AS pid" + ", "
          + DBContract.Measurement.COLUMN_NAME_CREATED + ", "
          + DBContract.Person.COLUMN_NAME_NAME + ", "
          + DBContract.Person.COLUMN_NAME_EMAIL + " FROM "
          + DBContract.Measurement.TABLE_NAME + " AS C JOIN "
          + DBContract.Person.TABLE_NAME + " AS R ON C."
          + DBContract.Measurement.COLUMN_NAME_PERSON_ID + " = R."
          + DBContract.Person.COLUMN_NAME_ID
          + " WHERE C."+DBContract.Measurement.COLUMN_NAME_USER_ID+" = 'NoUser'";
      System.out.println(selectQuery);
    } else {
      Log.d("measurementmanager", "user exists");
      selectQuery = "SELECT  C." + DBContract.Measurement.COLUMN_NAME_ID
          + ", " + DBContract.Measurement.COLUMN_NAME_PERSON_ID
          + " AS pid" + ", "
          + DBContract.Measurement.COLUMN_NAME_CREATED + ", "
          + DBContract.Person.COLUMN_NAME_NAME + ", "
          + DBContract.Person.COLUMN_NAME_EMAIL + " FROM "
          + DBContract.Measurement.TABLE_NAME + " AS C JOIN "
          + DBContract.Person.TABLE_NAME + " AS R ON C."
          + DBContract.Measurement.COLUMN_NAME_PERSON_ID + " = R."
          + DBContract.Person.COLUMN_NAME_ID
          + " WHERE C."+DBContract.Measurement.COLUMN_NAME_USER_ID+" = '"+user+"'";
      System.out.println(selectQuery);
    }

    SQLiteDatabase db = this.dbHandler.getReadableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);

    if (cursor.moveToFirst()) {
      do {
        MeasurementListModel msmnt = new MeasurementListModel();
        msmnt.setID(cursor.getString(0));
        msmnt.setPersonID(Integer.parseInt(cursor.getString(1)));
        msmnt.setCreated(cursor.getString(2));
        msmnt.setPersonName(cursor.getString(3));
        msmnt.setPersonEmail(cursor.getString(4));
        // Adding msmnt to list
        measurementList.add(msmnt);
      } while (cursor.moveToNext());
    }
    return measurementList;
  }

  public void setUserID(String ID) {
    Log.d("measurementManager", "setUserID");

    this.database = this.dbHandler.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(DBContract.Measurement.COLUMN_NAME_USER_ID, ID);
    database.update(DBContract.Measurement.TABLE_NAME, values,
        DBContract.Measurement.COLUMN_NAME_USER_ID + "='" + "NoID"
            + "'", null);
    database.update(DBContract.Measurement.TABLE_NAME, values,
        DBContract.Measurement.COLUMN_NAME_USER_ID + "='" + "NoUser"
            + "'", null);
    database.close();
  }
  
  public Measurement getMeasurement(String ID){
    Log.d("measurementmanager", "getMeasurement");
    this.database = this.dbHandler.getReadableDatabase();
    Cursor cursor = database
        .query(DBContract.Measurement.TABLE_NAME,DBContract.Measurement.allColumns,
            DBContract.Measurement.COLUMN_NAME_ID + " ='" + ID
                + "'", null, null, null, null);

    Measurement ms=null;
    if (cursor.moveToFirst()) {
      ms=new Measurement(cursor.getString(0),cursor.getString(1),cursor.getInt(2),Integer.parseInt(cursor.getString(6)));
      ms.setCreated(cursor.getString(3));
      ms.setLastSync(cursor.getString(4));
      ms.setLastEdit(cursor.getString(5));
      ms.setMid_neck_girth(cursor.getString(7));
      ms.setBust_girth(cursor.getString(8));
      ms.setWaist_girth(cursor.getString(9));
      ms.setHip_girth(cursor.getString(10));
      ms.setAcross_back_shoulder_width(cursor.getString(11));
      ms.setShoulder_drop(cursor.getString(12));
      ms.setShoulder_slope_degrees(cursor.getString(13));
      ms.setArm_length(cursor.getString(14));
      ms.setUpper_arm_girth(cursor.getString(15));
      ms.setArmscye_girth(cursor.getString(16));
      ms.setHeight(cursor.getString(17));
      ms.setHip_height(cursor.getString(18));
      ms.setWrist_girth(cursor.getString(19));
      
      cursor.close();
      database.close();
    }
    return ms;
  }
}
Java Source Code List
