AzSKStaging.ADO

1.10.9

Framework/BugLog/BugLogHelper.ps1

                                Set-StrictMode -Version Latest

class BugLogHelper {

    hidden static [BugLogHelper] $BugLogHelperInstance;

    hidden [bool] $UseAzureStorageAccount;

    hidden [string] $OrganizationName;

    hidden [string] $StorageAccount;

    hidden [object] $StorageAccountCtx;

    hidden [string] $StorageRG;

    hidden [bool] $errorMsgDisplayed = $false

    hidden [string] $SharedKey

    hidden [object] $hmacsha

    BugLogHelper([string] $orgName) {

        $this.OrganizationName = $orgName;

        $this.StorageAccount = $env:StorageName;

        $this.StorageRG = $env:StorageRG;

        #get storage details

        if ($this.StorageRG -and $this.StorageAccount) {

            $keys = Get-AzStorageAccountKey -ResourceGroupName $this.StorageRG -Name $this.StorageAccount

            $StorageContext = New-AzStorageContext -StorageAccountName $this.StorageAccount -StorageAccountKey $keys[0].Value -Protocol Https

            $this.SharedKey = $keys[0].Value;

            $this.StorageAccountCtx = $StorageContext.Context;

            $this.hmacsha = New-Object System.Security.Cryptography.HMACSHA256

            $this.hmacsha.key = [Convert]::FromBase64String($this.SharedKey)

        }

    }

    #Return BugLogHelper instance

    hidden static [BugLogHelper] GetInstance([string] $orgName) {

        [BugLogHelper]::BugLogHelperInstance = [BugLogHelper]::new($orgName)

        return [BugLogHelper]::BugLogHelperInstance

    }

    #function to search for existing bugs based on hash id

    hidden [object] GetWorkItemByHashAzureTable([string] $hash, [string] $projectName, [string] $reactiveOldBug) 

    {

        #get table filter by name

        $tableName = $this.GetTableName();

        $bugObj = @(@{});

        $bugObj[0].results = @();

        try {

            #get storage table data.

            $azTableBugInfo = @();

            $azTableBugInfo += $this.GetTableEntity($tableName, $hash); 

            if ($azTableBugInfo -and $azTableBugInfo.count -gt 0) {

                $adoBugId = $azTableBugInfo[0].ADOBugId;

                $uri = "https://dev.azure.com/$($this.OrganizationName)/$projectName/_apis/wit/workitems/{0}?api-version=6.0" -f $adoBugId;

                $response = [WebRequestHelper]::InvokeGetWebRequest($uri);

                if($response -and ($response.count -gt 0) -and ($response.fields."System.State" -ne "Closed"))

                {

                    #check if org policy wants to reactivate resolved bugs. 

                    #if status is not 'Resolve', send response.

                    #if status is 'Resolved' and ReactiveOldBug flag is true, then send response. (when response goes empty we add new bug)

                    if (($response.fields."System.State" -ne "Resolved") -or ($response.fields."System.State" -eq "Resolved" -and $reactiveOldBug -eq "ReactiveOldBug") )

                    {

                        $bugObj[0].results += $response; 

                    }  

                }

                else {

                    #if bug state is closed on the ADO side and isDeleted is 'N' in azuretable then update azure table -> set isdeleted ='Y'

                   #$isDeleted = $this.DeleteTableEntity($tableName, $hash, $adoBugId);

                   #if ($isDeleted -eq $true) {

                   #    $this.AddDataInTable($tableName, $hash, $adoBugId, $projectName, "Y");

                   #}

                    $isUpdated = $this.UpdateTableEntity($tableName, $hash, $adoBugId, $projectName);

                }

                return $bugObj;

            }

        }

        catch {

            Write-Host $_

            Write-Host "Could not access storage account." -ForegroundColor Red

        }

        return $bugObj;

    }

    hidden [bool] InsertBugInfoInTable([string] $hash, [string] $projectName, [string] $ADOBugId) 

    {

        try 

        {

           $tableName = $this.GetTableName();

           #Get table filterd by name.

           $storageTables = @();

           $storageTables += Get-AzStorageTable -Context $this.StorageAccountCtx | Select Name;

           #create table if table not found.

           if ( !$storageTables -or ($storageTables.count -eq 0) -or !($storageTables.Name -eq $tableName) ) {

               New-AzStorageTable $tableName -Context $this.StorageAccountCtx;

           }

           $isDataAddedInTable = $this.AddDataInTable($tableName, $hash, $ADOBugId, $projectName, "N")

           return $isDataAddedInTable;           

        }

        catch {

            return $false;

        } 

        return $false

    }

