public IEnumerable <StudentSentMessage> GetStudentSentMessages(string date, TimeSpan timeStart, TimeSpan timeEnd) { var results = new List <StudentSentMessage>(); using (var connection = new MySqlConnection(connString)) { results = connection.QueryAsync <StudentSentMessage>(MySqlDbQuery.GetStudentSentMessagesByDate(), new { chk_time = date }).Result.ToList(); } return(results.GetStudentSentMessage(timeStart, timeEnd)); }