+ //Get all events
+ public List<Event> getAllEvents() {
+ List<Event> events=new ArrayList<Event>();
+ Cursor cursor=database.query(MySQLiteHelper.Name,allColumns,null,null,null,null,null);
+
+ for(cursor.moveToFirst();!cursor.isAfterLast();cursor.moveToNext()) {
+ Event ev=cursorToEvent(cursor);
+ events.add(ev);
+ }
+ return events;
+ }
+
+ private Event cursorToEvent(Cursor cursor) {
+ // TODO Auto-generated method stub
+ Event e = new Event();
+ e._id=cursor.getString(0);
+ e.title=cursor.getString(1);
+ e.description=cursor.getString(2);
+ e.date=cursor.getInt(3);
+ e.duration=cursor.getInt(4);
+ if(cursor.getInt(5)==1) e.repeat=true;
+ else e.repeat=false;
+ e.repeatInterval=cursor.getInt(6);
+ e.location=cursor.getString(7);
+ return e;
+ }