    hidden [object] GetTableEntity($tableName, $hash) {

        try 

        {

            $query = 'ADOScannerHashId eq ''{0}'' and IsDeleted eq ''N''' -f $hash;

            $resource = '$filter='+[System.Web.HttpUtility]::UrlEncode($query);

            $table_url = "https://{0}.table.core.windows.net/{1}?{2}" -f $this.StorageAccount, $tableName, $resource

            $headers = $this.GetHeader($tableName)

            $item = Invoke-RestMethod -Method Get -Uri $table_url -Headers $headers -ContentType "application/json"

            return $item.value;

        }

        catch

        {

            #Write-Host $_

            Write-Host "Could not fetch the entry for partition key [$hash] in the table storage or the table was not found.";

            return $null

        }

    }

    hidden [bool] AddDataInTable($tableName, $hash, $ADOBugId, $projectName, $isDeleted)

    {

        $partitionKey = $hash;

        $rowKey = $hash + "_" + $ADOBugId;

        try 

        {

            #Add data in table.

            $entity = @{"PartitionKey" = $partitionKey; "RowKey" = $rowKey; "ADOBugId" = $ADOBugId; "ADOScannerHashId" = $hash; "IsDeleted" = $isDeleted; "ProjectName" = $projectName};

            $table_url = "https://{0}.table.core.windows.net/{1}" -f $this.StorageAccount, $tableName

            $headers = $this.GetHeader($tableName);

            $body = $entity | ConvertTo-Json

            $item = Invoke-RestMethod -Method POST -Uri $table_url -Headers $headers -Body $body -ContentType "application/json"

            return $true;

        }

        catch

        {

            Write-Host $_

            Write-Host "Could not push an entry in the table for row key [$rowKey]";

            return $false;

        }

    }

    hidden [bool] UpdateTableEntity($tableName, $hash, $ADOBugId, $projectName)

    {

        $PartitionKey = $hash;

        $Rowkey = $hash + "_" + $ADOBugId;

        try {

            #Update data in table.

            $entity = @{"ADOBugId" = $ADOBugId; "ADOScannerHashId" = $hash; "IsDeleted" = "Y"; "ProjectName" = $projectName};

            $body = $entity | ConvertTo-Json

            $version = "2017-04-17"

            $resource = "$tableName(PartitionKey='$PartitionKey',RowKey='$Rowkey')"

            $table_url = "https://$($this.StorageAccount).table.core.windows.net/$resource"

            $GMTTime = (Get-Date).ToUniversalTime().toString('R')

            $stringToSign = "$GMTTime`n/$($this.StorageAccount)/$resource"

            $signature = $this.hmacsha.ComputeHash([Text.Encoding]::UTF8.GetBytes($stringToSign))

            $signature = [Convert]::ToBase64String($signature)

            $body = $entity | ConvertTo-Json

            $headers = @{

                'x-ms-date'      = $GMTTime

                Authorization    = "SharedKeyLite " + $this.StorageAccount + ":" + $signature

                "x-ms-version"   = $version

                Accept           = "application/json;odata=minimalmetadata"

                'If-Match'       = "*"

            }

            Invoke-RestMethod -Method PUT -Uri $table_url -Headers $headers -Body $body -ContentType "application/json;odata=minimalmetadata"

            return $true;

        }

        catch

        {

            Write-Host $_

            Write-Host "Could not update entry in the table for row key [$RowKey]";

            return $false;

        }

    }

    hidden [bool] DeleteTableEntity($tableName, $hash, $ADOBugId) {

        $PartitionKey = $hash;

        $Rowkey = $hash + "_" + $ADOBugId;

        try {

            $version = "2017-04-17"

            $resource = "$tableName(PartitionKey='$PartitionKey',RowKey='$Rowkey')"

            $table_url = "https://$($this.StorageAccount).table.core.windows.net/$resource"

            $GMTTime = (Get-Date).ToUniversalTime().toString('R')

            $stringToSign = "$GMTTime`n/$($this.StorageAccount)/$resource"

            $signature = $this.hmacsha.ComputeHash([Text.Encoding]::UTF8.GetBytes($stringToSign))

            $signature = [Convert]::ToBase64String($signature)

            $headers = @{

                'x-ms-date'    = $GMTTime

                Authorization  = "SharedKeyLite " + $($this.StorageAccount) + ":" + $signature

                "x-ms-version" = $version

                Accept         = "application/json;odata=minimalmetadata"

                'If-Match'     = "*"

            }

            $item = Invoke-RestMethod -Method DELETE -Uri $table_url -Headers $headers -ContentType application/http

            return $true

        }

        catch {

            Write-Host $_

            Write-Host "Could not delete the entry for row key [$Rowkey] in the table storage.";

            return $false;

        }

    }

