private List <SynonymDTO> getSynonyms(string temp)
{
List <SynonymDTO> results = new List <SynonymDTO>();
int locationA = 0;
int locationB = 0;
string ulSubstring = string.Empty;
locationA = temp.IndexOf("<ul>");
locationB = temp.IndexOf("</div>", locationA);
ulSubstring = temp.Substring(locationA, locationB - locationA);
while (ulSubstring.Contains("data-complexity"))
{
locationA = ulSubstring.IndexOf("<li>");
locationB = ulSubstring.IndexOf("</li>");
string li = ulSubstring.Substring(locationA, locationB + 5 - locationA);
ulSubstring = ulSubstring.Substring(locationB + 5);
locationA = li.IndexOf("data-complexity=");
locationA = locationA + "data-complexity=".Length;
locationA = li.IndexOf('"', locationA);
locationB = li.IndexOf('"', locationA + 1);
string complexity = li.Substring(locationA + 1, locationB - locationA - 1);
locationA = li.IndexOf("<span class=\"text\">");
locationA = locationA + "<span class=\"text\">".Length;
locationB = li.IndexOf("<", locationA);
string syn = li.Substring(locationA, locationB - locationA);
SynonymDTO tmp = new SynonymDTO();
tmp.complexity = int.Parse(complexity);
tmp.word = syn;
results.Add(tmp);
}
return(results);
}
private void insertSynonyms(int wordId, SynonymDTO wd)
{
try
{
using (SqlCommand cmd = new SqlCommand("sp_insert_Synonym", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@wordID", SqlDbType.Int).Value = wordId;
cmd.Parameters.Add("@syn", SqlDbType.VarChar).Value = wd.word;
cmd.Parameters.Add("@complexity", SqlDbType.Int).Value = wd.complexity;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
string message = ex.Message;
throw;
}
}
