package id.com.rumahcoding.sekolahku

import android.content.ContentValues
import android.content.Context
import android.database.Cursor
import android.database.sqlite.SQLiteDatabase
import id.com.rumahcoding.sekolahku.model.Siswa
import java.util.ArrayList

class SiswaDataSource(context: Context) {
    private var database : SQLiteDatabase? = null
    private var helper : DatabaseHelper

    init {
        helper = DatabaseHelper(context)
    }

    private fun openAccess(){
        database = helper.writableDatabase
    }

    private fun closeAccess(){
        database?.close()
        helper.close()
    }

    fun insertStudent(siswa: Siswa){
        openAccess()
        var cv = ContentValues()
        cv.put(DatabaseHelper.COL_NAMADEPAN , siswa.namad)
        cv.put("nama_belakang" , siswa.namab)
        cv.put("no_hp" , siswa.noHp)
        cv.put("hobi" , siswa.hobi)
        cv.put("alamat" , siswa.alamat)
        cv.put("gender" , siswa.gender)
        cv.put("jenjang" , siswa.jenjang)
        cv.put("email" , siswa.email)
        cv.put("tgl_lahir" , siswa.tglLahir)
        var database =database
        var long = database?.insertOrThrow("siswa", null
            , cv)
        closeAccess()
    }

    private fun fetchRow(cursor: Cursor) : Siswa{
        var siswa  = Siswa()
        siswa.id = cursor.getInt(0)

        var index = cursor.getColumnIndex(DatabaseHelper.COL_NAMADEPAN)
        siswa.namad = cursor.getString(index)

        var indexNamab = cursor.getColumnIndex("nama_belakang")
        siswa.namab = cursor.getString(indexNamab)
        siswa.noHp = cursor.getString(3)
        siswa.jenjang = cursor.getString(4)
        siswa.hobi = cursor.getString(5)
        siswa.alamat= cursor.getString(6)
        siswa.email = cursor.getString(7)
        siswa.tglLahir= cursor.getString(8)
        siswa.gender= cursor.getString(9)
        return siswa



    }

    fun getAllData() : ArrayList<Siswa>{
        openAccess()
        var cursor = database?.rawQuery("" +
                "SELECT * FROM siswa", null)
        cursor?.moveToFirst()

        var listAll = ArrayList<Siswa> ()

        while (!cursor!!.isAfterLast){
            var oneRowSiswa = fetchRow(cursor)
            listAll.add(oneRowSiswa)
            cursor.moveToNext()
        }
        cursor.close()
        closeAccess()
        return listAll

    }




}