static void Main(String[] args)
{
// Connect to Team Foundation Server
// Server is the name of the server that is running the application tier for Team Foundation.
// Port is the port that Team Foundation uses. The default port is 8080.
// VDir is the virtual path to the Team Foundation application. The default path is tfs.
string tfsServerAddress = "http://*****:*****@"SELECT * FROM WorkItems WHERE [System.TeamProject] = 'TSDL' ORDER BY [System.Id]");
//TfsTeamProjectCollection tpc = TfsTeamProjectCollectionFactory.GetTeamProjectCollection(new Uri("http://tfs13dev:8080/tfs/"));
var tpc = TfsTeamProjectCollectionFactory.GetTeamProjectCollection(new Uri("http://tfs13dev:8080/tfs/"));
var service = tpc.GetService<WorkItemStore>();
//TfsTeamProjectCollection tpc = new TfsTeamProjectCollection(new Uri("http://tfs13dev:8080/tfs/"));
WorkItemStore workItemStore = (WorkItemStore)tpc.GetService(typeof(WorkItemStore));
// WorkItemCollection queryResults = workItemStore.Query("SELECT * FROM WorkItems WHERE [System.TeamProject] = LEAP");
// WorkItemCollection queryResults = workItemStore.Query("SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo] FROM WorkItems WHERE [System.TeamProject] = 'ODS' ORDER by [System.Id] desc");
//WorkItemStore workItemStore = new WorkItemStore(tpc);
//Project teamProject = workItemStore.Projects["ODS"];
//WorkItemType wit = teamProject.WorkItemTypes[""];
Project teamProject = workItemStore.Projects["TSDL"];
/*
WorkItemType workItemType = teamProject.WorkItemTypes["Requirement"];
WorkItem userStory = new WorkItem(workItemType)
{
Title = "Recently ordered menu",
Description = "As a return customer, I want to see items that I've recently ordered."
};
userStory.Save();
*/
Query query = new Query(service, qText);
var workItems = query.RunQuery();
foreach(WorkItem workItem in workItems)
{
list.Add(workItem.Id + " - " + workItem.Title);
}
list.ForEach(i => Console.Write("{0}\n", i));
/*
WorkItemCollection queryResults = workItemStore.Query("SELECT * FROM WorkItems WHERE [System.TeamProject] = 'TSDL' ORDER BY [System.Id]");
foreach(WorkItem wi in queryResults)
{
Console.WriteLine("QueryResults: " + wi);
}
*/
}
static void Main(String[] args)
{
// Connect to Team Foundation Server
// Server is the name of the server that is running the application tier for Team Foundation.
// Port is the port that Team Foundation uses. The default port is 8080.
// VDir is the virtual path to the Team Foundation application. The default path is tfs.
string tfsServerAddress = "http://*****:*****@"SELECT * FROM WorkItems WHERE [System.TeamProject] = 'TSDL' ORDER BY [System.Id]");
//TfsTeamProjectCollection tpc = TfsTeamProjectCollectionFactory.GetTeamProjectCollection(new Uri("http://tfs13dev:8080/tfs/"));
var tpc = TfsTeamProjectCollectionFactory.GetTeamProjectCollection(new Uri("http://tfs13dev:8080/tfs/"));
var service = tpc.GetService <WorkItemStore>();
//TfsTeamProjectCollection tpc = new TfsTeamProjectCollection(new Uri("http://tfs13dev:8080/tfs/"));
WorkItemStore workItemStore = (WorkItemStore)tpc.GetService(typeof(WorkItemStore));
// WorkItemCollection queryResults = workItemStore.Query("SELECT * FROM WorkItems WHERE [System.TeamProject] = LEAP");
// WorkItemCollection queryResults = workItemStore.Query("SELECT [System.Id], [System.WorkItemType], [System.Title], [System.AssignedTo] FROM WorkItems WHERE [System.TeamProject] = 'ODS' ORDER by [System.Id] desc");
//WorkItemStore workItemStore = new WorkItemStore(tpc);
//Project teamProject = workItemStore.Projects["ODS"];
//WorkItemType wit = teamProject.WorkItemTypes[""];
Project teamProject = workItemStore.Projects["TSDL"];
/*
* WorkItemType workItemType = teamProject.WorkItemTypes["Requirement"];
*
* WorkItem userStory = new WorkItem(workItemType)
* {
* Title = "Recently ordered menu",
* Description = "As a return customer, I want to see items that I've recently ordered."
*
*
* };
* userStory.Save();
*/
Query query = new Query(service, qText);
var workItems = query.RunQuery();
foreach (WorkItem workItem in workItems)
{
list.Add(workItem.Id + " - " + workItem.Title);
}
list.ForEach(i => Console.Write("{0}\n", i));
/*
* WorkItemCollection queryResults = workItemStore.Query("SELECT * FROM WorkItems WHERE [System.TeamProject] = 'TSDL' ORDER BY [System.Id]");
*
* foreach(WorkItem wi in queryResults)
* {
* Console.WriteLine("QueryResults: " + wi);
*
* }
*/
}
