android/people/PeopleList.java

package com.grundfos.android.people;

import java.io.File;
import java.util.Date;

import android.app.AlertDialog;
import android.app.Dialog;
import android.app.ListActivity;
import android.app.ProgressDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.content.SharedPreferences;
import android.database.Cursor;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.text.Editable;
import android.text.TextWatcher;
import android.util.Log;
import android.view.KeyEvent;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.TextView;
import android.widget.TextView.OnEditorActionListener;

public class PeopleList extends ListActivity {

        
        public static final int DOWNLOAD = 1010;
        public static final int ABOUT = 1011;
        
        public static final String PREF_LAST_DB_UPDATE = "LastDbUpdate";
        public static final String PREFS = "PeoplePrefs";
        
        PeopleDatabase peopleDB;

        Dialog dialog;
        SimpleCursorAdapter adapter; 
    
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        
        peopleDB = new PeopleDatabase(this);
        
        
        adapter = new SimpleCursorAdapter(this,
                    R.layout.row, // Use a template
                                                          // that displays a
                                                          // text view
                    null , // Give the cursor to the list adatper
                    new String[] { "name", "inits", "company" }, // Map the NAME column in the
                                                         // people database to...
                    new int[] {R.id.name, R.id.init, R.id.company}); // The "text1" view defined in
                                                     // the XML template

         setListAdapter( adapter ) ;
        
