package br.com.gameloop.partyapp;

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

public class MainActivity extends AppCompatActivity {

    // id
    // username
    // password

    public static SQLiteDatabase usersDatabase;

    private EditText usernameET;
    private EditText passwordET;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        // Criar ou Abrir o Banco de Dados:
        usersDatabase = openOrCreateDatabase("usersdb", MODE_PRIVATE, null);
        usersDatabase.execSQL("CREATE TABLE IF NOT EXISTS users(id INTEGER PRIMARY KEY, username VARCHAR, password VARCHAR);");

        usernameET = (EditText) findViewById(R.id.editTextUsername);
        passwordET = (EditText) findViewById(R.id.editTextPassword);

    }

    public void login(View v) {

        Cursor c = usersDatabase.rawQuery("SELECT * FROM users WHERE username = '" + usernameET.getText().toString() + "' AND password = '" + passwordET.getText().toString() + "'", null);
        c.moveToFirst();

        if(c.getCount() > 0) {
            startActivity(new Intent(this, ListParties.class));
        } else {
            Toast.makeText(MainActivity.this, "Login error!", Toast.LENGTH_SHORT).show();
        }

    }

    public static void signup(String username, String password) {

        usersDatabase.execSQL("INSERT INTO users (username, password) VALUES('" + username + "','" + password + "');");

    }

    public void showSignForm(View v) {
        Intent i = new Intent(MainActivity.this, SignUp.class);
        startActivity(i);
    }

}