// 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;
// }
}
