public ObservableCollection<ReminderViewModel> GetAllReminders(int CurrentID) { reminder = new ObservableCollection<ReminderViewModel>(); using (var db = new SQLite.SQLiteConnection(app.dbPath)) { var q = db.Query<Reminder>("select * from reminder where MemID = "+CurrentID+" "); foreach (var _reminder in q) { var reminders = new ReminderViewModel() { Id = _reminder.Id, rName = _reminder.rName, rDate = _reminder.rDate, }; reminder.Add(reminders); } } return reminder; }
private void btnClear_Click(object sender, RoutedEventArgs e) { var objSubject = new SubjectViewModel(); var objReminder = new ReminderViewModel(); var objStudy = new StudyViewModel(); string output = (string)cmbOutput.SelectedItem; string table = string.Empty; try { if (output == "Progress") { lsvOutput.Items.Clear(); objSubject.RemoveSubject(GetID); } else if (output == "Reminders") { lsvOutput.Items.Clear(); objReminder.RemoveReminder(GetID); } else if (output == "StudyTime") { lsvOutput.Items.Clear(); objStudy.RemoveStudy(GetID); } btnClear.Visibility = Visibility.Collapsed; } catch (Exception ex) { if (output == "Progress") table = "Subjects"; else if (output == "Reminders") table = "Reminders"; else if (output == "StudyTime") table = "StudyTimes"; messageBox("error " + ex.Message + "\nPlease add " + table); } }
private void Button_Click(object sender, RoutedEventArgs e) { var objReminder = new ReminderViewModel(); string task = string.Empty; string status = string.Empty; task = txbReminder.Text; try { DateTimeOffset datepicker = dtpDate.Date; string date = datepicker.ToString(); string reminderdate = date.Substring(0, 10); if (task != string.Empty) { if (VerifyDateIsFuture(datepicker) == true) { if (verifyDuplication(task) != true) { objReminder.SetReminder(task, reminderdate,GetID); status = "Successfully added Reminder" + "\n" + task + " with a due date of " + reminderdate; txbReminder.Text = ""; } else { status = "Reminder name already exist. \nPlease choose another name."; } } else { status = "Date must be later than today."; } } else { status = "Please specify the reminder name"; } if (status != string.Empty) messageBox(status); } catch (Exception ex) { messageBox("error " + ex.Message); } }