private static void ListQueries()
{
TfsProjects ttp = new TfsProjects(new TfsConfigurationContext());
var queries = ttp.Project.QueryHierarchy;
ListQuery(queries);
}
public IEnumerable <TfsItem> GetTasksByQueryId(string queryId)
{
TfsProjects tp = new TfsProjects(ProjectHelper.TfsContext);
TfsQueries _query = new TfsQueries(tp);
return(_query.ExecuteQuery(new Guid(queryId)));
}
private static IEnumerable <TfsItem> GetTfsTasks()
{
TfsProjects tp = new TfsProjects(new TfsConfigurationContext());
TfsQueries query = new TfsQueries(tp);
var tasks = query.ExecuteQuery(new Guid("528b8489-8649-4324-bc66-cbf8d1ea84a7"));
return(tasks);
}
/// <summary>
/// Lists the TFS items.
/// </summary>
public static void ListTfsItems()
{
TfsProjects ttp = new TfsProjects(new TfsConfigurationContext());
TfsQueries queries = new TfsQueries(ttp);
var items = queries.GetTfsTasks(ProjectName + @"\Sprint 5");
foreach (var workItem in items)
{
Console.WriteLine(string.Format("{0}; {1}; {2}; {3}",
workItem.AssignedTo,
workItem.Title,
workItem.OriginalEstimate,
workItem.CompletedWork));
}
}
public ActionResult UnplannedTasks(string iterationPath)
{
string currentIteration;
var iterations = QueryHelper.Instance.GetIterations(out currentIteration);
iterationPath = iterationPath ?? currentIteration;
TfsProjects ttp = new TfsProjects(ProjectHelper.TfsContext);
var iteration = ttp.GetIteration(iterationPath);
// Get the tasks that were added after the start of the sprint.
IEnumerable <TfsItem> tasks = QueryHelper.Instance.GetTasks(iterationPath).
Where(t => t.CreatedDate.AddDays(-1) > iteration.StartDate && t.CreatedDate < iteration.FinishDate);
ViewBag.IterationList = new SelectList(iterations, "Name", "Path", iterationPath);
return(View(tasks));
}
private static void ListIteration()
{
TfsProjects ttp = new TfsProjects(new TfsConfigurationContext());
var x = ttp.GetIteration(ProjectName + @"\Sprint 3");
}
private QueryHelper()
{
_tfsProject = new TfsProjects(ProjectHelper.TfsContext);
_query = new TfsQueries(_tfsProject);
}
