package com.damkell.kamera;
import java.io.ByteArrayOutputStream;
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.database.sqlite.SQLiteOpenHelper;
import android.graphics.Bitmap;
import android.graphics.Bitmap.CompressFormat;
import android.graphics.BitmapFactory;
import android.widget.Toast;




    public class DatabaseHandler extends SQLiteOpenHelper {
        // All Static variables
        // Database Version
        private static final int DATABASE_VERSION = 1;

        // Database Name
        private static final String DATABASE_NAME = "contactsManager";

        // Contacts table name
        private static final String TABLE_CONTACTS = "contacts";

        // Contacts Table Columns names
        private static final String KEY_ID = "id";
        private static final String KEY_NAME = "name";
        private static final String KEY_PH_NO = "phone_number";
        private static final String KEY_RAKTAS = "raktas";

        public DatabaseHandler(Context context) {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
        }

        // Creating Tables
        @Override
        public void onCreate(SQLiteDatabase db) {
            String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("
                    + KEY_ID + " INTEGER," + KEY_NAME + " TEXT,"
                    + KEY_RAKTAS + " TEXT" + ")";
            db.execSQL(CREATE_CONTACTS_TABLE);
        }

        // Upgrading database
        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            // Drop older table if existed
            db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);

            // Create tables again
            onCreate(db);
        }
        //Adding new contact
        public void addContact(String eilute, int kelintas, String kelintas2){
            SQLiteDatabase db = this.getWritableDatabase();
            ContentValues values = new ContentValues();
            values.put(KEY_NAME, eilute);
            values.put(KEY_ID, kelintas);
            values.put(KEY_RAKTAS,kelintas2);
            values.put(KEY_PH_NO, "ale");
            //Inserting row
            db.insert(TABLE_CONTACTS, null, values);
            db.close(); // Close database connection
        }

        //Getting single contact
        public String getContact(int id, int id2){
            String eilute = null;
            boolean tesk = true;
            SQLiteDatabase db = this.getReadableDatabase(); ////// eilute zemiau. CRASH
            Cursor cursor = db.query(TABLE_CONTACTS, new String[] {KEY_ID,KEY_RAKTAS},KEY_PH_NO + "=?",new String[] {String.valueOf(id2)},null,null,null,null);
            /*if(cursor != null){
                cursor.moveToFirst();
                eilute = cursor.getString(1);
            }*/
            if (eilute != null)
            return eilute;
            else return eilute = "NERA";
        }
        /*
        //Getting all contacts
        public List<Contact> getAllContacts(){
            List<Contact> contactList = new ArrayList<Contact>();
            //Selecting all query
            String selectQuery = "SELECT * FROM " + TABLE_CONTACTS;

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

            //Looping through all rows and adding to list
            if(cursor.moveToFirst()){
                do{
                    Contact contact = new Contact();
                    contact.setID(Integer.parseInt(cursor.getString(0)));
                    contact.setName(cursor.getString(1));
                    contact.setPhoneNumber(cursor.getString(2));
                    //adding contact to list
                    contactList.add(contact);
                } while (cursor.moveToNext());
            }

            return contactList;
        }

        //Getting contacts count
        public int getContactsCount(){
            String countQuery = "SELECT * FROM " + TABLE_CONTACTS;
            SQLiteDatabase db = this.getReadableDatabase();
            Cursor cursor = db.rawQuery(countQuery,null);
            cursor.close();

            //return count
            return cursor.getCount();
        }
        //Updating single contact
        public int updateContact(Contact contact){
            SQLiteDatabase db = this.getWritableDatabase();
            ContentValues values = new ContentValues();
            values.put(KEY_NAME, contact.getName());
            values.put(KEY_PH_NO, contact.getPhoneNumber());

            //Updating row
            return db.update(TABLE_CONTACTS,values,KEY_ID + "=?",new String[]{String.valueOf(contact.getID())});
        }

        //Deleting single contact
        public void deleteContact(Contact contact){
            SQLiteDatabase db = this.getWritableDatabase();
            db.delete(TABLE_CONTACTS, KEY_ID + "=?", new String[]{String.valueOf(contact.getID())});
            db.close();*/
}