public void UploadTestResults(RAKETest test) { try { con = new SqlConnection(connectionString); string cmdStr = "insert into RakeTestResults values(" + test.id + ",' " + test.articleTitle + "', " + test.minCharLength + ", " + test.maxWordsLength + ", " + test.minWordsFreq + ")"; cmd = new SqlCommand(cmdStr, con); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmdStr = ""; foreach (var keyword in test.testResults) { //cmdStr= cmd.CommandText = "insert into KeywordsInTest values(" + test.id + ",'" + keyword.Key + "','" + keyword.Value + "')"; cmd.ExecuteNonQuery(); } cmd.Connection.Close(); } catch (Exception ex) { var t = ex; } finally { cmd.Connection.Close(); } }
protected void BigRakeTestAttempt() { string stopListPath = MapPath(".") + "/Files/SmartStoplist.txt"; int minCharLength = 1; int maxWordsLength = 1; int minWordsFreq = 1; string articleTitle = articleDDL.Items[articleDDL.SelectedIndex].ToString(); string text = File.ReadAllText(articleDDL.SelectedValue); Rake rake; RAKETest rt = new RAKETest(); int id = 1; List <Dictionary <string, double> > allResults = new List <Dictionary <string, double> >(); for (int i = 1; i < 4; i++) { for (int j = 1; j < 5; j++) { for (int k = 1; k < 6; k++) { maxWordsLength = i; minCharLength = j; minWordsFreq = k; rake = new Rake(stopListPath, minCharLength, maxWordsLength, minWordsFreq); var results = rake.Run(text); var temp = GetTopResults2(results, 30); allResults.Add(temp); rt.AddTest(new RAKETest(temp, (id), minCharLength, maxWordsLength, minWordsFreq, articleTitle)); id++; } } } //Console.WriteLine(allResults); }
public void AddTest(RAKETest test) { new DBServices().UploadTestResults(test); }