Add function to add event into local database

[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 a4d2580026880edac0a26896f6e3d77727b0345b..dd2dde10d17643e6365b78c8c964de7b8959a73f 100644 (file)
--- a/src/ro/ieval/unical/DatabaseInteract.java
+++ b/src/ro/ieval/unical/DatabaseInteract.java
@@ -1,5 +1,6 @@
 package ro.ieval.unical;
 
+import android.content.ContentValues;
 import android.content.Context;
 import android.database.SQLException;
 import android.database.sqlite.SQLiteDatabase;
@@ -7,6 +8,12 @@ import android.database.sqlite.SQLiteDatabase;
 public class DatabaseInteract {
        private SQLiteDatabase database;
        private MySQLiteHelper dbHelper;
+       private String[] allColumns = {
+                       MySQLiteHelper.ID, MySQLiteHelper.title, 
+                       MySQLiteHelper.description, MySQLiteHelper.date,
+                       MySQLiteHelper.duration, MySQLiteHelper.repeat,
+                       MySQLiteHelper.repeatIn, MySQLiteHelper.location
+       };
        
        public DatabaseInteract(Context context) {
                dbHelper = new MySQLiteHelper(context);
@@ -20,7 +27,18 @@ public class DatabaseInteract {
                dbHelper.close();
        }
        
-       //Add event
+       //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[5], e.repeat);
+               values.put(allColumns[6], e.repeatInterval);
+               values.put(allColumns[7], e.location);
+               database.insert(MySQLiteHelper.Name, null, values);
+       }
        //Delete event
        //Search event
 }