public static void UpdateNotification(long id, string schedulingId, DateTimeOffset dateTime)
{
ISQLiteStatement statement = dbConn.Prepare(UPDATE_NOTIFICATION);
statement.Bind(1, TimeUtil.ConvertDateTimeOffsetToString(dateTime));
Debug.WriteLine("Updating notification: data to string " + TimeUtil.ConvertDateTimeOffsetToString(dateTime));
statement.Bind(2, schedulingId);
statement.Bind(3, TimeUtil.GetStringTimestamp());
statement.Bind(4, id);
statement.Step();
}
public static long AddNotification(string schedulingId, DateTimeOffset dateTime)
{
Debug.WriteLine("Adding notificaiton");
ISQLiteStatement statement = dbConn.Prepare(INSERT_SIMPLE_NOTE_NOTIFICATION);
statement.Bind(1, TimeUtil.ConvertDateTimeOffsetToString(dateTime));
statement.Bind(2, schedulingId);
statement.Bind(3, TimeUtil.GetStringTimestamp());
Debug.WriteLine(statement.Step());
Debug.WriteLine("Last inserted notification id: " + GetLastInsertedNotificationId());
return(GetLastInsertedNotificationId());
}
