package com.example.pavelg.myapplication;

import android.Manifest;
import android.annotation.TargetApi;
import android.content.DialogInterface;
import android.content.pm.PackageManager;
import android.os.Build;
import android.support.annotation.RequiresApi;
import android.support.v4.app.ActivityCompat;
import android.support.v4.content.ContextCompat;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.text.Editable;
import android.view.View;
import android.widget.EditText;
import android.widget.TextView;

import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.sql.*;

public class MainActivity extends AppCompatActivity {
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

    }
    public static String SHA512(String target) {
        try {
            MessageDigest sh = MessageDigest.getInstance("SHA-512");
            sh.update(target.getBytes());
            StringBuilder sb = new StringBuilder();
            for (byte b : sh.digest()) sb.append(Integer.toHexString(0xff & b));
            return sb.toString();
        } catch (NoSuchAlgorithmException e) {
            throw new RuntimeException(e);
        }
    }
    @RequiresApi(api = Build.VERSION_CODES.KITKAT)
    public String geta(String data, String table, String a, Editable b){
        //String server   = getString(R.string.sql_server);
        String pwd      = getString(R.string.sql_password);
        String uname    = getString(R.string.sql_dbuname);
        //String dbname   = getString(R.string.sql_dbname);
        String results  = "";


        try {

            Connection conn = DriverManager.getConnection("jdbc:mysql://sql11.freemysqlhosting.net:3306/sqluname?autoReconnect=true", "sqldbname", "sqlpwd");
            Statement stmt = conn.createStatement();
            String query = "select `" + data + "` from `" + table + "` where `" + a + "` = '" + b + "'";
            ResultSet result = stmt.executeQuery(query);
            results = result.getString(data);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return results;
    }
    @TargetApi(Build.VERSION_CODES.KITKAT)
    @RequiresApi(api = Build.VERSION_CODES.KITKAT)
    public void login(View v){
        EditText loginn    = (EditText) findViewById(R.id.editText);
        EditText password = (EditText) findViewById(R.id.editText2);
        String siteSalt = "salt";
        String pSalt = geta("psalt","users","user_name",loginn.getText());

        String pwd = geta("pwd","users","user_name",loginn.getText());
        String sendPwd = SHA512(password.getText()+siteSalt+pSalt);
        TextView textView = (TextView) findViewById(R.id.textView);
        System.out.println(pwd + ", " + sendPwd);
        if (pwd == sendPwd){
            textView.setText("Successful");
        } else if (pwd != sendPwd){
            textView.setText("Wrong pass or user name");
        } else textView.setText("IDK WTF JUST HAPPENED!");
    }
    private void showExplanation(String title,
                                 String message,
                                 final String permission,
                                 final int permissionRequestCode) {
        AlertDialog.Builder builder = new AlertDialog.Builder(this);
        builder.setTitle(title)
                .setMessage(message)
                .setPositiveButton(android.R.string.ok, new DialogInterface.OnClickListener() {
                    public void onClick(DialogInterface dialog, int id) {
                        requestPermission(permission, permissionRequestCode);
                    }
                });
        builder.create().show();
    }

    private void requestPermission(String permissionName, int permissionRequestCode) {
        ActivityCompat.requestPermissions(this,
                new String[]{permissionName}, permissionRequestCode);
    }
}