    hidden [object] GetHeader($tableName)

    {

        $version = "2017-07-29"

        $GMTTime = (Get-Date).ToUniversalTime().toString('R')

        $stringToSign = "$GMTTime`n/$($this.StorageAccount)/$tableName"

        $signature = $this.hmacsha.ComputeHash([Text.Encoding]::UTF8.GetBytes($stringToSign))

        $signature = [Convert]::ToBase64String($signature)

        $headers = @{

            'x-ms-date'    = $GMTTime

            Authorization  = "SharedKeyLite " + $this.StorageAccount + ":" + $signature

            "x-ms-version" = $version

            Accept         = "application/json;odata=minimalmetadata"

        }

        return $headers

    }

    hidden [object[]] GetTableEntityAndCloseBug([string] $hash) 

    {    

        #get table filter by name

        $tableName = $this.GetTableName();

        try {

            #Get clouddata to do perform read/write operations on the table

            $azTableBugInfo = @();

            $query = '({0}) and IsDeleted eq ''N''' -f $hash;

            $resource = '$filter='+[System.Web.HttpUtility]::UrlEncode($query);

            $table_url = "https://{0}.table.core.windows.net/{1}?{2}" -f $this.StorageAccount, $tableName, $resource

            $headers = $this.GetHeader($tableName)

            $item = Invoke-RestMethod -Method Get -Uri $table_url -Headers $headers -ContentType "application/json"

            $azTableBugInfo = $item.value

            if ($azTableBugInfo -and $azTableBugInfo.count -gt 0) {

                $adoBugIds = @();

                $adoBugIds += $azTableBugInfo.ADOBugId;

                $adoClosedBugResponse = $this.CloseBugsInBulk($adoBugIds);

                if($adoClosedBugResponse)

                {

                    foreach ($row in $adoClosedBugResponse) {

                        if($row.code -eq 200 )

                        {

                            $id = ($row.body | ConvertFrom-Json).id

                            $tableData = $azTableBugInfo | Where {$_.ADOBugId -eq $id} | Select PartitionKey, projectName, ADOScannerHashId

                            #$isDeleted = $this.DeleteTableEntity($tableName, $tableData.partitionKey , $id);

                            #if ($isDeleted -eq $true) {

                            #    $this.AddDataInTable($tableName, $tableData.partitionKey, $id, $tableData.projectName, "Y");

                            #}

                            $isUpdated = $this.UpdateTableEntity($tableName, $tableData.partitionKey, $id, $tableData.projectName);

                            #Adds ADOScannerHashId to response object

                            $row.body=$row.body.TrimEnd("}")

                            $row.body+=",`"ADOScannerHashId`":`"{0}`"" -f $tableData.ADOScannerHashId

                            $row.body+="}"

                        }

                    }

                return $adoClosedBugResponse

                } 

            }

        }

        catch {

            if (!$this.errorMsgDisplayed) {

               Write-Host "Could not update entry of closed bug in storage table." -ForegroundColor Red  

            }

            return $null;

        }

        return $null;

    } 

    hidden [string] GetTableName()

    {

        #return ($resourceNameToMakeTableName + "ADOBugInfo") -replace "[^a-zA-Z0-9]"

        return ($this.OrganizationName + "ADOBugInfo") -replace "[^a-zA-Z0-9]"

    }

    #function to close an active bug

    hidden [bool] CloseBug([string] $id, [string] $Project) {

        $url = "https://dev.azure.com/{0}/{1}/_apis/wit/workitems/{2}?api-version=6.0" -f $this.OrganizationName, $Project, $id

        #load the closed bug template

        $BugTemplate = [ConfigurationManager]::LoadServerConfigFile("TemplateForClosedBug.Json")

        $BugTemplate = $BugTemplate | ConvertTo-Json -Depth 10

        $header = [WebRequestHelper]::GetAuthHeaderFromUriPatch($url)               

        try {

            $responseObj = Invoke-RestMethod -Uri $url -Method Patch  -ContentType "application/json-patch+json ; charset=utf-8" -Headers $header -Body $BugTemplate

            return $true;

        }

        catch {

            Write-Host $_

            Write-Host "Could not close the bug." -ForegroundColor Red

            return $false

        }

        return $true;

    }

    #function to close an active bugs in bulk

    hidden [object] CloseBugsInBulk([string[]] $ids) 

