public static Reminder QueryReminder(int ID = -1)
{
Reminder reminder = new Reminder();
string intID;
if (ID == -1)
{
intID = "null";
}
else
{
intID = ID.ToString();
}
SqliteConnection conn = OpenDatabase();
SqliteCommand command = conn.CreateCommand();
command.CommandText = $"Select TReminders.reminderID, TReminders.reminderTitle, TReminders.reminderDescription, TReminders.reminderTime, TReminderDates.reminderDate, TReminders.isExpired, TReminders.isDeleted, TReminders.isSet From TReminders, TReminderDates Where TReminders.reminderID = TReminderDates.reminderID and TReminders.reminderID = COALESCE({intID}, TReminders.reminderID); ";
using (SqliteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
reminder = Reminder.FromDataRow(reader);
}
}
conn.Close();
return(reminder);
}
public static List <Reminder> QueryAllUnexpiredReminders()
{
List <Reminder> reminders = new List <Reminder>();
string query = @"SELECT TReminders.reminderID, TReminders.reminderTitle, TReminders.reminderTime, TReminders.reminderDescription, TReminders.isDeleted, TReminders.IsExpired, TReminders.isSet, TReminderDates.reminderDate
FROM TReminders, TReminderDates
WHERE TReminderDates.reminderID = TReminders.reminderID AND TReminders.isDeleted <> 1 AND TReminders.isExpired <> 1
ORDER BY TReminderDates.reminderDate,TReminders.reminderTime;";
using (SqliteConnection connection = OpenDatabase())
{
SqliteCommand command = connection.CreateCommand();
command.CommandText = query;
using (SqliteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
reminders.Add(Reminder.FromDataRow(reader));
}
}
}
return(reminders);
}