public static int updateTODO(TODO todo) { using (SQLiteConnection con = new SQLiteConnection(dbPath)) { return(con.Update(todo)); } }
public static int addTODO(TODO todo) { using (SQLiteConnection con = new SQLiteConnection(dbPath)) { var res = con.Insert(todo); return(res); } }
public void Remind(TODO todo) { var alarmIntent = new Intent(this, typeof(AlarmReceiver)); alarmIntent.PutExtra("title", todo.name); alarmIntent.PutExtra("message", todo.description); var pending = PendingIntent.GetBroadcast(this, 0, alarmIntent, PendingIntentFlags.UpdateCurrent); var alarmManager = GetSystemService(AlarmService).JavaCast <AlarmManager>(); alarmManager.Set(AlarmType.ElapsedRealtime, todo.alertTime.Ticks * 1000, pending); }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); // Set our view from the "main" layout resource SetContentView(Resource.Layout.Main); // Get our button from the layout resource, addMove = FindViewById <Button>(Resource.Id.moveAdd); addMove.Click += delegate { var next = new Intent(this, typeof(TODODetailActivity)); StartActivity(next); }; incompleteList = FindViewById <ListView>(Resource.Id.incompleteList); var incomleteTODOs = TODO.getTODO().Where(todo => !todo.completed).ToList(); var adapter = new CustomAdapter(this, incomleteTODOs); incompleteList.Adapter = adapter; incompleteList.ItemClick += (sender, e) => { var next = new Intent(this, typeof(TODODetailActivity)); var target = (ListView)sender; next.PutExtra("targetTODO", adapter[e.Position].id); StartActivity(next); }; completeList = FindViewById <ListView>(Resource.Id.completeList); var comleteTODOs = TODO.getTODO().Where(todo => todo.completed).ToList(); var completeAdapter = new CustomAdapter(this, comleteTODOs); completeList.Adapter = completeAdapter; completeList.ItemClick += (sender, e) => { var next = new Intent(this, typeof(TODODetailActivity)); var target = (ListView)sender; next.PutExtra("targetTODO", completeAdapter[e.Position].id); StartActivity(next); }; }
protected override void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); // Set our view from the "main" layout resource SetContentView(Resource.Layout.todoDetail); // Create your application here int id = Intent.GetIntExtra("targetTODO", -1); addButton = FindViewById <Button>(Resource.Id.addButton); updateButton = FindViewById <Button>(Resource.Id.updateButton); returnButton = FindViewById <Button>(Resource.Id.returnButton); todoName = FindViewById <EditText>(Resource.Id.todoName); todoDescription = FindViewById <EditText>(Resource.Id.todoDescription); alert = FindViewById <Switch>(Resource.Id.alert); alertDatePicker = FindViewById <DatePicker>(Resource.Id.alertDatePicker); alertTimePicker = FindViewById <TimePicker>(Resource.Id.alertTimePicker); completed = FindViewById <Switch>(Resource.Id.completed); alertDatePicker.Visibility = ViewStates.Invisible; alertDatePicker.UpdateDate(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day); alertTimePicker.Visibility = ViewStates.Invisible; alert.CheckedChange += (sender, e) => { if (alert.Checked) { alertDatePicker.Visibility = ViewStates.Visible; alertTimePicker.Visibility = ViewStates.Visible; } else { alertDatePicker.Visibility = ViewStates.Invisible; alertTimePicker.Visibility = ViewStates.Invisible; } }; if (id != -1) { todo = TODO.getTODOById(id); addButton.Visibility = ViewStates.Invisible; todoName.Text = todo.name; todoDescription.Text = todo.description; completed.Checked = todo.completed; alert.Checked = todo.alert; if (todo.alertTime != null) { DateTime time = todo.alertTime; alertDatePicker.UpdateDate(time.Year, time.Month, time.Day); alertTimePicker.CurrentHour = (Java.Lang.Integer)time.Hour; alertTimePicker.CurrentMinute = (Java.Lang.Integer)time.Minute; } } else { updateButton.Visibility = ViewStates.Invisible; completed.Visibility = ViewStates.Invisible; alert.Checked = false; addButton.Click += delegate { var targetTODO = new TODO { name = todoName.Text, description = todoDescription.Text, completed = completed.Checked }; if (alert.Checked) { DateTime newDate = new DateTime(); newDate = alertDatePicker.DateTime; TimeSpan span = new TimeSpan(alertTimePicker.CurrentHour.IntValue(), alertTimePicker.CurrentMinute.IntValue(), 0); targetTODO.alertTime = newDate + span; targetTODO.alert = true; } else { targetTODO.alert = false; } TODO.addTODO(targetTODO); Remind(targetTODO); var next = new Intent(this, typeof(MainActivity)); StartActivity(next); }; } returnButton.Click += delegate { var next = new Intent(this, typeof(MainActivity)); StartActivity(next); }; updateButton.Click += delegate { todo.name = todoName.Text; todo.description = todoDescription.Text; todo.completed = completed.Checked; if (alert.Checked) { DateTime newDate = new DateTime(); newDate = alertDatePicker.DateTime; TimeSpan span = new TimeSpan(alertTimePicker.CurrentHour.IntValue(), alertTimePicker.CurrentMinute.IntValue(), 0); todo.alertTime = newDate + span; todo.alert = true; } else { todo.alert = false; } TODO.updateTODO(todo); var next = new Intent(this, typeof(MainActivity)); StartActivity(next); }; }