package com.example.arellanouniversityparkingsystem;

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

import java.util.jar.Attributes;

public class DatabaseHelper extends SQLiteOpenHelper
{
    public DatabaseHelper(Context context) {
        super(context, "Login.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("Create table user(Username text primary key,password text)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("drop table if exists user");
    }
    //inserting in database
    public boolean insert(String Username, String password){
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put("Username",Username);
        contentValues.put("password",password);
        long ins = db.insert("user", null,contentValues);
        if (ins==-1) return false;
        else return true;

    }
    //checking if Username is existing;
    public Boolean chkUsername(String Username){
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery("Select * from user where Username=?",new String[]{Username});
        if (cursor.getCount()>0) return false;
        else return true;
    }
    //checking the email and password
    public Boolean Usernamepassword(String Username,String password){
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor cursor = db.rawQuery("select * from user where Username=? and password=?",new String[]{Username,password});
        if (cursor.getCount()>0) return true;
    }
}