import android.content.Context;

import android.content.Intent;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;

import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;


public class MainActivity extends AppCompatActivity {


    EditText usuario, pass;
    TextView txtResultado;
    SQLiteDatabase db;
    Button btnAceptar, btnBorrar, btnRegistrar;

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

        cargarWidget();

        btnAceptar.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
               comprobacionUsuario(v);
            }
        });

        btnRegistrar.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                Intent pantalla = new Intent(getApplicationContext(), RegistroActivity.class);
                startActivity(pantalla);
            }
        });


        btnBorrar.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

            }
        });

        db=openOrCreateDatabase("UsersDefinitiva", Context.MODE_PRIVATE, null);
        db.execSQL("CREATE TABLE IF NOT EXISTS users(usuario CHAR PRIMARY KEY, pass CHAR);");
       // db.execSQL("CREATE TABLE IF NOT EXISTS datos(usuario_id VARCHAR(10) PRIMARY KEY, nombre VARCHAR(10), color VARCHAR(10), edad INT(10), ciudad VARCHAR(10));");
        db.execSQL("DELETE FROM users");
       // db.execSQL("DELETE FROM datos");
        db.execSQL("INSERT INTO users VALUES ('root','123');");
      //  db.execSQL("INSERT INTO datos VALUES ('root','Pedro','verde','20','Murcia');");

       // crearDB();
        Listar();

    }


    public void comprobacionUsuario(View v){

        Boolean correctUser = false;
        Boolean correctPass = false;

        String usr = usuario.getText().toString();
        String password = pass.getText().toString();


            Cursor c = db.rawQuery("SELECT * FROM users", null);

            while (c.moveToNext()) {
                if (c.getString(0).equals(usr) && c.getString(1).equals(password)) {
                    Intent intent = new Intent(MainActivity.this, DatosActivity.class);
                    intent.putExtra("usr", usr);
                    startActivity(intent);
                    break;
                } else {
                    Toast toast1 =
                            Toast.makeText(getApplicationContext(),
                                    "Usuario o clave incorrectos.", Toast.LENGTH_SHORT);

                    toast1.show();
                }
                c.close();
            }
    }



    public void Listar()
    {

        Cursor x = db.rawQuery("SELECT * FROM users", null);

        txtResultado.setText("");
        if (x.getCount()==0)
            txtResultado.setText("No hay registros");
        else {
            while (x.moveToNext())
                txtResultado.append(" " + x.getString(0) + " - " + x.getString(1) + "\n");
        }

        x.close();
    }


    private void cargarWidget(){
        usuario = (EditText)findViewById(R.id.editUsuario);
        pass = (EditText)findViewById(R.id.editPass);
        btnAceptar = (Button) findViewById(R.id.btnAceptar);
        btnBorrar = (Button) findViewById(R.id.btnEliminar);
        btnRegistrar = (Button) findViewById(R.id.btnRegistrar);
        txtResultado=(TextView)findViewById(R.id.txtResultado);
    }

    public void crearDB(){

        Listar();

    }
}