Azs.Syndication.Admin

0.1.161

Import.psm1

                                #-----------------------------------------------------------------------

# Copyright (c) Microsoft Corporation. All rights reserved.

#-----------------------------------------------------------------------

# .EXTERNALHELP Import.psm1-Help.xml

function Import-AzsMarketplaceItem {

    [CmdletBinding()]

    param (

        [Parameter(Mandatory = $false)]

        [bool] $isFileShare = $true,

        [Parameter(Mandatory = $true)]

        [string] $RepositoryDir,

        [Parameter(Mandatory = $false)]

        [string] $JournalDir,

        [Parameter(Mandatory = $false)]

        [string[]] $ProductName,

        [Parameter(Mandatory = $false)]

        [string] $SourceContainerName = "temp",

        [Parameter(Mandatory = $false)]

        [ValidateSet('Upload', 'Import', 'Cleanup')]

        [string] $From = 'Initialize',

        [Parameter(Mandatory = $false)]

        [ValidateSet('Upload', 'Import', 'Cleanup')]

        [string] $UpTo = 'Cleanup',

        [Parameter(Mandatory = $false)]

        [ValidateRange(5, 60)]

        [int] $SleepInterval = 60

    )

    function Upload-AllProducts {

        param ()

        function Initialize-StorageAccount {

            param ()

            Start-Activity 'Initialize-StorageAccount'

            Select-AzSubscription -Subscription 'Default Provider Subscription' -ErrorAction Stop | Out-Null

            New-AzResourceGroup -Name $ResourceGroupName -Location $Location -Force -ErrorAction Stop | Out-Null

            $sa = Get-AzStorageAccount -ResourceGroupName $ResourceGroupName -Name $StorageAccountName -ErrorAction SilentlyContinue

            if (-not $sa) {

                $sa = New-AzStorageAccount -ResourceGroupName $ResourceGroupName -Name $StorageAccountName -Location $Location -SkuName Standard_LRS -ErrorAction Stop

            }

            Stop-Activity

            return $sa.Context.ConnectionString

        }

        function Invoke-Upload {

            param (

                [ValidateNotNullOrEmpty()]

                [string] $ConnectionString

            )

            Start-Activity 'Invoke-Upload'

            while ($true) {

                & "$PSScriptRoot\SyndicationClient.exe" upload $RepositoryDir $JournalDir $ConnectionString

                if ($LASTEXITCODE -eq 0) {

                    break

                }

                Write-Verbose "Sleep for $SleepInterval seconds" -Verbose

                Start-Sleep -Seconds $SleepInterval

            }

            Stop-Activity

        }

        function Invoke-Copy {

            param (

                [ValidateNotNullOrEmpty()]

                [string] $SourceConnectionString,

                [ValidateNotNullOrEmpty()]

                [string] $DestinationConnectionString,

                [ValidateNotNullOrEmpty()]

                [string] $SourceContainerName

            )

            Start-Activity 'Invoke-Copy'

            while ($true) {

                & "$PSScriptRoot\SyndicationClient.exe" copy $JournalDir $SourceConnectionString $DestinationConnectionString $SourceContainerName

                if ($LASTEXITCODE -eq 0) {

                    break

                }

                Write-Verbose "Sleep for $SleepInterval seconds" -Verbose

                Start-Sleep -Seconds $SleepInterval

            }

            Stop-Activity

        }

        #-----------------------------------------------------------------------

        function Upload-AllProducts {

            Start-Activity 'Upload-AllProducts'

            $productList = Get-ProductList -ProductNames $ProductName

            $uploadJobInfo = @{

                productNames = @() + ($productList | ForEach-Object { $_.ProductName })

            }

            $uploadJobInfo | ConvertTo-Json -Depth 99 | Set-Content -LiteralPath "$JournalDir\.import-info.json" -Encoding UTF8

            $connectionString = Initialize-StorageAccount

            Invoke-Upload -ConnectionString $connectionString

            Stop-Activity

        }

        function Copy-AllProducts {

            Start-Activity 'Copy the blobs from the Storage account'

            Download-ProductDetails -ProductNames $ProductName

            $productList = Get-ProductList-FromBlob -ProductNames $ProductName

            $copyJobInfo = @{

                productNames = @() + ($productList | ForEach-Object { $_.ProductName })

            }

            $copyJobInfo | ConvertTo-Json -Depth 99 | Set-Content -LiteralPath "$JournalDir\.import-info.json" -Encoding UTF8

            $DestinationConnectionString = Initialize-StorageAccount

            $sourceConnectionString = $RepositoryDir

            Invoke-Copy -SourceConnectionString $sourceConnectionString -DestinationConnectionString $DestinationConnectionString -SourceContainerName $SourceContainerName

            Stop-Activity

        }

        if($isFileShare)

        {

            # if the path to the file share is given , then upload the products into the syndicationtempsa Storage Account

            Upload-AllProducts

        }

        else {

            # if the url of the deployment package is given , then copy the products into the syndicationtempsa Storage Account

            Copy-AllProducts

        }       

    }

    #-----------------------------------------------------------------------

    function Import-AllProducts {

        param ()

        function Import-Product {

            param (

                [psobject] $ProductDetails

            )

            Start-Activity "Import-Product, productName = $($ProductDetails.ProductName)"

            $productId = "$ActivationResourceId/downloadedProducts/$($productDetails.ProductName)"

            $requestUri = "$($productId)?api-version=2016-01-01"

            $response = Invoke-AzsResourceManager -Method GET -Uri $requestUri

            if ($response.StatusCode -eq [System.Net.HttpStatusCode]::NotFound) {

                $product = $null

            }

            else {

                Ensure-SuccessStatusCode -Response $response

                $product = $response.Content | ConvertFrom-Json

            }

            Write-Verbose "Provisioning state of $($productDetails.ProductName): $($product.properties.provisioningState)" -Verbose

            if (-not $product -or $product.properties.provisioningState -eq 'Failed') {

                Write-Verbose 'Initializing product import...' -Verbose

                $requestUri = "$($productId)?api-version=2016-01-01"

                $payload = Get-Content -LiteralPath "$JournalDir\$($productDetails.ProductName)\payload.json" -Raw | ConvertFrom-Json

                Invoke-AzsResourceManager -Method PUT -Uri $requestUri -Body @{ properties = $payload; } -ThrowOnError | Out-Null

            }

            Stop-Activity

        }

        function Wait-ForProducts {

            param (

                [psobject[]] $ProductList

            )

            Start-Activity 'Wait-ForProducts'

            $timeout = [timespan]::FromHours(6)

            $stopwatch = [System.Diagnostics.Stopwatch]::StartNew()

            while ($true) {

                Write-Verbose "[$(Get-Date -Format 's')] Get product import status" -Verbose

                $allDone = $true

                foreach ($productDetails in $ProductList) {

                    $productId = "$ActivationResourceId/downloadedProducts/$($productDetails.ProductName)"

                    $requestUri = "$($productId)?api-version=2016-01-01"

                    $response = Invoke-AzsResourceManager -Method GET -Uri $requestUri -ThrowOnError

                    $product = $response.Content | ConvertFrom-Json

                    Write-Verbose "Provisioning state of $($productDetails.ProductName): $($product.properties.provisioningState)" -Verbose

                    if ($product.properties.provisioningState -eq 'Failed') {

                        throw "Failed to import product, productId: $productId."

                    }

                    if ($product.properties.provisioningState -ne 'Succeeded') {

                        $allDone = $false

                    }

                }

                if ($allDone) {

                    break

                }

                if ($stopwatch.Elapsed -gt $timeout) {

                    throw 'Product import didn''t complete within the allotted time.'

                }

                Write-Verbose "Sleep for $SleepInterval seconds" -Verbose

                Start-Sleep -Seconds $SleepInterval

            }

            Stop-Activity

        }

        #-----------------------------------------------------------------------

        Start-Activity 'Import-AllProducts'

        $importJobInfo = Get-Content "$JournalDir\.import-info.json" -Raw | ConvertFrom-Json

        if($isFileShare){

            $productList = Get-ProductList -ProductNames $importJobInfo.productNames

        }

        else {

            $productList = Get-ProductList-FromBlob -ProductNames $importJobInfo.productNames

        }

        foreach ($productDetails in $productList) {

            Import-Product -ProductDetails $productDetails

        }

        Wait-ForProducts -ProductList $productList

        Stop-Activity

    }

    #-----------------------------------------------------------------------

    function Invoke-Cleanup {

        param ()

        Start-Activity 'Invoke-Cleanup'

        $rg = Get-AzResourceGroup -Name $ResourceGroupName -Location $Location -ErrorAction SilentlyContinue

        if ($rg) {

            Remove-AzResourceGroup -Name $ResourceGroupName -Force

        }

        if (Test-Path $JournalDir) {

            Remove-Item $JournalDir -Recurse -Force

        }

        Stop-Activity

    }

    #-----------------------------------------------------------------------

    function Resolve-Activation {

        param ()

        $activation = Get-AzResource -ResourceType Microsoft.AzureBridge.Admin/activations | Select-Object -First 1

        if (-not $activation) {

            throw 'Azure Stack activation not found. Make sure your stamp is activated and the selected subscription is ''Default Provider Subscription''.'

        }

        return $activation.ResourceId

    }

    function Get-ProductList {

        param (

            [string[]]$ProductNames

        )

        $products = @()

        if ($ProductNames) {

            $productDirs = $ProductNames | ForEach-Object { [System.IO.Path]::Combine($RepositoryDir, $_) }

        }

        else {

            $productDirs = Get-ChildItem -LiteralPath $RepositoryDir -Directory | ForEach-Object { $_.FullName }

        }

        foreach ($productDir in $productDirs) {

            $productDetailsFileName = [System.IO.Path]::Combine($productDir, "productDetails.json")

            $productDetails = Get-Content -LiteralPath $productDetailsFileName -Raw | ConvertFrom-Json

            $products += $productDetails

        }

        return $products

    }

    function Download-ProductDetails {

        param (

            [string[]]$ProductNames

        ) 

        foreach($ProductName in $ProductNames){

            $productDetailsBlob = $srcContainer.GetBlobReference("$($ProductName)\productDetails.json")

            $productDir = "$JournalDir\$ProductName"

            New-Item -Path $productDir -ItemType Directory -Force | Out-Null

            $fileMode = [System.IO.FileMode]::Create

            $task = $productDetailsBlob.DownloadToFileAsync("$($productDir)\productDetails.json" , $fileMode)

            $null = $task.GetAwaiter().GetResult()

        }

    }

    function Get-ProductList-FromBlob {

        param (

            [string[]]$ProductNames

        )

        $products = @()

        foreach($ProductName in $ProductNames){

            $productDir = "$JournalDir\$ProductName"

            $productDetailsFileName = [System.IO.Path]::Combine($productDir, "productDetails.json")

            $productDetails = Get-Content -LiteralPath $productDetailsFileName -Raw | ConvertFrom-Json

            $products += $productDetails            

        }

        return $products

    }

    function Get-ProductNameList-FromBlob {

        [Microsoft.WindowsAzure.Storage.Blob.BlobContinuationToken ]$token = $null

        $results = $srcContainer.ListBlobsSegmentedAsync($token)

        $productNames = $results.Result.Results

        $productNameEntities = @()

        foreach ($productName in $productNames) {

            if ([bool]($productName.PSobject.Properties.name -match "Prefix")) {

                $productName = $productName.Prefix.Trim('/')

                if([bool]($srcContainer.GetBlobReference("$productName\productDetails.json").ExistsAsync().Result)) {

                    $productNameEntities += $productName

                }

            }

        }

        return $productNameEntities

    }

    #-----------------------------------------------------------------------

    $Steps = @{

        Upload = 0

        Import = 1

        Cleanup = 2

    }

    $FromValue = $Steps[$From]

    $UpToValue = $Steps[$UpTo]

    $Location = (Get-AzLocation)[0].Location

    $ResourceGroupName = 'syndicationtemp-rg'

    $StorageAccountName = 'syndicationtempsa'

    if($isFileShare){

        $RepositoryDir = $ExecutionContext.SessionState.Path.GetUnresolvedProviderPathFromPSPath($RepositoryDir)

        New-Item -Path $RepositoryDir -ItemType Directory -Force | Out-Null

        Write-Verbose "RepositoryDir: $RepositoryDir" -Verbose

    }

    if (-not $JournalDir) {

        $JournalDir = [System.IO.Path]::Combine([System.IO.Path]::GetTempPath(), [guid]::NewGuid().ToString())

    }

    else {

        $JournalDir = $ExecutionContext.SessionState.Path.GetUnresolvedProviderPathFromPSPath($JournalDir)

    }

    New-Item -Path $JournalDir -ItemType Directory -Force | Out-Null

    $ActivationResourceId = Resolve-Activation

    if(-not $isFileShare){

        Write-Verbose "Importing the blobs from the container : $SourceContainerName" -Verbose

        Add-Type -Path "Microsoft.WindowsAzure.Storage.dll"

        $storageAccount = [Microsoft.WindowsAzure.Storage.CloudStorageAccount]::Parse($RepositoryDir)

        $srcContainer = $storageAccount.CreateCloudBlobClient().GetContainerReference($SourceContainerName)

        if ($null -eq $ProductName){

            Write-Verbose "Fetching the product names from the blob" -Verbose

            $ProductName = Get-ProductNameList-FromBlob

        }

    }

    Start-Activity 'Import'

    Write-Verbose "JournalDir: $JournalDir" -Verbose

    if ($FromValue -le $Steps.Upload -and $UpToValue -ge $Steps.Upload) {

        Upload-AllProducts

    }

    if ($FromValue -le $Steps.Import -and $UpToValue -ge $Steps.Import) {

        Import-AllProducts

    }

    if ($FromValue -le $Steps.Cleanup -and $UpToValue -ge $Steps.Cleanup) {

        Invoke-Cleanup

    }

    Stop-Activity

}

