public OtfsBacklogItem(OtfsProjectId projectId, OtfsBacklogItemId backlogItemId, string title, string assignedTo, DateTime dataAtualizacao, OtfsBacklogItemState state = OtfsBacklogItemState.New )
{
this.BacklogItemId = backlogItemId;
this.AssignedTo = assignedTo;
this.ProjectId = projectId;
this.Title = title;
this.State = state;
this.DataAtualizacao = dataAtualizacao;
}
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);
}
public IEnumerable<OtfsBacklogItem> LocalizarPorStatus(OtfsBacklogItemState state, OtfsIteration iteration = null)
{
return QueryOtfsBacklogItems(state, iteration);
}