private StatusCount GetStatusInfo(string userName) { var parameters = new List <SqlParameter> { new SqlParameter("username", userName) }; var query = @" SELECT CurrentStatus AS [Status] , COUNT(*) AS [Tickets] FROM dbo.Tickets WHERE AssignedTo = @username GROUP BY CurrentStatus "; var statusCount = new StatusCount(); var results = DoDatabaseQuery(query, parameters); while (results.Read()) { if ((string)results["Status"] == "Active") { statusCount.Active = (int)results["Tickets"]; } if ((string)results["Status"] == "Closed") { statusCount.Closed = (int)results["Tickets"]; } if ((string)results["Status"] == "More Info") { statusCount.MoreInfo = (int)results["Tickets"]; } if ((string)results["Status"] == "Resolved") { statusCount.Resolved = (int)results["Tickets"]; } } results.Close(); return(statusCount); }
private string SerializeStatuses(StatusCount statuses) { var statusCountInfo = "Resolved tickets: " + statuses.Resolved + ", Active tickets: " + statuses.Active + ", Closed tickets: " + statuses.Closed + ", More info required: " + statuses.MoreInfo; return(statusCountInfo); }