#-----------------------------------------------------------------------

$ErrorActionPreference = 'Stop'

$InformationPreference = 'Continue'

Import-Module "$PSScriptRoot\Activities.psm1" -Force -ErrorAction Stop

Import-Module "$PSScriptRoot\ResourceManager.psm1" -Force -DisableNameChecking -ErrorAction Stop

Export-ModuleMember -Function @('Import-AzsMarketplaceItem')

# SIG # Begin signature block

# MIIjkgYJKoZIhvcNAQcCoIIjgzCCI38CAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCB8Og3hXkPpnVvj

# MwfmVTHgAfggcg/tk6jam25fjD2k66CCDYEwggX/MIID56ADAgECAhMzAAACUosz

# qviV8znbAAAAAAJSMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjEwOTAyMTgzMjU5WhcNMjIwOTAxMTgzMjU5WjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDQ5M+Ps/X7BNuv5B/0I6uoDwj0NJOo1KrVQqO7ggRXccklyTrWL4xMShjIou2I

# sbYnF67wXzVAq5Om4oe+LfzSDOzjcb6ms00gBo0OQaqwQ1BijyJ7NvDf80I1fW9O

# L76Kt0Wpc2zrGhzcHdb7upPrvxvSNNUvxK3sgw7YTt31410vpEp8yfBEl/hd8ZzA

