Create an application which remands you some thing on selected date and time which
main.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical" >
<TextView
android:id="@+id/textView1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Time"
android:textAppearance="?android:attr/textAppearanceMedium" />
<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<EditText
android:id="@+id/editTexttime"
android:layout_width="300px"
android:layout_height="wrap_content"
android:editable="false" >
<requestFocus />
</EditText>
<Button
android:id="@+id/buttontime"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:text="Time" />
</LinearLayout>
<TextView
android:id="@+id/textView2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Date"
android:textAppearance="?android:attr/textAppearanceMedium" />
<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="horizontal" >
<EditText
android:id="@+id/editTextdate"
android:layout_width="300px"
android:layout_height="wrap_content"
android:editable="false" />
<Button
android:id="@+id/buttondate"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginLeft="10dp"
android:text="Date" />
</LinearLayout>
<TextView
android:id="@+id/textView3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Remainder Text"
android:textAppearance="?android:attr/textAppearanceMedium" />
<EditText
android:id="@+id/editTextremaindtext"
android:layout_width="match_parent"
android:layout_height="wrap_content" />
<RadioGroup
android:id="@+id/radioGroup1"
android:layout_width="wrap_content"
android:layout_height="wrap_content" >
<RadioButton
android:id="@+id/radiovibrate"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Vibrate" />
<RadioButton
android:id="@+id/radioring"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Ring" />
</RadioGroup>
<LinearLayout
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:gravity="center"
android:orientation="horizontal" >
<Button
android:id="@+id/buttonsave"
android:layout_width="200px"
android:layout_height="wrap_content"
android:text="Save" />
</LinearLayout>
</LinearLayout>
Graphical layout
Sqlite Helper class looks as fallows
public class SqliteHelper extends SQLiteOpenHelper {
static final String DBNAME = "DBNAME";
static final String REMAINDER_TABLE = "REMAINDER_TABLE";
static final String ID = "ID";
static final String TIME = "TIME";
static final String Date = "DATE";
static final String REMAIND_TEXT = "REMAIND";
static final String ALERT_FLAG = "ALERT_FLAG";
static final String ALERT_TYPE = "ALERT_TYPE";
public SqliteHelper(Context context) {
super(context, DBNAME, null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + REMAINDER_TABLE + " (" + TIME + " TEXT, "
+ Date + " TEXT, " + REMAIND_TEXT + " TEXT, " + ALERT_FLAG
+ " TEXT, " + ALERT_TYPE + " TEXT," + ID + " TEXT)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + REMAINDER_TABLE);
onCreate(db);
}
public int remaindMySchedule(String time, String date, String desc,
String flag, String type) {
SQLiteDatabase db = null;
int a = 0;
try {
db = this.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(TIME, time);
cv.put(Date, date);
cv.put(REMAIND_TEXT, desc);
cv.put(ALERT_FLAG, flag);
cv.put(ALERT_TYPE, type);
cv.put(ID, "" + Sequncer() + 1);
a = (int) db.insert(REMAINDER_TABLE, null, cv);
} catch (Exception e) {
Log.d("Exception", "Sorry" + e);
} finally {
db.close();
}
return a;
}
public ArrayList<HashMap<String, String>> CheckMyschedule(String time,
String date) {
SQLiteDatabase db = null;
Cursor cur = null;
ArrayList<HashMap<String, String>> DATA = new ArrayList<HashMap<String, String>>();
try {
db = this.getReadableDatabase();
String query = "SELECT " + REMAIND_TEXT + ", " + ALERT_FLAG + ","
+ ALERT_TYPE + "," + ID + " FROM " + REMAINDER_TABLE
+ " WHERE " + TIME + "='" + time + "' AND " + Date + "='"
+ date + "' AND " + ALERT_FLAG + "='true'";
Log.d("Message", "query" + query);
cur = db.rawQuery(query, null);
Log.d("Message", "count" + cur.getCount());
while (cur.moveToNext()) {
HashMap<String, String> values = new HashMap<String, String>();
values.put(REMAIND_TEXT, cur.getString(0));
values.put(ALERT_FLAG, cur.getString(1));
values.put(ALERT_TYPE, cur.getString(2));
values.put(ID, cur.getString(3));
DATA.add(values);
Log.d("Message", "values" + DATA.toString());
}
} catch (Exception e) {
e.printStackTrace();
// Log.d("Message", "Failed" + e);
} finally {
cur.close();
db.close();
}
return DATA;
}
private int Sequncer() {
// TODO Auto-generated method stub
SQLiteDatabase db = null;
Cursor cur = null;
int PK = 0;
try {
db = this.getReadableDatabase();
String query = "SELECT * FROM " + REMAINDER_TABLE;
cur = db.rawQuery(query, null);
if (cur.moveToNext()) {
PK = cur.getCount();
}
} catch (Exception e) {
Log.d("Message", "Failed" + e);
}
return PK;
}
public void FlagUpdate(String id) {
SQLiteDatabase db = null;
try {
db = this.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put(ALERT_FLAG, "false");
cv.put(ID, id);
int a = db.update(REMAINDER_TABLE, cv, ID + "=?",
new String[] { id });
Log.d("Message", "update-->" + a);
} catch (Exception e) {
e.printStackTrace();
}
}
}
Activity Class
public class Schedule extends Activity {
EditText time;
EditText date;
Button TimeBut;
Button DateBut;
EditText Remainder;
Button Save;
int hours, min, sec;
RadioButton vibrate;
RadioButton ring;
static final int ID = 3;
static String alert = "";
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
time = (EditText) findViewById(R.id.editTexttime);
date = (EditText) findViewById(R.id.editTextdate);
TimeBut = (Button) findViewById(R.id.buttontime);
DateBut = (Button) findViewById(R.id.buttondate);
Save = (Button) findViewById(R.id.buttonsave);
Save.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
startService(new Intent(Schedule.this, ServiceExample.class));
SaveRemainder();
}
});
vibrate = (RadioButton) findViewById(R.id.radiovibrate);
vibrate.setOnCheckedChangeListener(new OnCheckedChangeListener() {
@Override
public void onCheckedChanged(CompoundButton buttonView,
boolean isChecked) {
// TODO Auto-generated method stub
alert = "VIBRATE";
}
});
ring = (RadioButton) findViewById(R.id.radioring);
ring.setOnCheckedChangeListener(new OnCheckedChangeListener() {
@Override
public void onCheckedChanged(CompoundButton buttonView,
boolean isChecked) {
// TODO Auto-generated method stub
alert = "RING";
}
});
Remainder = (EditText) findViewById(R.id.editTextremaindtext);
TimeBut.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
onCreateDialog(ID).show();
}
});
Calendar cad = Calendar.getInstance();
hours = cad.get(Calendar.HOUR_OF_DAY);
min = cad.get(Calendar.MINUTE);
sec = cad.get(Calendar.SECOND);
UpdateTime();
}
TimePickerDialog.OnTimeSetListener datedata = new TimePickerDialog.OnTimeSetListener() {
@Override
public void onTimeSet(TimePicker view, int hourOfDay, int minute) {
// TODO Auto-generated method stub
hours = hourOfDay;
min = minute;
UpdateTime();
}
};
@Override
protected Dialog onCreateDialog(int id) {
switch (id) {
case ID:
return new TimePickerDialog(this, datedata, hours, min, true);
}
return null;
}
private void UpdateTime() {
this.time.setText(new StringBuilder().append(hours).append("-")
.append(min));
}
private void SaveRemainder() {
SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
String date = sdf.format(new Date());
Log.d("Time----->", time.getText().toString());
SqliteHelper sqliteHelper = new SqliteHelper(this);
int a = sqliteHelper.remaindMySchedule(time.getText().toString(), date,
Remainder.getText().toString(), "true", alert);
if (a > 0) {
Toast.makeText(this, "Done", Toast.LENGTH_LONG).show();
}
}
}
Service Class
This class used to check the time and date which is selected by user for every 3000 mill seconds
public class ServiceExample extends Service {
@Override
public IBinder onBind(Intent intent) {
return null;
}
@Override
public int onStartCommand(Intent intent, int flags, int startId) {
return START_STICKY;
}
@Override
public void onCreate() {
super.onCreate();
looper();
}
private void looper() {
Timer timer = new Timer();
timer.scheduleAtFixedRate(new TimerTask() {
@Override
public void run() {
Method();
}
}, 10, 30 * 1000);
}
void Method() {
SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
String date = sdf.format(new Date());
Log.d("Date", date);
SimpleDateFormat sdf2 = new SimpleDateFormat("HH-mm");
String time = sdf2.format(new Date());
Log.d("Message", time);
SqliteHelper helper = new SqliteHelper(this);
ArrayList<HashMap<String, String>> names = new ArrayList<HashMap<String, String>>();
names = helper.CheckMyschedule(time, date);
if (names.isEmpty()) {
Log.d("Message", "No data Found");
} else {
HashMap<String, String> values = names.get(0);
if (values.isEmpty()) {
Log.d("Message", "No data Found");
} else {
String text = values.get(SqliteHelper.REMAIND_TEXT);
Message message = new Message();
Bundle bundel = new Bundle();
bundel.putString("Name", text);
message.obj = bundel;
handler.sendMessage(message);
String id = values.get(SqliteHelper.ID);
helper.FlagUpdate(id);
}
}
}
private Handler handler = new Handler() {
public void handleMessage(android.os.Message msg) {
Toast.makeText(getApplicationContext(), "Hi Sai to day you have a meeting please check the details",Toast.LENGTH_LONG).show();
};
};
}
This is the screen when condition get satisfied throws a toast on the screen
get more about vibrate and ring options of the application
