public void UpdateTickets()
{
Uri orgUrl = new Uri("https://dev.azure.com/DCTTFS/");
String personalAccessToken = "ndzzurgegqnpmjwrqhwji2c5exr7wffx4bzjhuccdfprfsdjuydq";
JsonPatchDocument patchDocument = new JsonPatchDocument();
VssConnection connection = new VssConnection(orgUrl, new VssBasicCredential(string.Empty, personalAccessToken));
WorkItemTrackingHttpClient witClient = connection.GetClient <WorkItemTrackingHttpClient>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "server = tcp:hatch.database.windows.net,1433; initial catalog = acrf; persist security info = false; user id = dct; password = Duck@1234; multipleactiveresultsets = false; encrypt = true; trustservercertificate = false; connection timeout = 30;";
// using the code here...
conn.Close();
//conn.Open();
//SqlCommand cmd = conn.CreateCommand();
//SqlTransaction transaction;
//transaction = conn.BeginTransaction();
//cmd.Transaction = transaction;
//cmd.Connection = conn;
try
{
string sqlstr = "GetRecommendations";
SqlCommand cmd = new SqlCommand(sqlstr, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <Recommendation> TFSList = new List <Recommendation>();
Recommendation rec = null;
while (reader.Read())
{
rec = new Recommendation();
rec.ID = Convert.ToInt32(reader["ID"]);
rec.Developer = reader["Developer"].ToString();
TFSList.Add(rec);
}
//transaction.Commit();
conn.Close();
//result = "employee added successfully!";
foreach (var task in TFSList)
{
patchDocument.Clear();
patchDocument.Add(
new JsonPatchOperation()
{
Operation = Operation.Add,
Path = "/fields/Custom.Developer",
Value = task.Developer
}
);
WorkItem result = witClient.UpdateWorkItemAsync(patchDocument, task.ID).Result;
}
}
catch (Exception ex)
{
//transaction.Rollback();
conn.Close();
//global.errorhandlerclass.logerror(ex);
//result = ex.message;
}
conn.Close();
}
}
