public IEnumerable <Opinion> FindOpinionsByExpert(string expert)
{
var connection = GetConnection();
connection.Open();
string sql = String.Format("select * from opinion where expert like '%{0}%' order by date desc", expert);
SQLiteCommand command = new SQLiteCommand(sql, connection);
SQLiteDataReader reader = command.ExecuteReader();
//date, signal, company, expert, opinion, price, symbol
var opinions = new List <Opinion>();
while (reader.Read())
{
var dateTime = new DateTime().AddTicks((long)reader["date"]);
var o = new Opinion(dateTime,
reader["signal"].ToString(),
reader["company"].ToString(),
reader["expert"].ToString(),
reader["opinion"].ToString(),
decimal.Parse(reader["price"].ToString()),
reader["symbol"].ToString()
);
opinions.Add(o);
}
connection.Close();
return(NameHelpers.RemoveWeakNameMatches(opinions, expert));
}