    {

        try {

            $closeBugTemplate = @();

            foreach ($id in $ids) {

                $closeBugTemplate += [PSCustomObject] @{ method = 'PATCH'; uri = "/_apis/wit/workitems/$($id)?api-version=4.1"; headers = @{"Content-Type" = 'application/json-patch+json'};

                body = @(@{op = "add"; "path"= "/fields/System.State"; "value"= "Closed"}; @{op = "add"; "path"= "/fields/Microsoft.VSTS.Common.ResolvedReason"; "value"= ""})

                }

            }

            if ($closeBugTemplate.count -gt 0) {

                $body = $null;

                if ($closeBugTemplate.count -eq 1) {

                    $body = "[$($closeBugTemplate | ConvertTo-Json -depth 10)]"

                }

                else {

                    $body = $closeBugTemplate | ConvertTo-Json -depth 10  

                }

                $uri = 'https://{0}.visualstudio.com/_apis/wit/$batch?api-version=4.1' -f $this.OrganizationName

                $header = [WebRequestHelper]::GetAuthHeaderFromUriPatch($uri)

                $adoResult = Invoke-RestMethod -Uri $uri -Method Patch -ContentType "application/json" -Headers $header -Body $body

                if ($adoResult -and $adoResult.count -gt 0) {

                    return $adoResult.value;

                }

            }

            return $false;

        }

        catch {

            Write-Host $_

            Write-Host "Could not close the bug." -ForegroundColor Red

            return $false

        }

    }

}

# SIG # Begin signature block

# MIIjmAYJKoZIhvcNAQcCoIIjiTCCI4UCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCArbfZryXk/cPz6

# 97JxDy3KJsSsmk/L3DoEcMr8LNrSF6CCDYUwggYDMIID66ADAgECAhMzAAAB4HFz

# JMpcmPgZAAAAAAHgMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjAxMjE1MjEzMTQ2WhcNMjExMjAyMjEzMTQ2WjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDRXpc9eiGRI/2BlmU7OMiQPTKpNlluodjT2rltPO/Gk47bH4gBShPMD4BX/4sg

# NvvBun6ZOG2dxUW30myWoUJJ0iRbTAv2JFzjSpVQvPE+D5vtmdu6WlOR2ahF4leF

# 5Vvk4lPg2ZFrqg5LNwT9gjwuYgmih+G2KwT8NMWusBhO649F4Ku6B6QgA+vZld5S

# G2XWIdvS0pmpmn/HFrV4eYTsl9HYgjn/bPsAlfWolLlEXYTaCljK7q7bQHDBrzlR

# ukyyryFpPOR9Wx1cxFJ6KBqg2jlJpzxjN3udNJPOqarnQIVgB8DUm3I5g2v5xTHK

# Ovz9ucN21467cYcIxjPC4UkDAgMBAAGjggGCMIIBfjAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUVBWIZHrG4UIX3uX4142l+8GsPXAw

# VAYDVR0RBE0wS6RJMEcxLTArBgNVBAsTJE1pY3Jvc29mdCBJcmVsYW5kIE9wZXJh

# dGlvbnMgTGltaXRlZDEWMBQGA1UEBRMNMjMwMDEyKzQ2MzAxMDAfBgNVHSMEGDAW

# gBRIbmTlUAXTgqoXNzcitW2oynUClTBUBgNVHR8ETTBLMEmgR6BFhkNodHRwOi8v

# d3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNDb2RTaWdQQ0EyMDExXzIw

# MTEtMDctMDguY3JsMGEGCCsGAQUFBwEBBFUwUzBRBggrBgEFBQcwAoZFaHR0cDov

# L3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9jZXJ0cy9NaWNDb2RTaWdQQ0EyMDEx

# XzIwMTEtMDctMDguY3J0MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIB

# AE5msNzmYzYbNgpnhya6YsrM+CIC8CXDu10nwzZtkgQciPOOqAYmFcWJCwD5VZzs

# qFwad8XIOrfCylWf4hzn09mD87yuazpuCstLSqfDLNd3740+254vEZqdGxOglAGU

# ih2IiF8S0GDwucpLGzt/OLXPFr/d4MWxPuX0L+HB5lA3Y/CJE673dHGQW2DELdqt

# ohtkhp+oWFn1hNDDZ3LP++HEZvA7sI/o/981Sh4kaGayOp6oEiQuGeCXyfrIC9KX

# eew0UlYX/NHVDqr4ykKkqpHtzbUbuo7qovUHPbYKcRGWrrEtBS5SPLFPumqsRtzb

# LgU9HqfRAN36bMsd2qynGyWBVFOM7NMs2lTCGM85Z/Fdzv/8tnYT36Cmbue+IM+6