# v47DCgJ5j1zm295s1RVZHNp6MoiQFVOECm4AwK2l28i+YER1JO4IplTH44uvzX9o

# RnJHaMvWzZEpozPy4jNO2DDqbcNs4zh7AWMhE1PWFVA+CHI/En5nASvCvLmuR/t8

# q4bc8XR8QIZJQSp+2U6m2ldNAgMBAAGjggF+MIIBejAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUNZJaEUGL2Guwt7ZOAu4efEYXedEw

# UAYDVR0RBEkwR6RFMEMxKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1

# ZXJ0byBSaWNvMRYwFAYDVQQFEw0yMzAwMTIrNDY3NTk3MB8GA1UdIwQYMBaAFEhu

# ZOVQBdOCqhc3NyK1bajKdQKVMFQGA1UdHwRNMEswSaBHoEWGQ2h0dHA6Ly93d3cu

# bWljcm9zb2Z0LmNvbS9wa2lvcHMvY3JsL01pY0NvZFNpZ1BDQTIwMTFfMjAxMS0w

# Ny0wOC5jcmwwYQYIKwYBBQUHAQEEVTBTMFEGCCsGAQUFBzAChkVodHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY0NvZFNpZ1BDQTIwMTFfMjAx

# MS0wNy0wOC5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAgEAFkk3

