public string Get(string userId)
{
ManageSQLConnection sqlConnection = new ManageSQLConnection();
DataSet ds = new DataSet();
try
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@userId", userId));
string query = "SELECT COUNT(ticket_id) AS total_bugs FROM tickets ;" +
" SELECT COUNT(ticket_id) AS user_bugs FROM tickets WHERE userid = '" + userId + "';" +
" SELECT product_id, COUNT(ticket_id) AS product_bugs FROM tickets GROUP BY product_id;";
ds = sqlConnection.GetDataSetValuesFromQuery(query);
return(JsonConvert.SerializeObject(ds.Tables));
}
finally
{
ds.Dispose();
}
}