# kS86j6Ztmx0VIFWbOvNsASPT6yrmYiecJiP6H0TrYXQK5B3jE8s53l+t61ab0Eul

# 7DAxNWX3lAiUlzKs3qZYQEK1LFvgbdTXtBRnHgBdABALK3RPrieIYqPln9sAmg3/

# zJZi4C/c2cWGF6WwK/w1Nzw08pj7jaaZZVBpCeDe+y7oM26QIXxracot7zJ21/TL

# 70biK36YybSUDkjhQPP/uxT0yebLNBKk7g8V98Wna2MsHWwk0sgqpkjIp02TrkVz

# 26tcF2rml2THRSDrwpBa4x9c8rM8Qomiyeh2tEJnsx2LMIIHejCCBWKgAwIBAgIK

# YQ6Q0gAAAAAAAzANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNV

# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv

# c29mdCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlm

# aWNhdGUgQXV0aG9yaXR5IDIwMTEwHhcNMTEwNzA4MjA1OTA5WhcNMjYwNzA4MjEw

# OTA5WjB+MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE

# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSgwJgYD

# VQQDEx9NaWNyb3NvZnQgQ29kZSBTaWduaW5nIFBDQSAyMDExMIICIjANBgkqhkiG

# 9w0BAQEFAAOCAg8AMIICCgKCAgEAq/D6chAcLq3YbqqCEE00uvK2WCGfQhsqa+la

# UKq4BjgaBEm6f8MMHt03a8YS2AvwOMKZBrDIOdUBFDFC04kNeWSHfpRgJGyvnkmc

# 6Whe0t+bU7IKLMOv2akrrnoJr9eWWcpgGgXpZnboMlImEi/nqwhQz7NEt13YxC4D

# dato88tt8zpcoRb0RrrgOGSsbmQ1eKagYw8t00CT+OPeBw3VXHmlSSnnDb6gE3e+

# lD3v++MrWhAfTVYoonpy4BI6t0le2O3tQ5GD2Xuye4Yb2T6xjF3oiU+EGvKhL1nk

# kDstrjNYxbc+/jLTswM9sbKvkjh+0p2ALPVOVpEhNSXDOW5kf1O6nA+tGSOEy/S6

# A4aN91/w0FK/jJSHvMAhdCVfGCi2zCcoOCWYOUo2z3yxkq4cI6epZuxhH2rhKEmd

# X4jiJV3TIUs+UsS1Vz8kA/DRelsv1SPjcF0PUUZ3s/gA4bysAoJf28AVs70b1FVL

# 5zmhD+kjSbwYuER8ReTBw3J64HLnJN+/RpnF78IcV9uDjexNSTCnq47f7Fufr/zd

# sGbiwZeBe+3W7UvnSSmnEyimp31ngOaKYnhfsi+E11ecXL93KCjx7W3DKI8sj0A3

# T8HhhUSJxAlMxdSlQy90lfdu+HggWCwTXWCVmj5PM4TasIgX3p5O9JawvEagbJjS

# 4NaIjAsCAwEAAaOCAe0wggHpMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRI

# bmTlUAXTgqoXNzcitW2oynUClTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTAL

# BgNVHQ8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBRyLToCMZBD

# uRQFTuHqp8cx0SOJNDBaBgNVHR8EUzBRME+gTaBLhklodHRwOi8vY3JsLm1pY3Jv

# c29mdC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFf

# MDNfMjIuY3JsMF4GCCsGAQUFBwEBBFIwUDBOBggrBgEFBQcwAoZCaHR0cDovL3d3

# dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFf

# MDNfMjIuY3J0MIGfBgNVHSAEgZcwgZQwgZEGCSsGAQQBgjcuAzCBgzA/BggrBgEF

# BQcCARYzaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9kb2NzL3ByaW1h

# cnljcHMuaHRtMEAGCCsGAQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAHAAbwBsAGkA

# YwB5AF8AcwB0AGEAdABlAG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQBn

# 8oalmOBUeRou09h0ZyKbC5YR4WOSmUKWfdJ5DJDBZV8uLD74w3LRbYP+vj/oCso7

# v0epo/Np22O/IjWll11lhJB9i0ZQVdgMknzSGksc8zxCi1LQsP1r4z4HLimb5j0b

# pdS1HXeUOeLpZMlEPXh6I/MTfaaQdION9MsmAkYqwooQu6SpBQyb7Wj6aC6VoCo/

# KmtYSWMfCWluWpiW5IP0wI/zRive/DvQvTXvbiWu5a8n7dDd8w6vmSiXmE0OPQvy

