fgdfdgfg

package com.example.ryan.mymedicare;

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

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

/**
 * Created by Admin on 23/04/2017.
 */

public class DatabaseHelper extends SQLiteOpenHelper {

    private static final int DATABASE_VERSION = 1;

    private static final String DATABASE_NAME = "UserManager.db";

    private static final String TABLE_USER = "User";

    private static final String COLUMN_ID = "_id";
    private static final String COLUMN_NAME = "name";
    private static final String COLUMN_ADDRESS = "address";
    private static final String COLUMN_AGE = "age";
    private static final String COLUMN_EMAIL = "email";
    private static final String COLUMN_GPNAM = "gpname";
    private static final String COLUMN_GPNUM = "gpnumber";
    private static final String COLUMN_GPEM = "gpemail";
    private static final String COLUMN_PASSWORD = "password";

    private String CREATE_USER_TABLE = "CREATE TABLE " + TABLE_USER + "("
            +COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
            + COLUMN_NAME + " TEXT,"
            + COLUMN_ADDRESS + " TEXT,"
            + COLUMN_EMAIL + " TEXT,"
            + COLUMN_AGE + " TEXT,"
            + COLUMN_GPNAM + " TEXT,"
            + COLUMN_GPNUM + " TEXT,"
            + COLUMN_GPEM + " TEXT,"
            + COLUMN_PASSWORD + " TEXT" + ")";



    private String DROP_USER_TABLE = "DROP TABLE IF EXISTS " + TABLE_USER;

    public DatabaseHelper(Context context){
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }
    @Override
    public void onCreate(SQLiteDatabase db){
        db.execSQL(CREATE_USER_TABLE);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
        db.execSQL(DROP_USER_TABLE);
        onCreate(db);
    }

    public void addUser(User user) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put(COLUMN_NAME, user.getName());
        values.put(COLUMN_ADDRESS, user.getAddress());
        values.put(COLUMN_EMAIL, user.getEmail());
        values.put(COLUMN_AGE, user.getAge());
        values.put(COLUMN_GPNAM, user.getGpnam());
        values.put(COLUMN_GPNUM, user.getGpnum());
        values.put(COLUMN_GPEM, user.getGpem());
        values.put(COLUMN_PASSWORD, user.getPassword());

        db.insert(TABLE_USER, null, values);
        db.close();
    }

    public boolean checkUser(String email){
        String[] columns = {
                COLUMN_ID
        };
        SQLiteDatabase db = this.getWritableDatabase();
        String selection = COLUMN_EMAIL + " = ?";
        String[] selectionArgs = { email };

        Cursor cursor = db.query(TABLE_USER,
                columns,
                selection,
                selectionArgs,
                null,
                null,
                null);
        int cursorCount = cursor.getCount();
        cursor.close();
        db.close();

        if (cursorCount > 0){
            return true;
        }
        return false;
    }

    public boolean checkUser(String email, String password){
        String[] columns = {
                COLUMN_ID
        };
        SQLiteDatabase db = this.getWritableDatabase();
        String selection = COLUMN_EMAIL + " = ?" + " AND " + COLUMN_PASSWORD + " =?";
        String[] selectionArgs = { email, password };

        Cursor cursor = db.query(TABLE_USER,
                columns,
                selection,
                selectionArgs,
                null,
                null,
                null);

        int cursorCount = cursor.getCount();
        cursor.close();
        db.close();

        if (cursorCount > 0 ){
            return true;
        }
        return false;
    }

    public List<String> getDetails(String email, String password) {
        String[] columns = {
                COLUMN_NAME,
                COLUMN_ADDRESS,
                COLUMN_EMAIL,
                COLUMN_AGE,
                COLUMN_GPNAM,
                COLUMN_GPNUM,
                COLUMN_GPEM,
                COLUMN_PASSWORD,
                COLUMN_ID
        };
        SQLiteDatabase db = this.getReadableDatabase();

        String selection = COLUMN_EMAIL + " = ?" + " AND " + COLUMN_PASSWORD + " =?";
        String[] selectionArgs = { email, password };

        Cursor cursor = db.query(TABLE_USER,
                columns,
                selection,
                selectionArgs,
                null,
                null,
                null);

        cursor.moveToFirst();
        List<String> values = new ArrayList<>();
        for (int i=0; i < cursor.getColumnCount(); i++){
            values.add(cursor.getString(i));
        }
        cursor.close();
        db.close();
        return values;
    }

    public void updateDB(List<String> details) {
        SQLiteDatabase db = this.getReadableDatabase();
        ContentValues values = new ContentValues();
        values.put(COLUMN_NAME, details.get(0));
        values.put(COLUMN_ADDRESS, details.get(1));
        values.put(COLUMN_EMAIL, details.get(2));
        values.put(COLUMN_AGE, details.get(3));
        values.put(COLUMN_GPNAM, details.get(4));
        values.put(COLUMN_GPNUM, details.get(5));
        values.put(COLUMN_GPEM, details.get(6));
        values.put(COLUMN_PASSWORD, details.get(7));

        String id = details.get(8);

        String selection = COLUMN_ID + " LIKE ?";
        String[] selectionArgs = { id };

        int count = db.update(
                TABLE_USER,
                values,
                selection,
                selectionArgs);
    }


}