public Note GetLatestUnreadNote(string receiver, long noteId)
{
Note note = null;
using (var conn = this.Connection)
using (var mc = new MySqlCommand("SELECT * FROM `notes` WHERE `receiver` = @receiver AND `noteId` > @noteId AND `read` = 0 ORDER BY `noteId` DESC LIMIT 1", conn))
{
mc.Parameters.AddWithValue("@receiver", receiver);
mc.Parameters.AddWithValue("@noteId", noteId);
using (var reader = mc.ExecuteReader())
{
if (reader.Read())
note = this.ReadNote(reader);
}
}
return note;
}