# uSxkTEBh1NtAl7BivIEsAWdgX1qZ+EdZMYbQKasY6IhSLXRMxF1B3OKdR9K/kccp

# kvNcGl8D7YyYS4mhCUMBR+VLrg3f8PUj38A9V5aiY2/Jok7WZFOAmjPRNNGnyeg7

# l0lTiThFqE+2aOs6+heegqAdelGgNJKRHLWRuhGKuLIw5lkgx9Ky+QvZrn/Ddi8u

# TIgWKp+MGG8xY6PBvvjgt9jQShlnPrZ3UY8Bvwy6rynhXBaV0V0TTL0gEx7eh/K1

# o8Miaru6s/7FyqOLeUS4vTHh9TgBL5DtxCYurXbSBVtL1Fj44+Od/6cmC9mmvrti

# yG709Y3Rd3YdJj2f3GJq7Y7KdWq0QYhatKhBeg4fxjhg0yut2g6aM1mxjNPrE48z

# 6HWCNGu9gMK5ZudldRw4a45Z06Aoktof0CqOyTErvq0YjoE4Xpa0+87T/PVUXNqf

# 7Y+qSU7+9LtLQuMYR4w3cSPjuNusvLf9gBnch5RqM7kaDtYWDgLyB42EfsxeMqwK

