package com.example.dan.tictactoe;


        import android.content.Intent;
        import android.os.Bundle;
        import android.os.StrictMode;
        import android.support.v7.app.AppCompatActivity;
        import android.support.v7.widget.Toolbar;
        import android.view.View;
        import android.view.Menu;
        import android.view.MenuItem;
        import android.view.animation.Animation;
        import android.view.animation.AnimationUtils;
        import android.widget.Button;
        import android.widget.EditText;
        import android.widget.TextView;
        import android.content.Intent;


        import java.sql.Connection;
        import java.sql.DriverManager;
        import java.sql.ResultSet;
        import java.sql.Statement;


public class LoginActivity extends AppCompatActivity implements View.OnClickListener {

    String dbUsername = "user_db_1423961_AndroidGame";
    String dbPassword = "Hellomate8";
    String connString = "jdbc:jtds:sqlserver://SQL2014.studentwebserver.co.uk";
    Statement stmt;

    EditText username;
    EditText password;
    Button butLog;
    Button butReg;

    protected void onCreate(Bundle savedInstanceState) {
        StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
        StrictMode.setThreadPolicy(policy);
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_login);

        username = (EditText) findViewById(R.id.editUsername);
        password = (EditText) findViewById(R.id.editPassword);
        butLog = (Button) findViewById(R.id.but_login);
        butReg = (Button) findViewById(R.id.but_Reg);

        connectToDb();

        butLog.setOnClickListener(this);
        checkPasswordDb();
        {
            switch (butLog.getId()) {
                case R.id.but_login:

                    break;
            }


        }

        butReg.setOnClickListener(this) ;
        {
            switch (butReg.getId()) {
                case R.id.but_Reg:
                    addUser();
                    break;
            }


        }

    }


    public void onClick(View v) {
        if (checkPasswordDb()) {
            Intent i = new Intent(this, MainActivity.class);
            startActivity(i);

        }


    }



    private void connectToDb(){
        checkPasswordDb();
        try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
            Connection DbConn = DriverManager.getConnection(connString, dbUsername, dbPassword);
            stmt = DbConn.createStatement();
        } catch (Exception e) {
        }    }




    public boolean addUser()

    {
        String sql = "INSERT INTO Users VALUES( '" + username.getText().toString() + "','" +
                password.getText().toString() + "')";
        try {
            stmt.executeUpdate(sql);
            return true;
        } catch (Exception e) {
            return false;
        }
    }

    public boolean checkPasswordDb() {
        String sql;
        sql = "SELECT * FROM Users WHERE username = '" + username.getText().toString() + "'";
        try {
            ResultSet rst = stmt.executeQuery(sql);
            rst.next();
            if(rst.getString("Password").equals(password.getText().toString()))
                return true;
            else
                return false;
        } catch (Exception e) {
            return false;
        }
    }
}