private KnowledgeBaseCount GetKnowledgeBaseInfo(string userName)
{
var parameters = new List <SqlParameter>
{
new SqlParameter("username", userName)
};
var query = @"
SELECT PublishedToKb AS [Published] ,
COUNT(*) AS [Tickets]
FROM dbo.Tickets
WHERE AssignedTo = @username
GROUP BY PublishedToKb
";
var knowledgeBaseCount = new KnowledgeBaseCount();
var results = DoDatabaseQuery(query, parameters);
while (results.Read())
{
if ((bool)results["Published"])
{
knowledgeBaseCount.PublishedToKb = (int)results["Tickets"];
}
else
{
knowledgeBaseCount.NotPublishedToKb = (int)results["Tickets"];
}
}
results.Close();
return(knowledgeBaseCount);
}
private string SerializeKnowledgeBases(KnowledgeBaseCount knowledgeBases)
{
var knowledgeBaseCountInfo = "Published to KB: " + knowledgeBases.PublishedToKb + ", Not published to KB: " + knowledgeBases.NotPublishedToKb;
return(knowledgeBaseCountInfo);
}