# WwA+TVi0HrWRqfSx2olbE56hJcEkMjOSKz3sRuupFCX3UroyYf52L+2iVTrda8XW

# esPG62Mnn3T8AuLfzeJFuAbfOSERx7IFZO92UPoXE1uEjL5skl1yTZB3MubgOA4F

# 8KoRNhviFAEST+nG8c8uIsbZeb08SeYQMqjVEmkwggd6MIIFYqADAgECAgphDpDS

# AAAAAAADMA0GCSqGSIb3DQEBCwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UECBMK

# V2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0

# IENvcnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0

# ZSBBdXRob3JpdHkgMjAxMTAeFw0xMTA3MDgyMDU5MDlaFw0yNjA3MDgyMTA5MDla

# MH4xCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdS

# ZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMT

# H01pY3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMTEwggIiMA0GCSqGSIb3DQEB

# AQUAA4ICDwAwggIKAoICAQCr8PpyEBwurdhuqoIQTTS68rZYIZ9CGypr6VpQqrgG

# OBoESbp/wwwe3TdrxhLYC/A4wpkGsMg51QEUMULTiQ15ZId+lGAkbK+eSZzpaF7S

# 35tTsgosw6/ZqSuuegmv15ZZymAaBelmdugyUiYSL+erCFDPs0S3XdjELgN1q2jz

# y23zOlyhFvRGuuA4ZKxuZDV4pqBjDy3TQJP4494HDdVceaVJKecNvqATd76UPe/7

# 4ytaEB9NViiienLgEjq3SV7Y7e1DkYPZe7J7hhvZPrGMXeiJT4Qa8qEvWeSQOy2u

# M1jFtz7+MtOzAz2xsq+SOH7SnYAs9U5WkSE1JcM5bmR/U7qcD60ZI4TL9LoDho33

# X/DQUr+MlIe8wCF0JV8YKLbMJyg4JZg5SjbPfLGSrhwjp6lm7GEfauEoSZ1fiOIl

# XdMhSz5SxLVXPyQD8NF6Wy/VI+NwXQ9RRnez+ADhvKwCgl/bwBWzvRvUVUvnOaEP

# 6SNJvBi4RHxF5MHDcnrgcuck379GmcXvwhxX24ON7E1JMKerjt/sW5+v/N2wZuLB

# l4F77dbtS+dJKacTKKanfWeA5opieF+yL4TXV5xcv3coKPHtbcMojyyPQDdPweGF

# RInECUzF1KVDL3SV9274eCBYLBNdYJWaPk8zhNqwiBfenk70lrC8RqBsmNLg1oiM

# CwIDAQABo4IB7TCCAekwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFEhuZOVQ

# BdOCqhc3NyK1bajKdQKVMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMAsGA1Ud

# DwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFHItOgIxkEO5FAVO

# 4eqnxzHRI4k0MFoGA1UdHwRTMFEwT6BNoEuGSWh0dHA6Ly9jcmwubWljcm9zb2Z0

# LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dDIwMTFfMjAxMV8wM18y

# Mi5jcmwwXgYIKwYBBQUHAQEEUjBQME4GCCsGAQUFBzAChkJodHRwOi8vd3d3Lm1p

# Y3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dDIwMTFfMjAxMV8wM18y

# Mi5jcnQwgZ8GA1UdIASBlzCBlDCBkQYJKwYBBAGCNy4DMIGDMD8GCCsGAQUFBwIB

# FjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2RvY3MvcHJpbWFyeWNw

# cy5odG0wQAYIKwYBBQUHAgIwNB4yIB0ATABlAGcAYQBsAF8AcABvAGwAaQBjAHkA

# XwBzAHQAYQB0AGUAbQBlAG4AdAAuIB0wDQYJKoZIhvcNAQELBQADggIBAGfyhqWY

# 4FR5Gi7T2HRnIpsLlhHhY5KZQpZ90nkMkMFlXy4sPvjDctFtg/6+P+gKyju/R6mj

# 82nbY78iNaWXXWWEkH2LRlBV2AySfNIaSxzzPEKLUtCw/WvjPgcuKZvmPRul1LUd

# d5Q54ulkyUQ9eHoj8xN9ppB0g430yyYCRirCihC7pKkFDJvtaPpoLpWgKj8qa1hJ

