X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;ds=sidebyside;f=src%2Fro%2Fieval%2Funical%2FUtils.java;h=3b53b479a90cce7964136bcbaeb759055f1a6f5c;hb=539deec9aa94ea7b7736b7597d9470a18204d7f8;hp=74fa1a2371cacea31bc46ff632928aac24e1a046;hpb=361c6a289ebad738be848ce8db42b40428600891;p=unical.git diff --git a/src/ro/ieval/unical/Utils.java b/src/ro/ieval/unical/Utils.java index 74fa1a2..3b53b47 100644 --- a/src/ro/ieval/unical/Utils.java +++ b/src/ro/ieval/unical/Utils.java @@ -1,9 +1,22 @@ package ro.ieval.unical; +import java.util.GregorianCalendar; +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; final class Utils { + private Utils(){ /* do nothing */ } + public static void setEnabledRecursively(final View view, final boolean enabled){ view.setEnabled(enabled); if(view instanceof ViewGroup){ @@ -12,4 +25,53 @@ final class Utils { setEnabledRecursively(group.getChildAt(i), enabled); } } + + 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 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