Пример #1
0
        public static async Task AddReminder(Input.UserIdentity user, string datetimeISO, string remText)
        {
            var command = new SQLiteCommand($"INSERT INTO Reminders(Activity, Dt, Id) VALUES (@Activity, @Datetime, '@User');", db);

            command.Parameters.AddWithValue("@User", user.UserName);
            command.Parameters.AddWithValue("@Datetime", DateTime.Parse(datetimeISO));
            command.Parameters.AddWithValue("@Activity", remText);

            Console.WriteLine($"New Reminder: ID: {user.UserName}, DATETIME: {datetimeISO}, Text: {remText}");


            await command.ExecuteNonQueryAsync();
        }
Пример #2
0
 public ReminderType(string user, string datetimeISO, string remText)
 {
     User    = new UserIdentity(user);
     Time    = DateTime.Parse(datetimeISO);
     RemText = remText;
 }