# Yx8JaW5amJbkg/TAj/NGK978O9C9Ne9uJa7lryft0N3zDq+ZKJeYTQ49C/IIidYf

# wzIY4vDFLc5bnrRJOQrGCsLGra7lstnbFYhRRVg4MnEnGn+x9Cf43iw6IGmYslmJ

# aG5vp7d0w0AFBqYBKig+gj8TTWYLwLNN9eGPfxxvFX1Fp3blQCplo8NdUmKGwx1j

# NpeG39rz+PIWoZon4c2ll9DuXWNB41sHnIc+BncG0QaxdR8UvmFhtfDcxhsEvt9B

# xw4o7t5lL+yX9qFcltgA1qFGvVnzl6UJS0gQmYAf0AApxbGbpT9Fdx41xtKiop96

# eiL6SJUfq/tHI4D1nvi/a7dLl+LrdXga7Oo3mXkYS//WsyNodeav+vyL6wuA6mk7

# r/ww7QRMjt/fdW1jkT3RnVZOT7+AVyKheBEyIXrvQQqxP/uozKRdwaGIm1dxVk5I

# RcBCyZt2WwqASGv9eZ/BvW1taslScxMNelDNMYIVZzCCFWMCAQEwgZUwfjELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9z

# b2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAxMQITMwAAAlKLM6r4lfM52wAAAAACUjAN

# BglghkgBZQMEAgEFAKCBrjAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgor

# BgEEAYI3AgELMQ4wDAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQg3qnECZMT

# BcNvIBk041zW7edB0YZRDtWgSAD3zr3hv00wQgYKKwYBBAGCNwIBDDE0MDKgFIAS

# AE0AaQBjAHIAbwBzAG8AZgB0oRqAGGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbTAN

# BgkqhkiG9w0BAQEFAASCAQCGnxxeUmIEtLranEbhwxF1GOqHdQhzAr0uHiV6BH9d

# L40dTxI43gRqWAZt+3ZUiJvE7ge+9x6qzYS8CDvcZvl5yRpMCkTWLKefNdLR0Ro/

# X9I1KLzNrPYiNi7ZWA1fGv5KF0HIziSBO0WdQCyvnY8gafRyLo5jBYHaO8WXR4iQ

# RI3RzvAaSgQ2RMmyzas4WO0G2Y2lpLw7Zst4GbISthUF2aG+pkh3Nof3WibZSG4Y

# sfucJKthkK7wyOTXX4wqU/iLKPJq8tCuRuJsOUxASy8Ft9EwMOIqtdnqORIlkKHf

# 5jX1NJMKNSsnC+ED05GDjtgDcawQjHpxYhW20KyQt2I6oYIS8TCCEu0GCisGAQQB

# gjcDAwExghLdMIIS2QYJKoZIhvcNAQcCoIISyjCCEsYCAQMxDzANBglghkgBZQME

# AgEFADCCAVUGCyqGSIb3DQEJEAEEoIIBRASCAUAwggE8AgEBBgorBgEEAYRZCgMB

# MDEwDQYJYIZIAWUDBAIBBQAEIPNNi5fRVxnLtZQeke5vOC+rsZTTh/AbjgWmZHoQ

# BXesAgZhk970c34YEzIwMjExMjA4MjI0NDU4LjA2MVowBIACAfSggdSkgdEwgc4x

# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt

# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1p

# Y3Jvc29mdCBPcGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMg

# VFNTIEVTTjozMkJELUUzRDUtM0IxRDElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUt

# U3RhbXAgU2VydmljZaCCDkQwggT1MIID3aADAgECAhMzAAABYtD+AvMB5c1JAAAA

# AAFiMA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNo

# aW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29y

# cG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEw

# MB4XDTIxMDExNDE5MDIyMloXDTIyMDQxMTE5MDIyMlowgc4xCzAJBgNVBAYTAlVT

# MRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQK

# ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVy

# YXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjozMkJE

# LUUzRDUtM0IxRDElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vydmlj

# ZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAO+GodT2ucL3Mr2DQsv2

# ELNbSvKyBpYdUKtUBWiZmFVy18pG/pucgkrc5i9tu8CY7GpWV/CQNmHG2mVeSHMJ

# vbwCc/AAv7JP3bFCt6Zg75IbVSNOGA1eqLbmQiC6UAfSKXLN3dHtQ5diihb3Ymzp

# NP9K0cVPZfv2MXm+ZVU0RES8cyPkXel7+UEGE+kqdiBNDdb8yBXd8sju+90+V4nz

