Aura.Msgr.Database.MsgrDb.GetLatestUnreadNote C# (CSharp) Method

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