/// <summary>
/// This function takes the user's id and drops all reviews associated with that id
/// (usually) in preparation for re-analyzing all articles.
/// </summary>
/// <param name="user_id">ID of the User whos reviews will be dropped</param>
public void dropCurrentArticleReviews(int user_id)
{
using (var db = new stock_advisorDataContext(Program.ConnectionString))
{
db.ExecuteCommand("delete from REVIEW where User_id = {0}", user_id);
}
}
/// <summary>
/// This function sets all articles as unanalyzed ("Reviewed" column set to 0).
/// </summary>
public void setArticlesNotAnalyzed()
{
using (var db = new stock_advisorDataContext(Program.ConnectionString))
{
db.ExecuteCommand("update ARTICLE set Reviewed = 0");
}
}