package com.massurya.loginregister;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

import java.util.ArrayList;

public class Login extends AppCompatActivity {
    private EditText user,pass;
    private Button login;
    private SQLiteDatabase newDB;
    String TABLE_NAME="Login";
    private ArrayList<String> results = new ArrayList<String>();

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.login);
        user = (EditText)findViewById(R.id.user);
        pass = (EditText)findViewById(R.id.pass);
        login = (Button)findViewById(R.id.login);
        login.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                try {
                    DatabaseHelper dbHelper = new DatabaseHelper(Login.this);
                    newDB = dbHelper.getWritableDatabase();
                    Cursor c = newDB.rawQuery("SELECT username, password FROM " + TABLE_NAME
                            , null);

                    if (c != null) {
                        if (c.moveToFirst()) {
                            do {
                                String user = c.getString(c.getColumnIndex("username"));
                                String pass = c.getString(c.getColumnIndex("password"));
                            } while (c.moveToNext());
                        }
                    }
                } catch (SQLiteException se) {
                    Log.e(getClass().getSimpleName(), "Could not create or Open the database");
                }

                if (user.getText().toString().equals(user) && pass.getText().toString().equals(pass)){
                    Toast.makeText(Login.this,"Sukses Login",Toast.LENGTH_SHORT).show();
                }else{
                    Toast.makeText(Login.this,"Gagal Login",Toast.LENGTH_SHORT).show();
                }
            }
        });
    }

    private void openAndQueryDatabase() {

    }

    }