# CInWH8MyGOLwxS3OW560STkKxgrCxq2u5bLZ2xWIUUVYODJxJxp/sfQn+N4sOiBp

# mLJZiWhub6e3dMNABQamASooPoI/E01mC8CzTfXhj38cbxV9Rad25UAqZaPDXVJi

# hsMdYzaXht/a8/jyFqGaJ+HNpZfQ7l1jQeNbB5yHPgZ3BtEGsXUfFL5hYbXw3MYb

# BL7fQccOKO7eZS/sl/ahXJbYANahRr1Z85elCUtIEJmAH9AAKcWxm6U/RXceNcbS

# oqKfenoi+kiVH6v7RyOA9Z74v2u3S5fi63V4GuzqN5l5GEv/1rMjaHXmr/r8i+sL

# gOppO6/8MO0ETI7f33VtY5E90Z1WTk+/gFcioXgRMiF670EKsT/7qMykXcGhiJtX

# cVZOSEXAQsmbdlsKgEhr/Xmfwb1tbWrJUnMTDXpQzTGCFWkwghVlAgEBMIGVMH4x

# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt

# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01p

# Y3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMTECEzMAAAHgcXMkylyY+BkAAAAA

# AeAwDQYJYIZIAWUDBAIBBQCggbAwGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQw

# HAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEICFC

# a1ZscdQTQJ+0ASfEmdY+Tl2tO2mlOyiAsypo2MvSMEQGCisGAQQBgjcCAQwxNjA0

# oBSAEgBNAGkAYwByAG8AcwBvAGYAdKEcgBpodHRwczovL3d3dy5taWNyb3NvZnQu

# Y29tIDANBgkqhkiG9w0BAQEFAASCAQB0AHD/uBLwOiw7ztAWyF9BDbFNpgkP90Hx

# l2NMx7OxBktmZhft4Znu5o/cs14iS1Kuku3Ujywn+Jx+Y/LrBYY/02Uk40plcpIM

# kkOnhtN7MR7oEii5lFPpw8keGE3l5o+MtFMQKBk0s4k9TLcw5CXyEP4PUvzP208x

# ITttmymrEXswaEp3NwL4zWUr1hlLgasxQHy71GZTKx+bsK/9M2A9K63ruqY2oJB/

# L4T/J348qt7TOEk3ILOJ4qPPr4w2IiwYE/VbD9/QHLXRVnHI2EGhR37mFB7fa9gS

# i9OB4ZQCn+2PHVhmy39xKp8+FbPGz5i2U1ILJXYX2qfPW1VFmNEdoYIS8TCCEu0G

# CisGAQQBgjcDAwExghLdMIIS2QYJKoZIhvcNAQcCoIISyjCCEsYCAQMxDzANBglg

# hkgBZQMEAgEFADCCAVUGCyqGSIb3DQEJEAEEoIIBRASCAUAwggE8AgEBBgorBgEE

# AYRZCgMBMDEwDQYJYIZIAWUDBAIBBQAEIK+YJQxf53Lg9bBuQseUEcyCA0/w8lkV

# gG9XeY9F25SjAgZg+vXRxSoYEzIwMjEwODE2MDU0MzM4LjY4N1owBIACAfSggdSk

# gdEwgc4xCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQH

# EwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNV

# BAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1U

# aGFsZXMgVFNTIEVTTjpGODdBLUUzNzQtRDdCOTElMCMGA1UEAxMcTWljcm9zb2Z0

# IFRpbWUtU3RhbXAgU2VydmljZaCCDkQwggT1MIID3aADAgECAhMzAAABY4tkxsmF

# lmV2AAAAAAFjMA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQI

# EwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3Nv

# ZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBD

# QSAyMDEwMB4XDTIxMDExNDE5MDIyM1oXDTIyMDQxMTE5MDIyM1owgc4xCzAJBgNV

# BAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4w

# HAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jvc29m

# dCBPcGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVT

# TjpGODdBLUUzNzQtRDdCOTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAg

# U2VydmljZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAK1xF/YSncl0

# YpL/qN2Fnfwjf0i8a+C4ELz5UZy3JOU54XH+rHv1y3LgKYGu3wrtNSEY4Hz5z6PR

# lEJvv7aK2tm7WvFSes7iLFhQ08DV4hVx5zF6ll5uN2ti2fJNZ6JDjMSVYuY/waYd

# NFo7N4l8x87/1STIob3PDiaqAoEZ1hEbmuRr44EKP/3RDgo/AY0o01zAF4k5Hvyr

# fz03GaJIZ6EIIgbYbE6E2LX2cJZ963aNYPZLYVbNnTviO7p2eGHtaAkn08QrzW9p

