package com.example.databasesaveapp;

import java.text.SimpleDateFormat;
import java.util.Date;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseBloodPressure {
	public static final String MYDATABASE_NAME = "BloodPressureDB";
	public static final String MYDATABASE_TABLE = "BloodPressure";
	public static final int MYDATABASE_VERSION = 1;
	public static final String KEY_ID = "_id";
	public static final String KEY_PARA_ID = "paraid";
	public static final String KEY_PARAMETER = "paraname";

	public static final String KEY_SYSTOLIC_READING = "systolic";
	public static final String KEY_DISTOLIC_READING = "distolic";
	public static final String KEY_HEART_RATE = "heartrate";
	public static final String KEY_WEIGHT = "weight";
	public static final String KEY_TIME_READING = "readingtime";
	public static final String KEY_TIME_PICKER = "pickerreading";




	public static final String KEY_TIME = "time";
	public static final String KEY_SYCHRONIZE = "synchronize";



	//public static final String KEY_TIME = "time";


	// create table MY_DATABASE (ID integer primary key, Content text not null);
	private static final String SCRIPT_CREATE_DATABASE = "create table "
			+ MYDATABASE_TABLE + " ("
			+ KEY_ID	+ " integer primary key autoincrement, "
			+ KEY_PARA_ID 				+ " text, "
			+ KEY_PARAMETER 			+ " text, "
			+ KEY_SYSTOLIC_READING 		+ " text, "
			+ KEY_DISTOLIC_READING		+ " text, "
			+ KEY_HEART_RATE		+ " text, "
			+ KEY_WEIGHT			+ " text, "
			+ KEY_TIME_READING		+ " text, "
			+ KEY_TIME_PICKER		+ " text, "
			+ KEY_SYCHRONIZE 		+ " text, "
			+ KEY_TIME				+ " text);";

	private SQLiteHelper sqLiteHelper;
	private SQLiteDatabase sqLiteDatabase;

	private Context context;

	public DatabaseBloodPressure(Context c) {
		context = c;
	}

	public DatabaseBloodPressure openToRead()
			throws android.database.SQLException {
		sqLiteHelper = new SQLiteHelper(context, MYDATABASE_NAME, null,
				MYDATABASE_VERSION);
		sqLiteDatabase = sqLiteHelper.getReadableDatabase();
		return this;
	}

	public DatabaseBloodPressure openToWrite()
			throws android.database.SQLException
			{
		sqLiteHelper = new SQLiteHelper(context, MYDATABASE_NAME, null,
				MYDATABASE_VERSION);
		sqLiteDatabase = sqLiteHelper.getWritableDatabase();
		return this;
	}

	public void close() {
		sqLiteHelper.close();
		sqLiteDatabase.close();
	}

	public long insert(String Parameter, String histolic_Reading, String distolic_reading, String Sync, String heart_rate, String weight,String timereading,String timepickerreading)
	{
		SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		Date date = new Date();
		System.out.println("current date is " + date);

		// initialValues.put("date_created", dateFormat.format(date));
		// long rowId = mDb.insert(DATABASE_TABLE, null, initialValues);

		ContentValues contentValues = new ContentValues();
		contentValues.put(KEY_PARAMETER, Parameter);
		contentValues.put(KEY_SYSTOLIC_READING, histolic_Reading);
		contentValues.put(KEY_DISTOLIC_READING, distolic_reading);
		contentValues.put(KEY_HEART_RATE, heart_rate);
		contentValues.put(KEY_WEIGHT, weight);
		contentValues.put(KEY_TIME_READING, timereading);
		contentValues.put(KEY_TIME_PICKER, timepickerreading);


		contentValues.put(KEY_SYCHRONIZE, Sync);
		contentValues.put(KEY_TIME, dateFormat.format(date));

		return sqLiteDatabase.insert(MYDATABASE_TABLE, null, contentValues);
	}

//	public long insertOnlineData(String Parameter, String systolic_reading, String Sync,String para_id, String distolic_reading,String heart_rate,String weight) {
//		ContentValues contentValues = new ContentValues();
//		contentValues.put(KEY_SYSTOLIC_READING, systolic_reading);
//		contentValues.put(KEY_DISTOLIC_READING, distolic_reading);
//		contentValues.put(KEY_PARA_ID, para_id);
//		contentValues.put(KEY_HEART_RATE, heart_rate);
//		contentValues.put(KEY_WEIGHT, weight);
//		contentValues.put(KEY_SYCHRONIZE, Sync);
//
//		return sqLiteDatabase.insert(MYDATABASE_TABLE, null, contentValues);
//	}

	public int deleteAll() {
		return sqLiteDatabase.delete(MYDATABASE_TABLE, null, null);
	}

	public void delete_byID(int id) {
		sqLiteDatabase.delete(MYDATABASE_TABLE, KEY_ID + "=" + id, null);
	}

	@SuppressWarnings("unused")
	public void update_byID
		(int id, String paraID, String systolic_reading, String distolic_reading,String sync,String heart_rate,String weight,String reading,String timepickerreading) {
		SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		Date date = new Date();

		ContentValues values = new ContentValues();
		values.put(KEY_PARA_ID, paraID);
		values.put(KEY_SYSTOLIC_READING, systolic_reading);
		values.put(KEY_DISTOLIC_READING, distolic_reading);
		values.put(KEY_HEART_RATE, heart_rate);
		values.put(KEY_WEIGHT, weight);
		values.put(KEY_TIME_READING, reading);
		values.put(KEY_TIME_PICKER, timepickerreading);



		values.put(KEY_SYCHRONIZE, sync);
	//	values.put(KEY_TIME, dateFormat.format(date));

		sqLiteDatabase
				.update(MYDATABASE_TABLE, values, KEY_ID + "=" + id, null);
	}

	public Cursor queueAll() {
		String[] columns = new String[] { KEY_PARAMETER };
		Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns, null,
				null, null, null, null);
		return cursor;
	}

	public Cursor queuetoUpdate() {
		String[] columns = new String[] { KEY_ID, KEY_PARA_ID, KEY_PARAMETER,
				KEY_SYSTOLIC_READING, KEY_DISTOLIC_READING,KEY_HEART_RATE,KEY_WEIGHT,KEY_TIME_READING,KEY_TIME_PICKER, KEY_SYCHRONIZE };
		Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns, null,
				null, null, null, null);
		return cursor;
	}

	public Cursor getHistoryReadings()
	{
		Cursor cursor = null;
		String[] columns = new String[] { KEY_TIME, KEY_SYSTOLIC_READING, KEY_DISTOLIC_READING, KEY_HEART_RATE, KEY_WEIGHT,KEY_TIME_READING,KEY_TIME_PICKER};
		cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns, null, null, null, null, null);
		return cursor;
	}

	public class SQLiteHelper extends SQLiteOpenHelper {

		public SQLiteHelper(Context context, String name,
				CursorFactory factory, int version) {
			super(context, name, factory, version);
		}

		@Override
		public void onCreate(SQLiteDatabase db) {
			// TODO Auto-generated method stub
			db.execSQL(SCRIPT_CREATE_DATABASE);
		}

		@Override
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // stub
		}
	}

}