package com.badaksakti.pdt;

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

public class DBATools {
    public static final String KEY_PARAMETER = "Parameter";
    public static final String KEY_GPS = "GPS";
    public static final String KEY_LOKASI_IMPORT = "LokasiImport";
    public static final String KEY_LOKASI_EXPORT = "LokasiExport";
    public static final String KEY_LOKASI_GAMBAR = "LokasiGambar";
    
    private static final String TAG = "DBAdapter";
    
    private static final String DATABASE_NAME = "PDTdb5";
    private static final String DATABASE_TABLE = "DataTools";
    private static final int DATABASE_VERSION = 2;

    private static final String DATABASE_TOOLS_CREATE =
        "create table if not exists DataTools (Parameter VARCHAR, "
        + "GPS BOOLEAN, LokasiImport VARCHAR, LokasiExport VARCHAR, LokasiGambar VARCHAR);";    
    private static final String DATABASE_PELANGGAN_CREATE =
        "create table if not exists DataPelanggan (idPel integer primary key, "
        + "noKontrak VARCHAR, STkini VARCHAR, latitude VARCHAR, lokasi VARCHAR, "
        + "kondisiBaca VARCHAR, pemakaian VARCHAR, longitude VARCHAR, nama VARCHAR, "
        + "alamat VARCHAR, tarifDaya VARCHAR, WEPkini VARCHAR, kVARHkini VARCHAR );";
    private final Context context;    

    private DatabaseHelper DBHelper;
    private SQLiteDatabase db;

    public DBATools(Context ctx) 
    {
        this.context = ctx;
        DBHelper = new DatabaseHelper(context);
    }
        
    private static class DatabaseHelper extends SQLiteOpenHelper 
    {
        DatabaseHelper(Context context) 
        {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
        }

        @Override
        public void onCreate(SQLiteDatabase db) 
        {
        	try {        		
        		db.execSQL(DATABASE_TOOLS_CREATE);
        		db.execSQL(DATABASE_PELANGGAN_CREATE);
        	} catch (SQLException e) {
        		e.printStackTrace();
        	}
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) 
        {
            Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
                    + newVersion + ", which will destroy all old data");
            db.execSQL("DROP TABLE IF EXISTS DataTools");
            onCreate(db);
        }
    }    

    //---opens the database---
    public DBATools open() throws SQLException 
    {
        db = DBHelper.getWritableDatabase();
        return this;
    }

    //---closes the database---    
    public void close() 
    {
        DBHelper.close();
    }
    //---insert a record into the database---
    public long insertRecord(String Parameter, Boolean GPS, String LokasiImport, 
    		String LokasiExport, String LokasiGambar) 
    {
        ContentValues initialValues = new ContentValues();        
        initialValues.put(KEY_PARAMETER, Parameter);
        initialValues.put(KEY_GPS, GPS);
        initialValues.put(KEY_LOKASI_IMPORT, LokasiImport);
        initialValues.put(KEY_LOKASI_EXPORT, LokasiExport);
        initialValues.put(KEY_LOKASI_GAMBAR, LokasiGambar);
        return db.insert(DATABASE_TABLE, null, initialValues);
    }

    //---deletes a particular record---
    public boolean deleteAllRecord() 
    {
        return db.delete(DATABASE_TABLE, null, null) > 0;
    }
    
    //---deletes a particular record---
    public boolean deleteRecord(long rowId) 
    {
        return db.delete(DATABASE_TABLE, KEY_PARAMETER + "=" + rowId, null) > 0;
    }

    //---retrieves all the records---
    public Cursor getAllRecords() 
    {
        return db.query(DATABASE_TABLE, new String[] {KEY_PARAMETER, KEY_GPS, 
    		KEY_LOKASI_IMPORT, KEY_LOKASI_EXPORT, KEY_LOKASI_GAMBAR}, 
    		null, null, null, null, null);
    }

    //---retrieves a particular record---
    public Cursor getRecord(long Parameter) throws SQLException 
    {
        Cursor mCursor =
            db.query(true, DATABASE_TABLE, new String[] {KEY_PARAMETER, KEY_GPS, 
    		KEY_LOKASI_IMPORT, KEY_LOKASI_EXPORT, KEY_LOKASI_GAMBAR}, 
            KEY_PARAMETER + "=" + Parameter, null, null, null, null, null);
        if (mCursor != null) {
            mCursor.moveToFirst();
        }
        return mCursor;
    }

    //---updates a record---
    public boolean updateRecord(String Parameter, Boolean GPS, String LokasiImport, 
    		String LokasiExport, String LokasiGambar) 
    {
        ContentValues args = new ContentValues();
        args.put(KEY_GPS, GPS);
        args.put(KEY_LOKASI_IMPORT, LokasiImport);
        args.put(KEY_LOKASI_EXPORT, LokasiExport);
        args.put(KEY_LOKASI_GAMBAR, LokasiGambar);        
        return db.update(DATABASE_TABLE, args, KEY_PARAMETER + "=" + Parameter, null) > 0;
    }
}