# z1aGCTUlDLRULnMiQVLNigaU1v8OTzv7alAInTlRfFLvPIV0JJ2SPq+wVLxPGhiV

# swErX98/szUCAwEAAaOCARswggEXMB0GA1UdDgQWBBQJNcrxdnJn7j8xWp9Gx5A+

# 1989KTAfBgNVHSMEGDAWgBTVYzpcijGQ80N7fEYbxTNoWoVtVTBWBgNVHR8ETzBN

# MEugSaBHhkVodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtpL2NybC9wcm9kdWN0

# cy9NaWNUaW1TdGFQQ0FfMjAxMC0wNy0wMS5jcmwwWgYIKwYBBQUHAQEETjBMMEoG

# CCsGAQUFBzAChj5odHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpL2NlcnRzL01p

# Y1RpbVN0YVBDQV8yMDEwLTA3LTAxLmNydDAMBgNVHRMBAf8EAjAAMBMGA1UdJQQM

# MAoGCCsGAQUFBwMIMA0GCSqGSIb3DQEBCwUAA4IBAQACiEGCB9eO4lPOjjICYfsT

# qam9IqdRtMj20UBBVLhufvP9xvloI8LZ9wOPq4sCoJSdhMLawUWZd67vFlM/iBP+

# 7Xkq109TaeQSE4Nc9ueM15flEvao4ZtzGoWTcxpC+alYY0kVGIj6SxBSxnCkoZes

# T44WVITBQL/43PmHxVAFD0C1cDzza5nv1CSiDvnZ4qNxpP6af9IYfKbJB4bJxBq5

# 2FZVQqR4dA6Na7H4sThh1AY/qYc6kzmSphUvEzCq5xPZ8+TlsoNNZYz6TAR6qnef

# T2D/3Dsn7XmO+wNjIi6AEWQJHaqwB7R5OWO7QJ7p07Rl/4TvkNMzvZl8BBSfX7Yj

# MIIGcTCCBFmgAwIBAgIKYQmBKgAAAAAAAjANBgkqhkiG9w0BAQsFADCBiDELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9z

# b2Z0IFJvb3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5IDIwMTAwHhcNMTAwNzAxMjEz

# NjU1WhcNMjUwNzAxMjE0NjU1WjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2Fz

# aGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENv

# cnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAx

# MDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAKkdDbx3EYo6IOz8E5f1

# +n9plGt0VBDVpQoAgoX77XxoSyxfxcPlYcJ2tz5mK1vwFVMnBDEfQRsalR3OCROO

# fGEwWbEwRA/xYIiEVEMM1024OAizQt2TrNZzMFcmgqNFDdDq9UeBzb8kYDJYYEby

# WEeGMoQedGFnkV+BVLHPk0ySwcSmXdFhE24oxhr5hoC732H8RsEnHSRnEnIaIYqv

# S2SJUGKxXf13Hz3wV3WsvYpCTUBR0Q+cBj5nf/VmwAOWRH7v0Ev9buWayrGo8noq

# CjHw2k4GkbaICDXoeByw6ZnNPOcvRLqn9NxkvaQBwSAJk3jN/LzAyURdXhacAQVP

# Ik0CAwEAAaOCAeYwggHiMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBTVYzpc

# ijGQ80N7fEYbxTNoWoVtVTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTALBgNV

# HQ8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBTV9lbLj+iiXGJo

# 0T2UkFvXzpoYxDBWBgNVHR8ETzBNMEugSaBHhkVodHRwOi8vY3JsLm1pY3Jvc29m

# dC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5j

# cmwwWgYIKwYBBQUHAQEETjBMMEoGCCsGAQUFBzAChj5odHRwOi8vd3d3Lm1pY3Jv

# c29mdC5jb20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIzLmNydDCB

# oAYDVR0gAQH/BIGVMIGSMIGPBgkrBgEEAYI3LgMwgYEwPQYIKwYBBQUHAgEWMWh0

# dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9QS0kvZG9jcy9DUFMvZGVmYXVsdC5odG0w

# QAYIKwYBBQUHAgIwNB4yIB0ATABlAGcAYQBsAF8AUABvAGwAaQBjAHkAXwBTAHQA

# YQB0AGUAbQBlAG4AdAAuIB0wDQYJKoZIhvcNAQELBQADggIBAAfmiFEN4sbgmD+B

# cQM9naOhIW+z66bM9TG+zwXiqf76V20ZMLPCxWbJat/15/B4vceoniXj+bzta1RX

