private IEnumerable<OtfsBacklogItem> QueryOtfsBacklogItems(OtfsBacklogItemState state, OtfsIteration iteration = null, bool all = false, OtfsProjectId projectId = null) { var user = all ? string.Empty : "[Assigned To] = @User and "; var iterator = iteration == null ? string.Empty : " and [Iteration Path] under @Path"; var project_Id = projectId == null ? string.Empty : " and [ProjectId] under @ProjectId"; string query = "Select * " + "From WorkItems " + "Where [Work Item Type] = @Type and " + user + " [State] = @State" + iterator; var param = new Dictionary<string, string>(); param.Add("State", state.ToString()); param.Add("User", this.UsuarioAutenticado()); param.Add("Type", "Product Backlog Item"); param.Add("Path", iteration.Path); if (projectId != null) param.Add("ProjectId", projectId.Id.ToString()); return Execute(query, param, iteration); }
private IEnumerable<OtfsBacklogItem> QueryIterationByStatus(OtfsBacklogItemState state, OtfsIteration iteration) { string query = "Select * " + "From WorkItems " + "Where [Work Item Type] = @Type and " + " [State] = @State and " + " [Iteration Path] under @Path"; var param = new Dictionary<string, string>(); param.Add("State", state.ToString()); param.Add("Type", "Product Backlog Item"); param.Add("Path", iteration.Path); return Execute(query, param, iteration); }