private static async Task <WorkItems> GetWorkItemData(string queryId)
{
string data = await HttpProvider.GetHttpRequest("Enterprise/_apis/wit/queries/" + queryId + "?api-version=2.2&$expand=all");
QueryDefinitionRequest queryData = JsonConvert.DeserializeObject <QueryDefinitionRequest>(data);
var wiqlClass = new QueryWiql {
query = queryData.wiql
};
string query = JsonConvert.SerializeObject(wiqlClass, Formatting.None); //@"{ ""query"": """ + queryData.wiql + @"""}";
string workItemsString = await HttpProvider.PostHttpRequest("Enterprise/_apis/wit/wiql?api-version=2.2", query);
var workItems = (JObject)JsonConvert.DeserializeObject(workItemsString);
string queryType = workItems["queryType"].Value <string>();
WorkItems workItemsData = default(WorkItems);
switch (queryType)
{
case "flat":
workItemsData = JsonConvert.DeserializeObject <Flat>(workItemsString);
break;
case "OneHop":
workItemsData = JsonConvert.DeserializeObject <OneHop>(workItemsString);
break;
case default(string):
break;
}
return(workItemsData);
}
public async Task <QueryFieldsResponse> GetQueryColumn(string queryId)
{
QueryFieldsResponse response = new QueryFieldsResponse();
response.GroupByFields = new List <QueryDefinitionResponse>();
response.AggregationFields = new List <QueryDefinitionResponse>();
var queryData = await HttpProvider.GetHttpRequest(StaticParams.TfsUrl, "Enterprise/_apis/wit/queries/" + queryId + "?api-version=2.2&$expand=all");
QueryDefinitionRequest queryDataObject = JsonConvert.DeserializeObject <QueryDefinitionRequest>(queryData);
foreach (var item in queryDataObject.columns)
{
var columnData = new QueryDefinitionResponse()
{
Name = item.name, ReferenceName = item.referenceName
};
if (columnData.Name != "ID")
{
response.GroupByFields.Add(columnData);
var columnType = await GetColumnType(item.referenceName);
if (columnType.type == "integer" || columnType.type == "double")
{
response.AggregationFields.Add(columnData);
}
}
}
return(response);
}
private static async Task <string> GetQueryWiql(string queryId)
{
string data = await HttpProvider.GetHttpRequest(StaticParams.TfsUrl, "Enterprise/_apis/wit/queries/" + queryId + "?api-version=2.2&$expand=all");
QueryDefinitionRequest queryData = JsonConvert.DeserializeObject <QueryDefinitionRequest>(data);
return(queryData.wiql);
}
//public async Task<IEnumerable<Report>> GetReportsNameByCategoryId(string categoryId)
//{
// var responseData = new QueriesDataResponse();
// List<QueryData> Querieslst = new List<QueryData>();
// ReportsDal reportsDal = new ReportsDal();
// int categoryIdNum = 0;
// int.TryParse(categoryId, out categoryIdNum);
// return reportsDal.GetReportsByCategoryId(categoryIdNum);
//}
public async Task <IEnumerable <QueryDefinitionResponse> > GetQueryColumn(string queryId)
{
List <QueryDefinitionResponse> responselst = new List <QueryDefinitionResponse>();
var queryData = await HttpProvider.GetHttpRequest("Enterprise/_apis/wit/queries/" + queryId + "?api-version=2.2&$expand=all");
QueryDefinitionRequest queryDataObject = JsonConvert.DeserializeObject <QueryDefinitionRequest>(queryData);
foreach (var item in queryDataObject.columns)
{
var columnData = new QueryDefinitionResponse()
{
Name = item.name, ReferenceName = item.referenceName
};
responselst.Add(columnData);
}
return(responselst);
}
