compile files('libs/jtds-1.2.7.jar')

import android.annotation.SuppressLint;
import android.os.StrictMode;
import android.util.Log;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class Connect_to_server {


    @SuppressLint("NewApi")
    public static Connection ConnectionHelper() {
        StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder()
                .permitAll().build();
        StrictMode.setThreadPolicy(policy);
        Connection connection = null;
        String ConnectionURL = null;

        String user = ***LOGIN_HERE***;
        String password = ***PASSWORD_HERE***;
        String database = ***DATABASE_NAME_HERE***;
        String server= ***SERVER_NAME_HERE***;

        try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            ConnectionURL = "jdbc:jtds:sqlserver://" + server + ";"
                    + "databaseName=" + database + ";user=" + user
                    + ";password=" + password + ";";
            connection = DriverManager.getConnection(ConnectionURL);
        } catch (SQLException se) {
            Log.e("ERRO", se.getMessage());
        } catch (ClassNotFoundException e) {
            Log.e("ERRO", e.getMessage());
        } catch (Exception e) {
            Log.e("ERRO", e.getMessage());
        }
        return connection;
    }

}

Connection connect;
Statement st;
Statement st1;
ResultSet rs;


 btn_Register.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View view) {


            try {
                connect = Connect_to_server.ConnectionHelper();
                st = connect.createStatement();

                // TODO i Will take ID_Admin from here
                rs = st.executeQuery("  SELECT * FROM [dbo].[AdminUsers]  WHERE Email = N'"+ET_email.getText()+"' ");

                if (rs.next()){

                    Toast.makeText(getApplicationContext(),rs.getString("Email")+"this email in database",LENGTH_LONG).show();
                    Intent i = new Intent(RegisterActivity.this , LoginActivity.class);
                    startActivity(i);
                    finish();


                }else{


                    reg();


                }



            } catch (Exception e) {

                Log.e("ERRO", e.getMessage());
            }

        }
    });


private void reg(){

    try {
        connect = Connect_to_server.ConnectionHelper();
        st1 = connect.createStatement();

        st1.execute("INSERT INTO [dbo].[AdminUsers]" +
                "           ([UserAdmin]" +
                "           ,[PassAdmin]" +
                "           ,[Address]" +
                "           ,[Phone]" +
                "           ,[Email])" +
                "     VALUES" +
                "           (N'"+ET_name.getText()+"'" +
                "           ,N'"+ET_password.getText() +"'" +
                "           ,N'"+ET_address.getText()+"'" +
                "           ,N'"+ET_phone.getText()+"'" +
                "           ,N'"+ET_email.getText()+"' )");



        Toast.makeText(getApplicationContext(),ET_name.getText()+"welcome ",LENGTH_LONG).show();

        Toast.makeText(getApplicationContext(),"u can login now",LENGTH_LONG).show();
        Intent i = new Intent(RegisterActivity.this , LoginActivity.class);
        startActivity(i);
        finish();


    } catch (Exception e) {

        Log.e("ERRO", e.getMessage());
        Log.e("ERRO", e.getMessage());
    }


}