# CCtRgkQS+7lTjMz0YBKKdsxAQEGb3FwX/1z5Xhc1mCRWS3TvQhDIr79/xn/yN31a

# PxzymXlKkVIArzgPF/UveYFl2am1a+THzvbKegBvSzBEJCI8z+0DpZaPWSm8tv0E

# 4XCfMkon/VWvL/625Y4zu2JfmttXQOnxzplmkIz/amJ/3cVKC5Em4jnsGUpxY517

# IW3DnKOiPPp/fZZqkHimbdLhnPkd/DjYlPTGpQqWhqS9nhquBEKDuLWAmyI4ILUl

# 5WTs9/S/fmNZJQ96LjlXdqJxqgaKD4kWumGnEcua2A5HmoDF0M2n0O99g/DhO3EJ

# 3110mCIIYdqwUB5vvfHhAN/nMQekkzr3ZUd46PioSKv33nJ+YWtvd6mBy6cJrDm7

# 7MbL2IK0cs0d9LiFAR6A+xuJKlQ5slvayA1VmXqHczsI5pgt6o3gMy4SKfXAL1Qn

# IffIrE7aKLixqduWsqdCosnPGUFN4Ib5KpqjEWYw07t0MkvfY3v1mYovG8chr1m1

# rtxEPJdQcdeh0sVV42neV8HR3jDA/czmTfsNv11P6Z0eGTgvvM9YBS7vDaBQNdrv

# CScc1bN+NR4Iuto229Nfj950iEkSoYIC0jCCAjsCAQEwgfyhgdSkgdEwgc4xCzAJ

# BgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25k

# MR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jv

# c29mdCBPcGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNT

# IEVTTjpGODdBLUUzNzQtRDdCOTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3Rh

# bXAgU2VydmljZaIjCgEBMAcGBSsOAwIaAxUA7SxgHt1J3SqTTSqzLcrMGZQBYe+g

# gYMwgYCkfjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4G

# A1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYw

# JAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0B

# AQUFAAIFAOTEbrIwIhgPMjAyMTA4MTYwODU3MjJaGA8yMDIxMDgxNzA4NTcyMlow

# dzA9BgorBgEEAYRZCgQBMS8wLTAKAgUA5MRusgIBADAKAgEAAgIUJwIB/zAHAgEA

# AgIRADAKAgUA5MXAMgIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMC

# oAowCAIBAAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAKQgGClN

# XwQG0HGXeAa0YEjRmYLfpMCsWwzpwKozEv/Yv/MHGO0iHvJVFEfxpWb+EeUslggi

# dVx2Ejq0MZOZSdu741Qk7EYW91sMY+BYY+0bCkiQKNdXBq3wXSxw+uVRKQbE4bYC

# Cb6+s6fMgAwGi2fROsKoOOse8v1wEwbvWjcBMYIDDTCCAwkCAQEwgZMwfDELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9z

# b2Z0IFRpbWUtU3RhbXAgUENBIDIwMTACEzMAAAFji2TGyYWWZXYAAAAAAWMwDQYJ

# YIZIAWUDBAIBBQCgggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkq

# hkiG9w0BCQQxIgQgQKsI+FSl8BxOCf1T4GFWZp5Ji6UT7slksoeL6i1p9XEwgfoG

# CyqGSIb3DQEJEAIvMYHqMIHnMIHkMIG9BCCcWd2XHaFjoSikKbi4y9AYBIpLBy9R

# b16ns1GrEfQjajCBmDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNo

# aW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29y

# cG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEw

# AhMzAAABY4tkxsmFlmV2AAAAAAFjMCIEIP1xmBajRz094HJ6dF4F3jCxEkCM3FhF

# Oa7r43yAyKAUMA0GCSqGSIb3DQEBCwUABIIBAKT4hJb5XXjt0dD92jasigsUbgIc

# gIOCXS9WcyWzD+LgsqzGE4hk8qdo7E6lXuKbx8Xs2LVrmNzWABgY2P9MQ4dMsgtB

# eI/96nmcpnBtissnatteJnJpdY/mGA5poSXcxcdnYyuHj+MKiPN/o5lTeCyaAXLD

# fM2j1Qg968A92FzmTqj9rNYZNW2YFjqSwacLxvh5O9MV81YWDSv5dU6Eb3saQJ+5

# k+dVZxGIkAOY1kuojHu5Gk0s2T1FCJjso+o1lOpxwnucK8cirHxAMo6ow9asUSWl

# 2Pots5hUisYsYSysYqYhDNV3vP+TzE95C0RJarJZm+VfxaeXE+j4hK7hs/A=

# SIG # End signature block