Use arguments for TrivialFragment

[unical.git] / src / ro / ieval / unical / DatabaseInteract.java

diff --git a/src/ro/ieval/unical/DatabaseInteract.java b/src/ro/ieval/unical/DatabaseInteract.java
index dd2dde10d17643e6365b78c8c964de7b8959a73f..520eba8c7c222e7686069117ca49867721671b2b 100644 (file)
--- a/src/ro/ieval/unical/DatabaseInteract.java
+++ b/src/ro/ieval/unical/DatabaseInteract.java
@@ -1,7 +1,11 @@
 package ro.ieval.unical;
 
+import java.util.ArrayList;
+import java.util.List;
+
 import android.content.ContentValues;
 import android.content.Context;
+import android.database.Cursor;
 import android.database.SQLException;
 import android.database.sqlite.SQLiteDatabase;
 
@@ -17,6 +21,7 @@ public class DatabaseInteract {
        
        public DatabaseInteract(Context context) {
                dbHelper = new MySQLiteHelper(context);
+               database=dbHelper.getWritableDatabase();
        }
        
        public void open() throws SQLException {
@@ -30,15 +35,45 @@ public class DatabaseInteract {
        //Insert event
        public void insertEvent(Event e) {
                ContentValues values = new ContentValues();
-               values.put(allColumns[1],e.title);
-               values.put(allColumns[2],e.description);
-               values.put(allColumns[3],e.date);
-               values.put(allColumns[4],e.duration);
+               values.put(allColumns[0], e._id);
+               values.put(allColumns[1], e.title);
+               values.put(allColumns[2], e.description);
+               values.put(allColumns[3], e.date);
+               values.put(allColumns[4], e.duration);
                values.put(allColumns[5], e.repeat);
                values.put(allColumns[6], e.repeatInterval);
                values.put(allColumns[7], e.location);
                database.insert(MySQLiteHelper.Name, null, values);
        }
        //Delete event
+       public void deleteEvent(String id) {
+               database.delete(MySQLiteHelper.Name, MySQLiteHelper.ID + "=" + id, null);
+       }
        //Search event
+       //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;
+       }
 }