void UpsertVstsReleaseTaskToDb(SqlConnection sqlConnection, int releaseDeploymentId, IoTEdgePipelineTask task, string testTaskPrefix)
{
var cmd = new SqlCommand
{
Connection = sqlConnection,
CommandType = CommandType.StoredProcedure,
CommandText = "UpsertVstsReleaseTask"
};
cmd.Parameters.Add(new SqlParameter("@ReleaseDeploymentId", releaseDeploymentId));
cmd.Parameters.Add(new SqlParameter("@Id", task.Id));
cmd.Parameters.Add(new SqlParameter("@Name", task.Name.StartsWith(testTaskPrefix) ? task.Name.Substring(testTaskPrefix.Length) : task.Name));
cmd.Parameters.Add(new SqlParameter("@Status", task.Status));
cmd.Parameters.Add(new SqlParameter("@StartTime", SqlDbType.DateTime2)
{
Value = task.StartTime
});
cmd.Parameters.Add(new SqlParameter("@FinishTime", SqlDbType.DateTime2)
{
Value = task.FinishTime
});
cmd.Parameters.Add(new SqlParameter("@LogUrl", task.LogUrl?.AbsoluteUri));
cmd.ExecuteNonQuery();
}
void UpsertVstsReleaseTaskToDb(SqlConnection sqlConnection, int releaseDeploymentId, IoTEdgePipelineTask task)
{
var cmd = new SqlCommand
{
Connection = sqlConnection,
CommandType = CommandType.StoredProcedure,
CommandText = "UpsertVstsReleaseTask"
};
cmd.Parameters.Add(new SqlParameter("@ReleaseDeploymentId", releaseDeploymentId));
cmd.Parameters.Add(new SqlParameter("@Id", task.Id));
cmd.Parameters.Add(new SqlParameter("@Name", task.Name));
cmd.Parameters.Add(new SqlParameter("@Status", task.Status));
cmd.Parameters.Add(new SqlParameter("@StartTime", task.StartTime));
cmd.Parameters.Add(new SqlParameter("@FinishTime", task.FinishTime));
cmd.Parameters.Add(new SqlParameter("@LogUrl", task.LogUrl.AbsoluteUri));
cmd.ExecuteNonQuery();
}
bool IsTestTask(IoTEdgePipelineTask pipelineTask, string testTaskPrefix)
{
return(pipelineTask.Name.StartsWith(testTaskPrefix));
}
bool IsTestTask(IoTEdgePipelineTask pipelineTask)
{
return(pipelineTask.Name.StartsWith("E2E"));
}
