package com.michaelpwood.final_db_proj;

import android.app.Activity;
import android.content.Context;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.text.TextUtils;
import android.util.Patterns;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import static com.michaelpwood.final_db_proj.R.id.etEmail;

public class Main_Page extends Activity {

    EditText GetName,GetPhoneNumber,GetUsername, GetPassword, GetEmail ;
    Button Submit, EditData, DisplayData;
    SQLiteDatabase SQLITEDATABASE;
    String Name, PhoneNumber, Username, Password, Email ;
    Boolean CheckEditTextEmpty ;
    String SQLiteQuery ;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main__page);

        GetName = (EditText)findViewById(R.id.etName);

        GetPhoneNumber = (EditText)findViewById(R.id.etPhone);

        GetUsername = (EditText)findViewById(R.id.etUsername);

        GetPassword = (EditText)findViewById(R.id.etPassword);

        GetEmail = (EditText)findViewById(R.id.etEmail);

        Submit = (Button)findViewById(R.id.bSubmit);

        EditData = (Button)findViewById(R.id.bEdit);



        Submit.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {

                DBCreate();

                SubmitData2SQLiteDB();

            }
        });

        EditData.setOnClickListener(new View.OnClickListener() {

            @Override
            public void onClick(View v) {
                // TODO Auto-generated method stub

                Intent intent = new Intent(Main_Page.this, dbEdit.class);
                startActivity(intent);

            }
        });


    }

    public void DBCreate(){

        SQLITEDATABASE = openOrCreateDatabase("DemoDataBase", Context.MODE_PRIVATE, null);

        SQLITEDATABASE.execSQL("CREATE TABLE IF NOT EXISTS demoTable(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR, phone_number VARCHAR, Username VARCHAR, Password VARCHAR, Email VARCHAR);");
    }

    public void SubmitData2SQLiteDB(){

        Name = GetName.getText().toString();

        PhoneNumber = GetPhoneNumber.getText().toString();

        Username = GetUsername.getText().toString();

        Password = GetPassword.getText().toString();

        Email = GetEmail.getText().toString();

        CheckEditTextIsEmptyOrNot( Name,PhoneNumber,Username,Password,Email);

        if (isValidEmail(Email)) {


            if(CheckEditTextEmpty == true)
            {

                SQLiteQuery = "INSERT INTO demoTable (name,phone_number,Username,Password,Email) VALUES('"+Name+"', '"+PhoneNumber+"', '"+Username+"', '"+Password+"', '"+Email+"');";

                SQLITEDATABASE.execSQL(SQLiteQuery);

                Toast.makeText(Main_Page.this,"Data Submit Successfully", Toast.LENGTH_LONG).show();

                ClearEditTextAfterDoneTask();

            }
            else {

                Toast.makeText(Main_Page.this,"Please Fill All the Fields", Toast.LENGTH_LONG).show();
            }
        }
        else{
            Toast.makeText(Main_Page.this,"Invalid Email", Toast.LENGTH_LONG).show();
        }
    }

    public void CheckEditTextIsEmptyOrNot(String Name,String PhoneNumber, String Username, String Password, String Email ){

        if(TextUtils.isEmpty(Name) || TextUtils.isEmpty(PhoneNumber) || TextUtils.isEmpty(Username) || TextUtils.isEmpty(Password) || TextUtils.isEmpty(Email)){

            CheckEditTextEmpty = false ;

        }
        else {
            CheckEditTextEmpty = true ;
        }
    }

    public void ClearEditTextAfterDoneTask(){

        GetName.getText().clear();
        GetPhoneNumber.getText().clear();
        GetUsername.getText().clear();
        GetPassword.getText().clear();
        GetEmail.getText().clear();

    }
    /*
    function ValidateEmail(inputText)
    {
        var mailformat = /^w+([.-]?w+)*@w+([.-]?w+)*(.w{2,3})+$/;
        if(inputText.value.match(mailformat))
        {
            document.form1.text1.focus();
            return true;
        }
        else
        {
            alert("You have entered an invalid email address!");
            document.form1.text1.focus();
            return false;
        }
    }
    */
    // validating email id
    private boolean isValidEmail(CharSequence Email) {
        if (Email == null)  {
            return false;
        } else {
            return Patterns.EMAIL_ADDRESS.matcher(Email).matches();
        }
    }
}