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);
}
}