# YC+ZWW7SFJ2FFZlASpVaHpjv+eGohXlQaSBvmM4Q0xe3LhzQM8ViGz9cLeFSKgFf

# SY7qizL7wUg+eqYvDUyjPX8axEQHmk0th23wWH5p0Wduws43qNIo0OQ0mRotBK71

# nykCAwEAAaOCARswggEXMB0GA1UdDgQWBBTLxEoRYEpDtzp84B5WlZN2kP4qazAf

# BgNVHSMEGDAWgBTVYzpcijGQ80N7fEYbxTNoWoVtVTBWBgNVHR8ETzBNMEugSaBH

# hkVodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNU

# aW1TdGFQQ0FfMjAxMC0wNy0wMS5jcmwwWgYIKwYBBQUHAQEETjBMMEoGCCsGAQUF

# BzAChj5odHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY1RpbVN0

# YVBDQV8yMDEwLTA3LTAxLmNydDAMBgNVHRMBAf8EAjAAMBMGA1UdJQQMMAoGCCsG

# AQUFBwMIMA0GCSqGSIb3DQEBCwUAA4IBAQAtQa3DoXYbW/cXACbcVSFGe4gC8GXs

# FxSHT3JgwFU/NdJOcbkcFTVvTp6vlmTvHm6sIjknRBB0Xi1NBTqPw20u6u/T7Cnc

# /z0gT6mf9crI0VR9C+R1CtjezYKZEdZZ7fuNQWjsyftNDhQy+Rqnqryt0VoezLal

# heiinHzZD/4Y4hZYPf0u8TSv1ZfKtdBweWG3QU0Lp/I9SbIoemDG97RULMcPvq2u

# fhUp3OMiYQGL1WqkykSnqRJsM2IcA4l4dmoPNP6dLg5Dr7NVoYKIMInaQVZjSwDM

# ZhWryvfizX0SrzyLgkMPhLMVkfLxQQSQ37NeFk7F1RfeAkNWAh6mCORBMIIGcTCC

# BFmgAwIBAgIKYQmBKgAAAAAAAjANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJv

# b3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5IDIwMTAwHhcNMTAwNzAxMjEzNjU1WhcN

# MjUwNzAxMjE0NjU1WjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3Rv

# bjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0

# aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDCCASIw

# DQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAKkdDbx3EYo6IOz8E5f1+n9plGt0

# VBDVpQoAgoX77XxoSyxfxcPlYcJ2tz5mK1vwFVMnBDEfQRsalR3OCROOfGEwWbEw

# RA/xYIiEVEMM1024OAizQt2TrNZzMFcmgqNFDdDq9UeBzb8kYDJYYEbyWEeGMoQe

# dGFnkV+BVLHPk0ySwcSmXdFhE24oxhr5hoC732H8RsEnHSRnEnIaIYqvS2SJUGKx

# Xf13Hz3wV3WsvYpCTUBR0Q+cBj5nf/VmwAOWRH7v0Ev9buWayrGo8noqCjHw2k4G

# kbaICDXoeByw6ZnNPOcvRLqn9NxkvaQBwSAJk3jN/LzAyURdXhacAQVPIk0CAwEA

# AaOCAeYwggHiMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBTVYzpcijGQ80N7

# fEYbxTNoWoVtVTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTALBgNVHQ8EBAMC

# AYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBTV9lbLj+iiXGJo0T2UkFvX

# zpoYxDBWBgNVHR8ETzBNMEugSaBHhkVodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20v

# cGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcmwwWgYI

# KwYBBQUHAQEETjBMMEoGCCsGAQUFBzAChj5odHRwOi8vd3d3Lm1pY3Jvc29mdC5j

# b20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIzLmNydDCBoAYDVR0g

# AQH/BIGVMIGSMIGPBgkrBgEEAYI3LgMwgYEwPQYIKwYBBQUHAgEWMWh0dHA6Ly93

# d3cubWljcm9zb2Z0LmNvbS9QS0kvZG9jcy9DUFMvZGVmYXVsdC5odG0wQAYIKwYB

# BQUHAgIwNB4yIB0ATABlAGcAYQBsAF8AUABvAGwAaQBjAHkAXwBTAHQAYQB0AGUA

# bQBlAG4AdAAuIB0wDQYJKoZIhvcNAQELBQADggIBAAfmiFEN4sbgmD+BcQM9naOh

# IW+z66bM9TG+zwXiqf76V20ZMLPCxWbJat/15/B4vceoniXj+bzta1RXCCtRgkQS

