public override void Initialize(XPathNavigator configuration)
{
var fileName = configuration.SelectSingleNode("indexFile/@location").Value;
_topicIndex = new TopicIndex();
_topicIndex.Load(fileName);
}
public List <TopicIndex> getTopics()
{
List <TopicIndex> topicIndices = new List <TopicIndex>();
string query = "SELECT Id, Name, Author FROM [Topic]";
SqlCommand cmd = new SqlCommand(query, con);
try
{
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
TopicIndex topicIndex = new TopicIndex();
topicIndex.Id = Int32.Parse(rdr["Id"].ToString());
topicIndex.Name = rdr["Name"].ToString();
topicIndex.Author = rdr["Author"].ToString();
topicIndices.Add(topicIndex);
}
}
catch (Exception ex)
{
Console.WriteLine("Exception: " + ex.Message);
}
finally
{
con.Close();
}
return(topicIndices);
}
