package com.example.nir.nestleapp;

import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

import org.w3c.dom.Text;

import java.util.ArrayList;

public class LoginActivity extends AppCompatActivity {
    MyDBHandler Newdb;
    private SQLiteDatabase _database = null;
    private MyDBHandler  _dbHelper = null;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_login);
        Newdb = new MyDBHandler(this);
        _dbHelper = new MyDBHandler(getApplicationContext());
        _database = this.openOrCreateDatabase(MyDBHandler.DATABASE_NAME, MODE_PRIVATE, null);
        SQLiteDatabase database=_dbHelper.getReadableDatabase();
        final ArrayList list = new ArrayList();
        final TextView RegisterPage=(TextView)findViewById(R.id.textView4);
        TextView Text1=(TextView)findViewById(R.id.textView3);
        Button Login=(Button)findViewById(R.id.LoginBtn);
        Button GuestLogin=(Button)findViewById(R.id.LoginGuestBtn);
        final EditText LoginUser=(EditText)findViewById(R.id.LoginUser);
        final EditText LoginPass=(EditText)findViewById(R.id.LoginPassword);
        RegisterPage.setTextSize(17);
        Text1.setTextSize(17);
        RegisterPage.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                startActivity(new Intent(LoginActivity.this,RegisterActivity.class));
            }
        });
        GuestLogin.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                startActivity(new Intent(LoginActivity.this,MainPageActivity.class));
            }
        });
        Cursor c = database.rawQuery("SELECT * FROM " + MyDBHandler.Table_Name, null);
        if (c == null) return;
        if (c.moveToFirst()) {
            while ( !c.isAfterLast() ) {
                list.add(c.getString(0));
                list.add(c.getString(1));
                c.moveToNext();
            }
        }
        Login.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                if(LoginUser.getText().toString().isEmpty()||LoginPass.getText().toString().isEmpty())
                {
                    Toast.makeText(LoginActivity.this, "", Toast.LENGTH_SHORT).show();
                }
                if(list.contains(LoginUser.getText().toString())&&list.contains(LoginPass.getText().toString()))
                {
                    Toast.makeText(LoginActivity.this, "!", Toast.LENGTH_SHORT).show();
                    startActivity(new Intent(LoginActivity.this, MainPageActivity.class));
                }
                else
                {
                    Toast.makeText(LoginActivity.this, "wrong", Toast.LENGTH_SHORT).show();
                }
            }
        });
    }
}

package com.example.nir.nestleapp;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class MyDBHandler extends SQLiteOpenHelper {
    public static final int DATABASE_VERSION = 1;
    public static final String DATABASE_NAME = "UsersTable.db";
    public static final String Table_Name = "UsersTable";
    public static final String KEY_User = "User";
    public static final String KEY_Password = "Password";
    public static final String KEY_FullName = "FullName";
    public static final String KEY_PhoneNumber="PhoneNumber";
    public static final String KEY_IDNUMBER="IDNumber";
    public static final String[] DB_COL = new String[]{KEY_User,KEY_Password,KEY_FullName,KEY_PhoneNumber,KEY_IDNUMBER};

    public MyDBHandler(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String CreateTableSql = "Create Table " + Table_Name + " ( " +
                KEY_User + " INTEGER PRIMARY KEY AUTOINCREMENT , " +
                KEY_Password + " TEXT , " +
                KEY_FullName + " TEXT , "+
                KEY_PhoneNumber+" TEXT , "+
                KEY_IDNUMBER+ " ) ";
        db.execSQL(CreateTableSql);
    }@Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + Table_Name);
        onCreate(db);
    }

    public void Add(UserTable NewUser) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put(KEY_User,NewUser.GetUserName() );
        values.put(KEY_Password, NewUser.GetPassword());
        values.put(KEY_FullName,NewUser.GetFullName());
        values.put(KEY_PhoneNumber,NewUser.GetPhoneNumber());
        values.put(KEY_IDNUMBER,NewUser.GetID());
        db.insert(Table_Name, null, values);
        db.close();
    }


}