public List<Note> GetNotes(User user)
{
var result = new List<Note>();
using (var conn = this.Connection)
using (var mc = new MySqlCommand("SELECT * FROM `notes` WHERE `receiver` = @receiver", conn))
{
mc.Parameters.AddWithValue("@receiver", user.FullName);
using (var reader = mc.ExecuteReader())
{
while (reader.Read())
{
var note = this.ReadNote(reader);
if (note == null)
continue;
result.Add(note);
}
}
}
return result;
}