        EditText et = (EditText) findViewById( R.id.entry);
        et.setOnEditorActionListener( new OnEditorActionListener() {
                public boolean  onEditorAction  (TextView v, int actionId, KeyEvent event) {
                        Log.e("Atest", "asd: " + event );
                        return true;
                }
                
        });
        et.addTextChangedListener( new TextWatcher() {
                public void afterTextChanged(Editable s) {
                        searchStringChanged(s.toString());
                }
                public void onTextChanged(CharSequence s, int start, int before, int count){
                }
                public void beforeTextChanged(CharSequence s, int start, int count, int after){
                }
        });
        
        
        if ( peopleDB.getPeopleCount() == 0)
                onEmptyDB();
        
        
        Log.i("PeopleList", "Activity started");        
    }
    

    @Override
        protected void finalize() throws Throwable {
        peopleDB.close();
                super.finalize();
        }


        public void onEmptyDB()
    {
                AlertDialog.Builder builder = new AlertDialog.Builder(this);
                builder.setMessage("Database is empty, download data now?")
                       .setCancelable(false)
                       .setPositiveButton("Yes", new DialogInterface.OnClickListener() {
                           public void onClick(DialogInterface dialog, int id) {
                                dialog.dismiss();
                                loadDatabase();
                           }
                       })
                       .setNegativeButton("No", new DialogInterface.OnClickListener() {
                           public void onClick(DialogInterface dialog, int id) {
                                dialog.cancel();
                           }
                       })
                       .show();    
    }
    
    public void searchStringChanged(String search)
    {
        Cursor names = null;
        if (search.trim().length() >= 2)
                names = peopleDB.getPeopleList(search);

        adapter.changeCursor(names);
        adapter.notifyDataSetChanged();
    }
    
    protected void  onListItemClick  (ListView l, View v, int position, long id)
    {
        Intent intent = new Intent(this, PeopleDetails.class);
        intent.putExtra("id", id);
        startActivity(intent);
    }


        @Override
        public boolean onOptionsItemSelected(MenuItem item) {
                
                switch (item.getItemId()) {
                case DOWNLOAD:
                        loadDatabase();
                        return true;
                case ABOUT:
                        showAbout();
                        return true;
                }
                
                return super.onOptionsItemSelected(item);
        }


        @Override
        public boolean onCreateOptionsMenu(Menu menu) {
                menu.add(0, DOWNLOAD, 0, "Download DB");
                menu.add(0, ABOUT, 0, "About");
                return true;

        }
        
        
        public void showAbout() {
                SharedPreferences settings = getSharedPreferences(PREFS, 0);
                StringBuffer message = new StringBuffer();
                message.append("Grundfos People v0.1\n");
                message.append("By Torben H�rup Nielsen\n");
                message.append("Database size: ").append(peopleDB.getPeopleCount()).append("\n");
                message.append("Last DB update: ").append( settings.getString(PREF_LAST_DB_UPDATE, " - never -"));
                
                showMessage(message.toString());

        }
        
        public void showMessage(String message) {
                AlertDialog.Builder builder = new AlertDialog.Builder(this);
                builder.setMessage(message)
                       .setCancelable(false)
                       .setPositiveButton("OK", new DialogInterface.OnClickListener() {
                           public void onClick(DialogInterface dialog, int id) {
                                dialog.dismiss();
                           }
                       })
                       .show();
                
        }

        public void loadDatabase()
        {
                dialog = ProgressDialog.show(this, "", "Loading. Please wait...", true);
                Thread t = new Thread(reloadDB);
                t.start();
        }

        
    private Handler dbUpdateHandler = new Handler() {

        @Override
        public void handleMessage(Message msg) {
                dialog.dismiss();
            if (msg.what == 0) { //success
                Date d = new Date();
                
                SharedPreferences settings = getSharedPreferences(PREFS, 0);

                SharedPreferences.Editor ed = settings.edit();                  
                ed.putString(PREF_LAST_DB_UPDATE, d.toLocaleString());
                ed.commit();
            } else {
                showMessage("Download failed");
                
            }
       }
    };

    Runnable reloadDB = new Runnable() {
                public void run() {
                        try
                        {
                                peopleDB.loadData();
                        dbUpdateHandler.sendEmptyMessage(0);
                        } catch (Exception e) {
                                dbUpdateHandler.sendEmptyMessage(1);
                        }               
                }
    };
}
1	package com.grundfos.android.people;
2
3	import java.io.File;
4	import java.util.Date;
5
6	import android.app.AlertDialog;
7	import android.app.Dialog;
8	import android.app.ListActivity;
9	import android.app.ProgressDialog;
10	import android.content.DialogInterface;
11	import android.content.Intent;
12	import android.content.SharedPreferences;
13	import android.database.Cursor;
14	import android.os.Bundle;
15	import android.os.Handler;
16	import android.os.Message;
17	import android.text.Editable;
18	import android.text.TextWatcher;
19	import android.util.Log;
20	import android.view.KeyEvent;
21	import android.view.Menu;
22	import android.view.MenuItem;
23	import android.view.View;
24	import android.widget.EditText;
25	import android.widget.ListView;
26	import android.widget.SimpleCursorAdapter;
27	import android.widget.TextView;
28	import android.widget.TextView.OnEditorActionListener;
29
30	public class PeopleList extends ListActivity {
31
32
33	public static final int DOWNLOAD = 1010;
34	public static final int ABOUT = 1011;
35
36	public static final String PREF_LAST_DB_UPDATE = "LastDbUpdate";
37	public static final String PREFS = "PeoplePrefs";
38
39	PeopleDatabase peopleDB;
40
41	Dialog dialog;
42	SimpleCursorAdapter adapter;
43
44	@Override
45	public void onCreate(Bundle savedInstanceState) {
46	super.onCreate(savedInstanceState);
47	setContentView(R.layout.main);
48
49	peopleDB = new PeopleDatabase(this);
50
51
52	adapter = new SimpleCursorAdapter(this,
53	R.layout.row, // Use a template
54	// that displays a
55	// text view
56	null , // Give the cursor to the list adatper
57	new String[] { "name", "inits", "company" }, // Map the NAME column in the
58	// people database to...
59	new int[] {R.id.name, R.id.init, R.id.company}); // The "text1" view defined in
60	// the XML template
61
62	setListAdapter( adapter ) ;
63
64	EditText et = (EditText) findViewById( R.id.entry);
65	et.setOnEditorActionListener( new OnEditorActionListener() {
66	public boolean onEditorAction (TextView v, int actionId, KeyEvent event) {
67	Log.e("Atest", "asd: " + event );
68	return true;
69	}
70
71	});
72	et.addTextChangedListener( new TextWatcher() {
73	public void afterTextChanged(Editable s) {
74	searchStringChanged(s.toString());
75	}
76	public void onTextChanged(CharSequence s, int start, int before, int count){
77	}
78	public void beforeTextChanged(CharSequence s, int start, int count, int after){
79	}
80	});
81
82
83	if ( peopleDB.getPeopleCount() == 0)
84	onEmptyDB();
85
86
87	Log.i("PeopleList", "Activity started");
88	}
89
90
91
92
93	@Override
94	protected void finalize() throws Throwable {
95	peopleDB.close();
96	super.finalize();
97	}
98
99
100
101	public void onEmptyDB()
102	{
103	AlertDialog.Builder builder = new AlertDialog.Builder(this);
104	builder.setMessage("Database is empty, download data now?")
105	.setCancelable(false)
106	.setPositiveButton("Yes", new DialogInterface.OnClickListener() {
107	public void onClick(DialogInterface dialog, int id) {
108	dialog.dismiss();
109	loadDatabase();
110	}
111	})
112	.setNegativeButton("No", new DialogInterface.OnClickListener() {
113	public void onClick(DialogInterface dialog, int id) {
114	dialog.cancel();
115	}
116	})
117	.show();
118	}
119
120	public void searchStringChanged(String search)
121	{
122	Cursor names = null;
123	if (search.trim().length() >= 2)
124	names = peopleDB.getPeopleList(search);
125
126	adapter.changeCursor(names);
127	adapter.notifyDataSetChanged();
128	}
129
130	protected void onListItemClick (ListView l, View v, int position, long id)
131	{
132	Intent intent = new Intent(this, PeopleDetails.class);
133	intent.putExtra("id", id);
134	startActivity(intent);
135	}
136
137
138	@Override
139	public boolean onOptionsItemSelected(MenuItem item) {
140
141	switch (item.getItemId()) {
142	case DOWNLOAD:
143	loadDatabase();
144	return true;
145	case ABOUT:
146	showAbout();
147	return true;
148	}
149
150	return super.onOptionsItemSelected(item);
151	}
152
153
154	@Override
155	public boolean onCreateOptionsMenu(Menu menu) {
156	menu.add(0, DOWNLOAD, 0, "Download DB");
157	menu.add(0, ABOUT, 0, "About");
158	return true;
159
160	}
161
162
163	public void showAbout() {
164	SharedPreferences settings = getSharedPreferences(PREFS, 0);
165	StringBuffer message = new StringBuffer();
166	message.append("Grundfos People v0.1\n");
167	message.append("By Torben H�rup Nielsen\n");
168	message.append("Database size: ").append(peopleDB.getPeopleCount()).append("\n");
169	message.append("Last DB update: ").append( settings.getString(PREF_LAST_DB_UPDATE, " - never -"));
170
171	showMessage(message.toString());
172
173	}
174
175	public void showMessage(String message) {
176	AlertDialog.Builder builder = new AlertDialog.Builder(this);
177	builder.setMessage(message)
178	.setCancelable(false)
179	.setPositiveButton("OK", new DialogInterface.OnClickListener() {
180	public void onClick(DialogInterface dialog, int id) {
181	dialog.dismiss();
182	}
183	})
184	.show();
185
186	}
187
188	public void loadDatabase()
189	{
190	dialog = ProgressDialog.show(this, "", "Loading. Please wait...", true);
191	Thread t = new Thread(reloadDB);
192	t.start();
193	}
194
195
196	private Handler dbUpdateHandler = new Handler() {
197
198	@Override
199	public void handleMessage(Message msg) {
200	dialog.dismiss();
201	if (msg.what == 0) { //success
202	Date d = new Date();
203
204	SharedPreferences settings = getSharedPreferences(PREFS, 0);
205
206	SharedPreferences.Editor ed = settings.edit();
207	ed.putString(PREF_LAST_DB_UPDATE, d.toLocaleString());
208	ed.commit();
209	} else {
210	showMessage("Download failed");
211
212	}
213	}
214	};
215
216	Runnable reloadDB = new Runnable() {
217	public void run() {
218	try
219	{
220	peopleDB.loadData();
221	dbUpdateHandler.sendEmptyMessage(0);
222	} catch (Exception e) {
223	dbUpdateHandler.sendEmptyMessage(1);
224	}
225	}
226	};
227	}