public RecentPosts GetTopTenRecentPosts(int numberOfPosts = 10)
{
//Then we can parse a SPARQL string into a query
SparqlQuery query = _parser.ParseFromString(@"
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX reddit: <http://www.semanticweb.org/hekurankastrati/ontologies/2019/4/reddit#>
SELECT ?post ?title ?date
WHERE {
?post rdf:type ?type .
?type rdfs:subClassOf* reddit:Post .
?post reddit:hasTitle ?title .
?post reddit:hasDateCreated ?date .
}
ORDER BY DESC(?date)
LIMIT " + numberOfPosts);
InMemoryDataset ds = new InMemoryDataset(_redditGraph);
//Get the Query processor
ISparqlQueryProcessor processor = new ExplainQueryProcessor(ds);
RecentPosts dto = new RecentPosts
{
Data = new List <RecentPostsData>()
};
Object results = processor.ProcessQuery(query);
if (results is SparqlResultSet resultSet)
{
foreach (SparqlResult result in resultSet.Results)
{
string post = result.TryGetValue("post", out var node)
? ((IUriNode)node).Uri.Fragment.Replace('#', ' ')
: string.Empty;
string title = result.TryGetValue("title", out var titleNode)
? ((ILiteralNode)titleNode).Value
: string.Empty;
string date = result.TryGetValue("date", out var dateNode)
? ((ILiteralNode)dateNode).Value
: string.Empty;
dto.Data.Add(new RecentPostsData
{
Post = post,
Title = title,
Date = date
});
}
}
return(dto);
}
public void postToolStripMenuItem_Click(object sender, EventArgs e)
{
postToolStripMenuItem.Enabled = false;
pendingUrlsToolStripMenuItem1.Enabled = true;
recentCarIdsToolStripMenuItem.Enabled = true;
qcCheckToolStripMenuItem.Enabled = true;
RecentPosts objrecntpost = new RecentPosts();
objrecntpost.MdiParent = this;
objrecntpost.Show();
objrecntpost.FormClosed += new FormClosedEventHandler(objrecntpost_FormClosed);
objrecntpost.BringToFront();
this.BringToFront();
}
