Exemple #1
0
        /// <summary>
        /// method to get list of work items
        /// </summary>
        /// <param name="workItemType"></param>
        /// <returns></returns>
        public WorkItemFetchResponse.WorkItems GetWorkItemsfromSource(string workItemType)
        {
            GetWorkItemsResponse.Results    viewModel = new GetWorkItemsResponse.Results();
            WorkItemFetchResponse.WorkItems fetchedWIs;
            try
            {
                // create wiql object
                Object wiql = new
                {
                    query = "Select [State], [Title] ,[Effort]" +
                            "From WorkItems " +
                            "Where [Work Item Type] = '" + workItemType + "'" +
                            "And [System.TeamProject] = '" + Project + "' " +
                            "Order By [Stack Rank] Desc, [Backlog Priority] Desc"
                };
                using (var client = GetHttpClient())
                {
                    var postValue = new StringContent(JsonConvert.SerializeObject(wiql), Encoding.UTF8, "application/json"); // mediaType needs to be application/json-patch+json for a patch call

                    // set the httpmethod to Patch
                    var method = new HttpMethod("POST");

                    // send the request
                    var request = new HttpRequestMessage(method, _configuration.UriString + "/_apis/wit/wiql?api-version=" + _configuration.VersionNumber)
                    {
                        Content = postValue
                    };
                    var response = client.SendAsync(request).Result;

                    if (response.IsSuccessStatusCode && response.StatusCode == System.Net.HttpStatusCode.OK)
                    {
                        viewModel = response.Content.ReadAsAsync <GetWorkItemsResponse.Results>().Result;
                    }
                    else
                    {
                        var    errorMessage = response.Content.ReadAsStringAsync();
                        string error        = Utility.GeterroMessage(errorMessage.Result.ToString());
                        LastFailureMessage = error;
                    }

                    viewModel.HttpStatusCode = response.StatusCode;
                    string workitemIDstoFetch = ""; int WICtr = 0;
                    foreach (GetWorkItemsResponse.Workitem WI in viewModel.workItems)
                    {
                        workitemIDstoFetch = WI.id + "," + workitemIDstoFetch;
                        WICtr++;
                    }
                    workitemIDstoFetch = workitemIDstoFetch.TrimEnd(',');
                    fetchedWIs         = GetWorkItemsDetailInBatch(workitemIDstoFetch);
                    return(fetchedWIs);
                }
            }
            catch (Exception ex)
            {
                logger.Info(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss") + "\t" + ex.Message + "\n" + ex.StackTrace + "\n");
                string error = ex.Message;
                LastFailureMessage = error;
            }
            return(new WorkItemFetchResponse.WorkItems());
        }
Exemple #2
0
        /// <summary>
        /// method to get list of work items
        /// </summary>
        /// <param name="workItemType"></param>
        /// <returns></returns>
        public WorkItemFetchResponse.WorkItems getWorkItemsfromSource(string workItemType)
        {
            GetWorkItemsResponse.Results    viewModel = new GetWorkItemsResponse.Results();
            WorkItemFetchResponse.WorkItems fetchedWIs;

            // create wiql object
            Object wiql = new
            {
                query = "Select [State], [Title] ,[Effort]" +
                        "From WorkItems " +
                        "Where [Work Item Type] = '" + workItemType + "'" +
                        "And [System.TeamProject] = '" + _sourceConfig.Project + "' " +
                        "Order By [Stack Rank] Desc, [Backlog Priority] Desc"
            };

            using (var client = new HttpClient())
            {
                client.DefaultRequestHeaders.Accept.Clear();
                client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
                client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", _sourceCredentials);

                var postValue = new StringContent(JsonConvert.SerializeObject(wiql), Encoding.UTF8, "application/json"); // mediaType needs to be application/json-patch+json for a patch call

                // set the httpmethod to Patch
                var method = new HttpMethod("POST");

                // send the request
                var request = new HttpRequestMessage(method, _sourceConfig.UriString + "/_apis/wit/wiql?api-version=2.2")
                {
                    Content = postValue
                };
                var response = client.SendAsync(request).Result;

                if (response.IsSuccessStatusCode)
                {
                    viewModel = response.Content.ReadAsAsync <GetWorkItemsResponse.Results>().Result;
                }

                viewModel.HttpStatusCode = response.StatusCode;
                string workitemIDstoFetch = ""; int WICtr = 0;
                foreach (GetWorkItemsResponse.Workitem WI in viewModel.workItems)
                {
                    workitemIDstoFetch = WI.id + "," + workitemIDstoFetch;
                    WICtr++;
                }
                Console.WriteLine("Total {0} {1} Work Items read from source", WICtr, workItemType);
                workitemIDstoFetch = workitemIDstoFetch.TrimEnd(',');
                fetchedWIs         = GetWorkItemsDetailinBatch(workitemIDstoFetch);

                //update the work items in target if specified
            }

            return(fetchedWIs);
        }
Exemple #3
0
        /// <summary>
        /// Method to Get the list of all workItems
        /// </summary>
        /// <param name="project"></param>
        /// <param name="workItemType"></param>
        /// <returns></returns>
        public GetWorkItemsResponse.Results GetListOfWorkItems_ByWiql(string project, string workItemType)
        {
            try
            {
                GetWorkItemsResponse.Results viewModel = new GetWorkItemsResponse.Results();

                //create wiql object
                Object wiql = new
                {
                    query = "Select [Work Item Type],[State], [Title],[Created By] " +
                            "From WorkItems " +
                            "Where [Work Item Type] = '" + workItemType + "' " +
                            "And [System.TeamProject] = '" + project + "' " +
                            "And [System.State] = 'New' " +
                            "Order By [Stack Rank] Desc, [Backlog Priority] Desc"
                };

                using (var client = GetHttpClient())
                {
                    var postValue = new StringContent(JsonConvert.SerializeObject(wiql), Encoding.UTF8, "application/json"); // mediaType needs to be application/json-patch+json for a patch call

                    // set the httpmethod to Patch
                    var method = new HttpMethod("POST");

                    // send the request
                    var request = new HttpRequestMessage(method, "_apis/wit/wiql?api-version=" + _configuration.VersionNumber)
                    {
                        Content = postValue
                    };
                    var response = client.SendAsync(request).Result;

                    if (response.IsSuccessStatusCode)
                    {
                        viewModel = response.Content.ReadAsAsync <GetWorkItemsResponse.Results>().Result;
                    }
                    else
                    {
                        var    errorMessage = response.Content.ReadAsStringAsync();
                        string error        = Utility.GeterroMessage(errorMessage.Result.ToString());
                        this.LastFailureMessage = error;
                    }
                    viewModel.HttpStatusCode = response.StatusCode;
                    return(viewModel);
                }
            }
            catch (Exception ex)
            {
                logger.Info(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss") + "\t" + ex.Message + "\n" + ex.StackTrace + "\n");
            }
            return(new GetWorkItemsResponse.Results());
        }
Exemple #4
0
        /// <summary>
        /// Method to Get the list of all workItems
        /// </summary>
        /// <param name="project"></param>
        /// <param name="WorkItemType"></param>
        /// <returns></returns>
        public GetWorkItemsResponse.Results GetListOfWorkItems_ByWiql(string project, string WorkItemType)
        {
            GetWorkItemsResponse.Results viewModel = new GetWorkItemsResponse.Results();

            //create wiql object
            Object wiql = new
            {
                query = "Select [Work Item Type],[State], [Title],[Created By] " +
                        "From WorkItems " +
                        "Where [Work Item Type] = '" + WorkItemType + "' " +
                        "And [System.TeamProject] = '" + project + "' " +
                        "And [System.State] = 'New' " +
                        "Order By [State] Asc"
            };

            using (var client = new HttpClient())
            {
                client.DefaultRequestHeaders.Accept.Clear();
                client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
                client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", _credentials);

                var postValue = new StringContent(JsonConvert.SerializeObject(wiql), Encoding.UTF8, "application/json"); // mediaType needs to be application/json-patch+json for a patch call

                // set the httpmethod to Patch
                var method = new HttpMethod("POST");

                // send the request
                var request = new HttpRequestMessage(method, _configuration.UriString + "_apis/wit/wiql?api-version=" + _configuration.VersionNumber)
                {
                    Content = postValue
                };
                var response = client.SendAsync(request).Result;

                if (response.IsSuccessStatusCode)
                {
                    viewModel = response.Content.ReadAsAsync <GetWorkItemsResponse.Results>().Result;
                }
                else
                {
                    var    errorMessage = response.Content.ReadAsStringAsync();
                    string error        = Utility.GeterroMessage(errorMessage.Result.ToString());
                    this.lastFailureMessage = error;
                }
                viewModel.HttpStatusCode = response.StatusCode;
                return(viewModel);
            }
        }
        public void WIQL_GetListOfWorkItemsByWiql_Success()
        {
            // arrange
            WIQL request = new WIQL(_configuration);

            // act
            GetWorkItemsResponse.Results response = request.GetListOfWorkItems_ByWiql(_configuration.Project);

            // assert
            if (response.HttpStatusCode == HttpStatusCode.NotFound)
            {
                Assert.Inconclusive("no query results found");
            }
            else
            {
                Assert.AreEqual(HttpStatusCode.OK, response.HttpStatusCode);
            }

            request = null;
        }
        // / <summary>
        // / get list of work item by query id
        // / </summary>
        // / <param name="id">query id</param>
        // / <returns></returns>
        public GetWorkItemsResponse.Results GetListOfWorkItems_ByQueryId(string project, string id)
        {
            GetWorkItemsResponse.Results viewModel = new GetWorkItemsResponse.Results();

            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri(_configuration.UriString);
                client.DefaultRequestHeaders.Accept.Clear();
                client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
                client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", _credentials);

                HttpResponseMessage response = client.GetAsync(project + "/_apis/wit/wiql/" + id + "?api-version=2.2").Result;

                if (response.IsSuccessStatusCode)
                {
                    viewModel = response.Content.ReadAsAsync <GetWorkItemsResponse.Results>().Result;
                }

                viewModel.HttpStatusCode = response.StatusCode;

                return(viewModel);
            }
        }
Exemple #7
0
        public static List <WorkItems> GetWorkItemsfromSource(string workItemType, UrlParameters parameters)
        {
            GetWorkItemsResponse.Results           viewModel = new GetWorkItemsResponse.Results();
            List <WorkItemFetchResponse.WorkItems> fetchedWIs;

            try
            {
                // create wiql object
                Object wiql = new
                {
                    //select [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State], [System.IterationPath], [Microsoft.VSTS.Scheduling.CompletedWork] from WorkItems where [System.TeamProject] = @project and [System.WorkItemType] = 'Task' and [System.State] <> '' and [System.IterationPath] = 'unisys\\Iteration 1'
                    query = "select [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo], [System.State], [System.IterationPath], [Microsoft.VSTS.Scheduling.CompletedWork] from WorkItems where [System.TeamProject] = '" + parameters.Project + "' and [System.WorkItemType] = 'Task' and [System.State] <> '' and [System.IterationPath] under '" + parameters.Project + "'"
                };
                using (var client = new HttpClient())
                {
                    client.DefaultRequestHeaders.Clear();
                    client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
                    client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", parameters.PatBase);
                    var postValue = new StringContent(JsonConvert.SerializeObject(wiql), Encoding.UTF8, "application/json"); // mediaType needs to be application/json-patch+json for a patch call

                    // set the httpmethod to Patch
                    var method = new HttpMethod("POST");

                    // send the request
                    var request = new HttpRequestMessage(method, parameters.UriString + "/_apis/wit/wiql?api-version=5.0")
                    {
                        Content = postValue
                    };
                    var response = client.SendAsync(request).Result;

                    if (response.IsSuccessStatusCode && response.StatusCode == System.Net.HttpStatusCode.OK)
                    {
                        string res = response.Content.ReadAsStringAsync().Result;
                        viewModel = JsonConvert.DeserializeObject <GetWorkItemsResponse.Results>(res);
                    }
                    else
                    {
                        var errorMessage = response.Content.ReadAsStringAsync();
                    }
                    List <string> witIds = new List <string>();
                    string        workitemIDstoFetch = ""; int WICtr = 0;
                    foreach (GetWorkItemsResponse.Workitem WI in viewModel.workItems)
                    {
                        workitemIDstoFetch = WI.id + "," + workitemIDstoFetch;
                        WICtr++;
                        if (WICtr >= 199)
                        {
                            witIds.Add(workitemIDstoFetch = workitemIDstoFetch.Trim(','));
                            workitemIDstoFetch            = "";
                        }
                    }
                    if (witIds.Count == 0)
                    {
                        workitemIDstoFetch = workitemIDstoFetch.TrimEnd(',');
                        witIds.Add(workitemIDstoFetch);
                    }
                    fetchedWIs = GetWorkItemsDetailInBatch(witIds, parameters);
                    return(fetchedWIs);
                }
            }
            catch (Exception ex)
            {
                string error = ex.Message;
                WriteFileToDisk("GetWorkItemsfromSource", ex.Message + Environment.NewLine + ex.StackTrace);
            }
            return(new List <WorkItemFetchResponse.WorkItems>());
        }