package com.example.achma.simpasfinal;

/**
 * Created by achma on 08/08/2016.
 */
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase;

import java.util.ArrayList;

public class DBHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "password.db";
    public static final String TABLE_NAME = "master";
    public static final String TABLE_NAME1 = "pass_acc";
    public static final String COLUMN_MASTER0 = "id";
    public static final String COLUMN_MASTER1 = "password";
    public static final String COLUMN_MASTER2 = "pin";
    public static final String COLUMN_PASS0 = "id";
    public static final String COLUMN_PASS1 = "title";
    public static final String COLUMN_PASS2 = "username";
    public static final String COLUMN_PASS3 = "password";
    public static final String COLUMN_PASS4 = "website";
    public static final String COLUMN_PASS5 = "notes";

    private static DBHelper mDbHelper;

    public static synchronized DBHelper getInstance(Context context) {
        // Use the application context, which will ensure that you
        // don't accidentally leak an Activity's context.

        if (mDbHelper == null) {
            mDbHelper = new DBHelper(context.getApplicationContext());
        }
        return mDbHelper;
    }

    public DBHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }


    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table "+ TABLE_NAME + "(" + COLUMN_MASTER0 + " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_MASTER1 +
                " STRING, " + COLUMN_MASTER2 + " STRING);");
        db.execSQL("create table " + TABLE_NAME1 + "(" + COLUMN_PASS0 + " INTEGER PRIMARY KEY AUTOINCREMENT,"
                +  COLUMN_PASS1 + " STRING, " +  COLUMN_PASS2 + " STRING, " +  COLUMN_PASS3 + " STRING, " + COLUMN_PASS4
                + "  STRING," + COLUMN_PASS5 + " STRING);");
    }
    @Override

    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXIST " + TABLE_NAME);
    }
    //Checking table master
    public boolean isemptypas(){
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor mCursor = db.rawQuery("SELECT * FROM " + TABLE_NAME, null);
        Boolean rowExists;

        if (mCursor.moveToFirst())
        {
            // DO SOMETHING WITH CURSOR
            rowExists = true;

        } else
        {
            // I AM EMPTY
            rowExists = false;
        }
        return rowExists;
    }

    //Insert master password and master pin
    public void insertPass(){
        getset getset = new getset();
        SQLiteDatabase db = this.getWritableDatabase();
        String inspas = getset.getMasPass();
        String inspin = getset.getMaspin();
        ContentValues values = new ContentValues();
        values.put(COLUMN_MASTER1, inspas);
        values.put(COLUMN_MASTER2, inspin);
        db.insert(TABLE_NAME, null, values);
    }

    //Insert account data
    public void insertAkun(){
        getset getset = new getset();
        SQLiteDatabase db = this.getWritableDatabase();
        String inTitle = getset.getTitle2();
        String inUser = getset.getUsername2();
        String inPassword = getset.getPassword2();
        String inWeb = getset.getWebsite2();
        String inNotes = getset.getNotes2();

        ContentValues values = new ContentValues();
        values.put(COLUMN_PASS1, inTitle);
        values.put(COLUMN_PASS2, inUser);
        values.put(COLUMN_PASS3, inPassword);
        values.put(COLUMN_PASS4, inWeb);
        values.put(COLUMN_PASS5, inNotes);
        db.insert(TABLE_NAME1, null, values);
    }

    //Get master password and master pin for login
    public String ambilPass(String pin){
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor= db.query(TABLE_NAME, null, " " + COLUMN_MASTER2 + "=?", new String[]{pin}, null, null, null);
        if(cursor.getCount()<1) // UserName Not Exist
        {
            cursor.close();
            return String.valueOf(0);
        }
        cursor.moveToFirst();
        String password= cursor.getString(cursor.getColumnIndex("PASSWORD"));
        cursor.close();
        return password;
    }

    public getset getUser(int user_id) {
        SQLiteDatabase db = this.getReadableDatabase();

        Cursor cursor = db.query(TABLE_NAME1, new String[]{COLUMN_PASS0,
                        COLUMN_PASS1,}, COLUMN_PASS0 + "=?",
                new String[]{String.valueOf(user_id)}, null, null, null, null);
        if (cursor != null)
            cursor.moveToFirst();

        getset user = new getset();
        user.setId2(cursor.getString(1));
        user.setTitle2(cursor.getString(2));
        return user;
    }

    public ArrayList<getset> getAllUsers() {
        ArrayList<getset> usersList = new ArrayList<getset>();
        String selectQuery = "SELECT  * FROM " + TABLE_NAME1;

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

        // looping through all rows and adding to list
        if (cursor.moveToFirst()) {
            do {
                getset user = new getset();
                user.setId2(cursor.getString(1));
                user.setTitle2(cursor.getString(2));
                usersList.add(user);
            } while (cursor.moveToNext());
        }
        return usersList;
    }

    public int getUsersCount() {
        String countQuery = "SELECT  * FROM " + TABLE_NAME1;
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery(countQuery, null);
        cursor.close();
        return cursor.getCount();
    }
}