private CategoryCount GetCategoryInfo(string userName) { var parameters = new List <SqlParameter> { new SqlParameter("username", userName) }; var query = @" SELECT Category AS [Category] , COUNT(*) AS [Tickets] FROM dbo.Tickets WHERE AssignedTo = @username GROUP BY Category "; var categoryCount = new CategoryCount(); var results = DoDatabaseQuery(query, parameters); while (results.Read()) { if ((string)results["Category"] == "Hardware") { categoryCount.Hardware = (int)results["Tickets"]; } if ((string)results["Category"] == "Software") { categoryCount.Software = (int)results["Tickets"]; } if ((string)results["Category"] == "Network") { categoryCount.Network = (int)results["Tickets"]; } } results.Close(); return(categoryCount); }
private string SerializeCategories(CategoryCount categories) { var categoryCountInfo = "Hardware tickets: " + categories.Hardware + ", Network tickets: " + categories.Network + ", Software tickets: " + categories.Software; return(categoryCountInfo); }