package com.teigrevena.optikos.database;

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.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class MainActivity extends AppCompatActivity {

    EditText myedittext;
    TextView myTextView ;
    Button btn;
    Button btn2;



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

        myTextView = (TextView) findViewById(R.id.textView4);
        myedittext= (EditText) findViewById(R.id.editText);
        btn = (Button)findViewById(R.id.button);
        btn2 = (Button)findViewById(R.id.button2);


        //ΔΗΜΙΟΥΡΓΙΑ ΒΑΣΗΣ ΕΑΝ ΔΕΝ ΥΠΑΡΧΕΙ
        final SQLiteDatabase mydatabase = openOrCreateDatabase("myonomadb",MODE_PRIVATE,null);

        //ΔΗΜΙΟΥΡΓΙΑ ΠΙΝΑΚΑ ΕΑΝ ΔΕΝ ΥΠΑΡΧΕΙ
        mydatabase.execSQL("CREATE TABLE IF NOT EXISTS mytbl(ID INTEGER PRIMARY KEY   AUTOINCREMENT, USERNAME TEXT NOT NULL, PHONE TEXT NOT NULL);");

//ΕΙΣΑΓΩΓΗ ΔΕΔΟΜΕΝΩΝ
        mydatabase.execSQL("INSERT INTO mytbl    (USERNAME, PHONE) VALUES ( 'KOKKONIS', '2462061626' );");
        mydatabase.execSQL("INSERT INTO mytbl    (USERNAME, PHONE) VALUES ( 'KOKKONIS2', '2462061623' );");

        btn.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                //ΑΝΑΖΗΤΗΣΗ ΔΕΔΟΜΕΝΩΝ
                Cursor c = mydatabase.rawQuery("SELECT * FROM mytbl WHERE USERNAME='"+myedittext.getText().toString()+"';", null);

                if (c.moveToFirst()) {
                    myTextView.setText(c.getString(2));
                }
                else { myTextView.setText("ΤΟ ΕΠΙΘΕΤΟ ΔΕΝ ΥΠΑΡΧΕΙ");}

                c.close();

            }// onclick
        }); //gia ton listener



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

                Intent intent = new Intent(MainActivity.this, Main2Activity.class);
                startActivity(intent);

            }
        });


    }
}