Room Overview

public class RoomOverview extends Activity {

    public String value = CreateClient.getName();
    public String status = CreateRoom.getStatus();
    private ListView lvItem;
    private ArrayList<String> itemArrey;
    private ArrayAdapter<String> itemAdapter;
    public Cursor c, c2, c3, c4, c5, c6;
    SQLiteDatabase sampleDB;
    public static String selectedItem;
    ImageButton edit, delete;
    final Context context = this;
    public String typeToDelete;
    public static String getID[];

    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.roomoverview);

        edit = (ImageButton) findViewById(R.id.editButton);
        edit.setEnabled(false);
        edit.setAlpha(127);

        delete = (ImageButton) findViewById(R.id.deleteButton);
        delete.setEnabled(false);
        delete.setAlpha(127);

        lvItem = (ListView)this.findViewById(R.id.listView1);
        lvItem.setTextFilterEnabled(true);

        itemArrey = new ArrayList<String>();
        itemArrey.clear();

        itemAdapter = new ArrayAdapter<String>(getApplicationContext(), R.layout.single_item,itemArrey);
        lvItem.setAdapter(itemAdapter);

        if("Retrieve".equals(value)){
            sampleDB = getBaseContext().openOrCreateDatabase(ClientList.retrievedClient+".db", MODE_PRIVATE, null);
        }
        else if ("Create".equals(value)){
            sampleDB = getBaseContext().openOrCreateDatabase(CreateClient.createdClient+".db", MODE_PRIVATE, null);
        }

        if("Edit".equals(status)){
            TextView roomName = (TextView) findViewById(R.id.roomName);
            roomName.append(EditRoom.possiblyEditedRoom);
            c = sampleDB.rawQuery("SELECT * FROM tbl_plant WHERE r_id =?", new String[] {RoomList.r_id});
            c2 = sampleDB.rawQuery("SELECT * FROM tbl_windowData WHERE r_id =?", new String[] {RoomList.r_id});
            c3 = sampleDB.rawQuery("SELECT * FROM tbl_itData WHERE r_id =?", new String[] {RoomList.r_id});
            c4 = sampleDB.rawQuery("SELECT * FROM tbl_otherData WHERE r_id =?", new String[] {RoomList.r_id});
            c5 = sampleDB.rawQuery("SELECT * FROM tbl_heatingData WHERE r_id =?", new String[] {RoomList.r_id});
            c6 = sampleDB.rawQuery("SELECT * FROM tbl_lightingData WHERE r_id =?", new String[] {RoomList.r_id});
        }
        else if ("Create".equals(status)){
            TextView roomName = (TextView) findViewById(R.id.roomName);
            roomName.append(CreateRoom.selectedRoom);
            c = sampleDB.rawQuery("SELECT * FROM tbl_plant WHERE r_id =?", new String[] {CreateRoom.r_id});
            c2 = sampleDB.rawQuery("SELECT * FROM tbl_windowData WHERE r_id =?", new String[] {CreateRoom.r_id});
            c3 = sampleDB.rawQuery("SELECT * FROM tbl_itData WHERE r_id =?", new String[] {CreateRoom.r_id});
            c4 = sampleDB.rawQuery("SELECT * FROM tbl_otherData WHERE r_id =?", new String[] {CreateRoom.r_id});
            c5 = sampleDB.rawQuery("SELECT * FROM tbl_heatingData WHERE r_id =?", new String[] {CreateRoom.r_id});
            c6 = sampleDB.rawQuery("SELECT * FROM tbl_lightingData WHERE r_id =?", new String[] {CreateRoom.r_id});
        }

        lvItem.setOnItemClickListener(new OnItemClickListener() {
            public void onItemClick(AdapterView<?> parent, View view,
                    int position, long id) {
                // When clicked, show a toast with the TextView text

                selectedItem = (String) ((TextView) view).getText();
                if(selectedItem.contains("----------")){}
                else{
                    edit.setEnabled(true);
                    edit.setAlpha(255);
                    delete.setEnabled(true);
                    delete.setAlpha(255);

                    //Toast.makeText(getApplicationContext(), "item: "+selectedItem+" child: "+parent.getCount(), Toast.LENGTH_LONG).show();
                    for(int a=0; a<parent.getChildCount(); a++){
                        parent.getChildAt(a).setBackgroundColor(Color.WHITE);
                    }
                    view.setBackgroundColor(Color.parseColor("#97C361"));
                }
            }
        });
    }
}