// Crappy // http://www.codeproject.com/Questions/499216/ReadingplusaplusdocumentplusfromplusTFSplusserverp public static void CrappyKeepTrack() { Uri uri = new Uri("http://corfoundation:8080/tfs/COR-DEV-Produktion/"); using (Microsoft.TeamFoundation.Client.TeamFoundationServer tfs = Microsoft.TeamFoundation.Client.TeamFoundationServerFactory.GetServer(uri)) { Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore wit = (Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore)tfs.GetService(typeof(Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore)); Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemCollection result = wit.Query("SELECT * FROM WorkItems"); foreach (Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItem wi in result) { foreach (Microsoft.TeamFoundation.WorkItemTracking.Client.Attachment attachment in wi.Attachments) { //do something Console.WriteLine(attachment.Name); } // Next attachment } // Next wi } // End Using tfs } // End Sub CrappyKeepTrack
internal void StartConversion(string boardColumn) { Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemCollection tfsWork = QueryStore.GetItemsByBoardColumn(boardColumn, m_SourceProject); if (tfsWork.Count == 0) { throw new Exception("The TFS query failed to return any results for the given project or board column, review your settings and try again"); } foreach (Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItem wi in tfsWork) { int tfsId; string priorityTitle; string typeTitle; int assignedToId = ParseName(wi.Fields[Microsoft.TeamFoundation.WorkItemTracking.Client.CoreField.AssignedTo].Value.ToString()); int responsibleId = ParseName(wi.Fields[Microsoft.TeamFoundation.WorkItemTracking.Client.CoreField.CreatedBy].Value.ToString()); string subject = wi.Fields[Microsoft.TeamFoundation.WorkItemTracking.Client.CoreField.Title].Value.ToString(); Int32.TryParse(wi.Fields[Microsoft.TeamFoundation.WorkItemTracking.Client.CoreField.Id].Value.ToString(), out tfsId); string description = ParseDescription(wi.Fields[Microsoft.TeamFoundation.WorkItemTracking.Client.CoreField.Description].Value.ToString()); int typeId = ParseType(wi.Fields[Microsoft.TeamFoundation.WorkItemTracking.Client.CoreField.WorkItemType].Value.ToString(), out typeTitle); int statusId = ParseStatus(wi.Fields[Microsoft.TeamFoundation.WorkItemTracking.Client.CoreField.State].Value.ToString(), boardColumn); int priorityId = ParsePriority(boardColumn, out priorityTitle); var workPackage = GetNewWorkPackage(tfsId, subject, description, typeId, typeTitle, statusId, assignedToId, responsibleId, priorityId, priorityTitle); try { CallPostOrPatchApi(workPackage, OPAPIS.CREATEWP, HTTPMETHODS.POST); } catch (Exception ex) { Console.Out.WriteLine(ex); } } }
public static void ModifyGridViewWorkItemTest(DataGridView dataGridView, int id, Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemCollection testcoll) { call++; workItemColl = testcoll; dataGridViewWorkItem = dataGridView; dataGridViewWorkItem.RowsAdded += new DataGridViewRowsAddedEventHandler(dataGridViewWorkItem_RowsAdded); InitiateDataGridView delegateInit = InitiateDataGridViewMethod; dataGridViewWorkItem.BeginInvoke(delegateInit); //Assign variable ; if (dataSet == null) { dataGridViewWorkItem = new DataGridView(); dataTable = new DataTable(); dataSet = new DataSet(); } //Clean DataGridView and dataset dataGridViewWorkItem.DataSource = null; dataGridViewWorkItem.Rows.Clear(); dataGridViewWorkItem.Columns.Clear(); dataGridViewWorkItem.Refresh(); dataSet.Clear(); //dataGridViewWorkItem.DataBindings.Clear(); //Lauchning Tread to initiate Data // System.Threading.Thread threadDataSetConstruct = new System.Threading.Thread(new System.Threading.ThreadStart(ConstructDataSet)); // threadDataSetConstruct.Start(); /* * dataGridViewWorkItem.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; * colsDataGrid = new List<DataGridViewColumn>(); * //Create Columns of datagrid * foreach (Microsoft.TeamFoundation.WorkItemTracking.Client.FieldDefinition field in workItemColl.DisplayFields) * { * DataGridViewColumn colDataGrid = new DataGridViewColumn(); * DataGridViewCell cell = new DataGridViewTextBoxCell(); * colDataGrid.CellTemplate = cell; * colDataGrid.Visible = true; * colDataGrid.ValueType = field.SystemType; * colDataGrid.DataPropertyName = field.ReferenceName; * colDataGrid.Name = field.ReferenceName; * colDataGrid.HeaderText = field.Name; * //colsDataGrid.Add(colDataGrid); * dataGridViewWorkItem.Columns.Add(colDataGrid); * } */ dataGridViewWorkItem.Refresh(); // if (call > 1) // { //Populate DATASET ConstructDataSet(); dataGridViewWorkItem.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; // threadDataSetConstruct.Join(); //dataGridViewWorkItem.Columns.AddRange(colsDataGrid.ToArray()); dataGridViewWorkItem.DataSource = dataSet; dataGridViewWorkItem.DataMember = dataSet.Tables[0].TableName; // } }