# +7lTjMz0YBKKdsxAQEGb3FwX/1z5Xhc1mCRWS3TvQhDIr79/xn/yN31aPxzymXlK

# kVIArzgPF/UveYFl2am1a+THzvbKegBvSzBEJCI8z+0DpZaPWSm8tv0E4XCfMkon

# /VWvL/625Y4zu2JfmttXQOnxzplmkIz/amJ/3cVKC5Em4jnsGUpxY517IW3DnKOi

# PPp/fZZqkHimbdLhnPkd/DjYlPTGpQqWhqS9nhquBEKDuLWAmyI4ILUl5WTs9/S/

# fmNZJQ96LjlXdqJxqgaKD4kWumGnEcua2A5HmoDF0M2n0O99g/DhO3EJ3110mCII

# YdqwUB5vvfHhAN/nMQekkzr3ZUd46PioSKv33nJ+YWtvd6mBy6cJrDm77MbL2IK0

# cs0d9LiFAR6A+xuJKlQ5slvayA1VmXqHczsI5pgt6o3gMy4SKfXAL1QnIffIrE7a

# KLixqduWsqdCosnPGUFN4Ib5KpqjEWYw07t0MkvfY3v1mYovG8chr1m1rtxEPJdQ

# cdeh0sVV42neV8HR3jDA/czmTfsNv11P6Z0eGTgvvM9YBS7vDaBQNdrvCScc1bN+

# NR4Iuto229Nfj950iEkSoYIC0jCCAjsCAQEwgfyhgdSkgdEwgc4xCzAJBgNVBAYT

# AlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYD

# VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jvc29mdCBP

# cGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjoz

# MkJELUUzRDUtM0IxRDElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vy

# dmljZaIjCgEBMAcGBSsOAwIaAxUAmrP6Chrbz0ax7s57n5Pop3VC8gyggYMwgYCk

# fjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH

# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD

# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIF

# AOVbXeAwIhgPMjAyMTEyMDgyMDM3NTJaGA8yMDIxMTIwOTIwMzc1MlowdzA9Bgor

# BgEEAYRZCgQBMS8wLTAKAgUA5Vtd4AIBADAKAgEAAgIl5QIB/zAHAgEAAgISDzAK

# AgUA5VyvYAIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIB

# AAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBADNkjBVlGN+m3Njr

# REadvIKAdfyWgkaZcCFj3lujEhtXN4toOF9hiHOL70a3PN+H7rifkJtOzRXkR0AO

# tZSQB205WQTHZAyC0lT/ttDRjsugd5OStVjHxjdBLfRECab3xCWgdheHfiwgjXfz

# DHVxLxtohcYFtwuEwlmRDRpcbGuRMYIDDTCCAwkCAQEwgZMwfDELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp

# bWUtU3RhbXAgUENBIDIwMTACEzMAAAFi0P4C8wHlzUkAAAAAAWIwDQYJYIZIAWUD

# BAIBBQCgggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0B

# CQQxIgQgZ0ZF6P7p/sdGwB4WGrlDUo75ZVaLxYn9skA7guv8q20wgfoGCyqGSIb3

# DQEJEAIvMYHqMIHnMIHkMIG9BCCKqhiV+zwNDrpU7DRB7Mi57xi6GBNYsGjgZqq2

# qVMKMjCBmDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u

# MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp

# b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAAB

# YtD+AvMB5c1JAAAAAAFiMCIEID5o9jwWnluunZlL4PzNxmxvXUlPUTiGaOldc8u4

# lutOMA0GCSqGSIb3DQEBCwUABIIBAHyEDTTlUWrcqz5eyCW/r2LfyplVRLer+MGA

# yF1Yt//rMFUdmpEB4/Z1ZJHfXlPygg3SacE9hQjj+BMM6Try1Hop1fTYFtEYPx3U

# /U7rNu3nkFf+6ep7tCAcJ2Zc40/TFlu7CkwjtGeW7rB0UgQFtv6k4/AJxZfwbvvU

# zMHeEFo+3ndQB3Rs8qJs+EaV/ydKLfflLgOxwU9jXeSGXeeRNeZR4vZ4EchRhqBG

# e+n3He63GLYUpIiY2oUGQXt7tgXduuvJ/29T9n8Cc0a17xd9dRt4XckZ5wffxE48

# O6MPr2/mGRS9UkXK3Ew+vdwySSCyQfR5E9sAjVbPewRB/fbvrVk=

# SIG # End signature block