package com.example.aleksander.sportsapp.activities;

import android.content.Intent;
import android.content.SharedPreferences;
import android.os.Handler;
import android.os.Looper;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.Toast;

import com.example.aleksander.sportsapp.R;
import com.example.aleksander.sportsapp.activities.MainMenu;
import com.example.aleksander.sportsapp.activities.Menu;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class Zaloguj extends AppCompatActivity {
    private SharedPreferences sharedPreferences;
    private SharedPreferences.Editor editor;
    public EditText login;
    public EditText password;
    public static Connection dbConnection;

Menu m;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.layout_zaloguj);
        login = findViewById(R.id.editText);
        password = findViewById(R.id.editText2);


    }


    public void zaloguj(View view) {
        new Thread() {
            @Override
            public void run() {
                super.run();
                try {
                    Class.forName("com.mysql.jdbc.Driver").newInstance();
                    dbConnection = DriverManager.getConnection("jdbc:mysql://10.0.2.2:3306/SportsApp", "user", "1234a");
                    // toast("dziala");

                } catch (SQLException e) {
                    e.printStackTrace();

                } catch (IllegalAccessException e) {
                    e.printStackTrace();
                } catch (InstantiationException e) {
                    e.printStackTrace();
                } catch (ClassNotFoundException e) {

                    e.printStackTrace();
                }

                if(dbConnection == null){
                    toast("brak polaczenia");
                    return;
                }
                try {
                   boolean log_in = false;
                    Statement zapytanie = dbConnection.createStatement();
                    ResultSet wynik = zapytanie.executeQuery("SELECT * FROM konto WHERE login='"+login.getText().toString()+"'");


                    while(wynik.next()){

                       // toast(wynik.getString("partiaMiesni"));
                       if(password.getText().toString().equals(wynik.getString("password"))) log_in=true;

                    }
if(log_in){
    SharedPreferences sharedPreferences = getSharedPreferences("dane", MODE_PRIVATE);
    SharedPreferences.Editor editor = sharedPreferences.edit();
    editor.putString("login", login.getText().toString());
    editor.commit();
    Intent i = new Intent(getApplicationContext(), MainMenu.class);
    startActivity(i);
} else toast("Podane login lub hasło są niepoprawne");

                } catch (SQLException e) {
                    e.printStackTrace();
                }

            }
        }.start();





//        Toast.makeText(this, "Podane login lub hasło są niepoprawne", Toast.LENGTH_LONG).show();


    }

    public void toast(final String text){
        Handler handler = new Handler(Looper.getMainLooper());
        handler.post(new Runnable() {
            @Override
            public void run() {
                Toast.makeText(getApplicationContext(), text, Toast.LENGTH_LONG).show();
            }
        });
    }
}