X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=src%2Fro%2Fieval%2Funical%2FUtils.java;h=3b53b479a90cce7964136bcbaeb759055f1a6f5c;hb=539deec9aa94ea7b7736b7597d9470a18204d7f8;hp=df57cda73262ff9f5ac6d13aeb1492cf786b9b0f;hpb=ea370609f2d174a59f8dafd5ddd229c5c41da940;p=unical.git diff --git a/src/ro/ieval/unical/Utils.java b/src/ro/ieval/unical/Utils.java index df57cda..3b53b47 100644 --- a/src/ro/ieval/unical/Utils.java +++ b/src/ro/ieval/unical/Utils.java @@ -5,8 +5,12 @@ import java.util.Locale; import android.app.AlarmManager; import android.app.PendingIntent; +import android.content.ContentValues; import android.content.Context; import android.content.Intent; +import android.database.Cursor; +import android.database.SQLException; +import android.database.sqlite.SQLiteDatabase; import android.view.View; import android.view.ViewGroup; @@ -25,10 +29,49 @@ final class Utils { public static String formatDate(final int year, final int month, final int day){ return String.format(Locale.ENGLISH, "%4d-%02d-%02d", year, month, day); } - - public static void setAlarm(final GregorianCalendar cal, final Context context) { - final PendingIntent pi = PendingIntent.getActivity(context, 1234, new Intent(context, AlarmReceiverActivity.class), PendingIntent.FLAG_CANCEL_CURRENT); - final AlarmManager am = (AlarmManager)context.getSystemService(Context.ALARM_SERVICE); - am.set(AlarmManager.RTC_WAKEUP, cal.getTimeInMillis(), pi); + + public static void addAlarm(final Application application, final long time, final long eventId) throws SQLException{ + final SQLiteDatabase db = application.alarmOpenHelper.getWritableDatabase(); + final ContentValues values = new ContentValues(2); + values.put(AlarmOpenHelper.TIME, time); + values.put(AlarmOpenHelper.EVENT, eventId); + db.insertOrThrow(AlarmOpenHelper.TABLE, null, values); + setAlarm(application, time, eventId); + } + + public static void deleteAlarm(final Application application, final long time) throws SQLException{ + final SQLiteDatabase db = application.alarmOpenHelper.getWritableDatabase(); + db.delete(AlarmOpenHelper.TABLE, AlarmOpenHelper.TIME + " = " + time, new String[0]); + unsetAlarm(application, time); + } + + public static Long[] getAlarmsByEvent(final Application application, final long eventId) throws SQLException{ + final SQLiteDatabase db = application.alarmOpenHelper.getWritableDatabase(); + db.delete(AlarmOpenHelper.TABLE, AlarmOpenHelper.TIME + " < " + System.currentTimeMillis(), new String[0]); + final Cursor cursor = db.query(AlarmOpenHelper.TABLE, new String[]{AlarmOpenHelper.TIME}, AlarmOpenHelper.EVENT + " = " + eventId, new String[0], null, null, null); + if(cursor.moveToFirst()){ + final Long[] ret = new Long[cursor.getCount()]; + for(int i=0;i