package com.example.listdisplay;

        import android.database.Cursor;
        import android.database.sqlite.SQLiteDatabase;
        import android.os.Bundle;
        import android.app.Activity;
        import android.widget.ArrayAdapter;
        import android.widget.ListView;
        import android.widget.TextView;
        import android.widget.Toast;

        import java.io.File;
        import java.io.StringReader;
        import java.util.ArrayList;

public class ListDisplay extends Activity {
    // Array of strings...
    private String[] ABA = {"1","1","1","1","1","1"};

    private SQLiteDatabase db2;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

     //   Cursor cur
        ArrayAdapter adapter = new ArrayAdapter<String>(this,
                R.layout.activity_listview, ABA);
        TextView texttest = (TextView) findViewById(R.id.texttest);
        ListView listView = (ListView) findViewById(R.id.mobile_list);
        listView.setAdapter(adapter);

        opendb();
        insert();
       // show();

        /*String sql = "select * from AddressBookTable";
        Cursor c1 = db2.rawQuery(sql, null);
        c1.moveToPosition(-1);
        do{
            texttest.setText(c1.getString(0));
        }
        while (c1.moveToNext() );
        c1.close();*/
    }
   /* private void show(){
        String name;
        int phone;
        String email;
        try {
            // for (int i =0;i<mobileArray.size();i++){
            String sql = "select * from AddressBookTable";
            Cursor c1 = db2.rawQuery(sql, null);
            if (c1.getCount() == 0) {
                Toast.makeText(this, "add data", Toast.LENGTH_LONG).show();
            } else {

                for (int i=0;i<ABA.length;i++){

                    c1.moveToPosition(-1);

                    do {

                        name = c1.getString(0);
                        phone = c1.getInt(1);
                        email = c1.getString(2);
                        String phone2 = String.valueOf(phone);


                        ABA[i]=name+"n"+phone2+"n"+email;
                    } while (c1.moveToNext() && ABA.length<6);
                }

                c1.close();
                //  mobileArray[i].concat(name).concat(phone2).concat(email);

                //  }
            }
        }
        catch (Exception e){
            Toast.makeText(this,"data couldnt display ",Toast.LENGTH_LONG).show();

        }
    }*/

    private void opendb() {
        File storagePath = getApplication().getFilesDir();
        String mydbPath = storagePath + "/" + "ABD";
        try {

            db2 = SQLiteDatabase.openDatabase(mydbPath, null, SQLiteDatabase.CREATE_IF_NECESSARY);
            Toast.makeText(this, "DB Created", Toast.LENGTH_LONG).show();

        } catch (Exception e) {
            Toast.makeText(this, "Failed creating db", Toast.LENGTH_LONG).show();
            finish();
        }
    }

    private void insert() {

        db2.beginTransaction();
        try {
            db2.execSQL("create table AddressBookTable(" +
                    "name text," +
                    " phone integer, " +
                    "email text );  ");
            db2.setTransactionSuccessful();
            Toast.makeText(this, "table created", Toast.LENGTH_LONG).show();


        } catch (Exception e) {
            Toast.makeText(this, "failed creating table ", Toast.LENGTH_LONG).show();
            finish();
        } finally {
            db2.endTransaction();
        }

        //insertion
        db2.beginTransaction();
        try {
            db2.execSQL("insert into AddressBookTable(name,phone,email)" +
                    "values ('Abdullah','393939399','abdw2@gmail.com')");
            db2.execSQL("insert into AddressBookTable(name,phone,email)" +
                    "values ('norah','058389111','no3021@gmail.com')");
            db2.execSQL("insert into AddressBookTable(name,phone,email)" +
                    "values ('Suliman','043911933','suliman766@gmail.com')");
            db2.execSQL("insert into AddressBookTable(name,phone,email)" +
                    "values ('rana','058313466','rrr-1@gmail.com')");
            db2.execSQL("insert into AddressBookTable(name,phone,email)" +
                    "values ('khalid','038828822','kk291@gmail.com')");
            db2.execSQL("insert into AddressBookTable(name,phone,email)" +
                    "values ('Yazeed','038828822','kk291@gmail.com')");

            db2.setTransactionSuccessful();
            Toast.makeText(this, "row inserted ", Toast.LENGTH_LONG).show();

        } catch (Exception e) {
            Toast.makeText(this, "failed inserting ", Toast.LENGTH_LONG).show();

        } finally {
            db2.endTransaction();
        }


    }

}