package com.fands.hospitalmannagmentsystem.DataBaseHelper;

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

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

/**
 * Created by Fastlane on 15-11-2017.
 */

public class DataBase extends SQLiteOpenHelper {
        public static final String USERS_TABLE = "Home_Page";

        public static final String _PaitentName = "_paitentname";
        public static final String DoctorName = "DoctorName";
        public static final String _TimeStamp = "_TimeStamp";
        public static final String Record = "Record";

        static final String DB_NAME = "Hospital Managment";
        //Database Version
        static final int DB_VERSION = 1;

        private static final String CREATE_USERS_TABLE = "create table " + USERS_TABLE + "(" + _PaitentName
                + " TEXT, " + DoctorName + " TEXT, "+ _TimeStamp +"TEXT);";

        Context context;
	public DataBase(Context context) {

        super(context, DB_NAME, null, DB_VERSION);
        this.context = context;
    }


        @Override
        public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_USERS_TABLE);

    }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + USERS_TABLE);
        onCreate(db);

    }

    public void insertIntoUsers(String strpaitentname, String strDoctorname,String strTimestamp) {
        // 1. get reference to writable DB
        SQLiteDatabase db = this.getWritableDatabase();
        // 2. create ContentValues to add key "column"/value
        ContentValues values = new ContentValues();
        values.put(_PaitentName, strpaitentname);
        values.put(DoctorName, strDoctorname);
        values.put(_TimeStamp,strTimestamp);

        db.insert(USERS_TABLE, null, values);
        Log.i("Insertion",_PaitentName);
        db.close();
        Toast.makeText(context,"Inserted successfully!",Toast.LENGTH_LONG).show();
//		Log.i("Insertion","Inserted");
    }
//    public void update(String strId,String strDoj){
//        SQLiteDatabase db = this.getWritableDatabase();
//        ContentValues values = new ContentValues();
//        values.put(_ID, strId);
//        values.put(DATE_JOINING, strDoj);
//        db.update(USERS_TABLE, values, _ID + " = ? ", new String[]{strId});
//        Toast.makeText(context,"Updated successfully!",Toast.LENGTH_LONG).show();
//        Log.i("Updating", "updated");
//    }
//
    public List<ListActivityModel> getDataFromDB() {

        List<ListActivityModel> modelList = new ArrayList<ListActivityModel>();
        String query = "select * from " + USERS_TABLE;

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

        if (cursor.moveToFirst()) {
            do {
                ListActivityModel model = new ListActivityModel();

                model.setStrPaitentname(cursor.getString(0));
                model.setStrdoctorname(cursor.getString(1));
                model.setStrtimestamp(cursor.getString(2));

                modelList.add(model);
            } while (cursor.moveToNext());
        }
        cursor.close();
        return modelList;
    }
}