AzSKPreview.ADO

1.23.2

Framework/BugLog/AzSKADOAutoBugLogging.ps1

                                using namespace System.Management.Automation

Set-StrictMode -Version Latest 

class AzSKADOAutoBugLogging : CommandBase

{    

    [string] $OrgName

    [string] $BugLogProjectName

    $ScanResult = @();

    $ScanResultToCloseBug = @();

    hidden [InvocationInfo] $InvocationContext;

    hidden [bool] $IsLAFile = $false;

    $ResourceControlJson = @();

    $BugTemplate = $null;

    $STMappingFilePath = $null;

    $BugDescription = $null;

    [int] $MaxBugsToLog;

    AzSKADOAutoBugLogging([string] $organizationName, $BugLogProject, $AutoBugLog, $ResourceTypeName, $ControlIds, $scanResultData, $BugTemplate, [InvocationInfo] $invocationContext, $isLAFile, $stMappingFilePath, $BugDescription, $MaxBugLog): 

        Base($organizationName, $invocationContext) 

    { 

        $this.OrgName = $organizationName;

        $this.BugLogProjectName = $BugLogProject;

        $this.IsLAFile = $isLAFile;

        $this.BugTemplate = $BugTemplate;

        $this.STMappingFilePath = $stMappingFilePath;

        $this.BugDescription = $BugDescription;

        $this.MaxBugsToLog = $MaxBugLog

        #Can remove later if not needed.

        $resourcetypes = @()

        if($ResourceTypeName -ne [ResourceTypeName]::All)

        {

            $resourcetypes += ([SVTMapping]::AzSKADOResourceMapping |

                    Where-Object { $_.ResourceTypeName -eq $ResourceTypeName } | Select-Object JsonFileName, ResourceTypeName)

        }

        else

        {

            $resourcetypes += ([SVTMapping]::AzSKADOResourceMapping | Sort-Object ResourceTypeName | Select-Object JsonFileName, ResourceTypeName)

        }

        $resourcetypes = $resourcetypes | Sort-Object -Property JsonFileName -Unique

        foreach ($item in $resourcetypes) {

            $this.ResourceControlJson += [ConfigurationManager]::LoadServerConfigFile("$($item.JsonFileName)").Controls;

        }

        $this.GetAndFilterScanResultData($AutoBugLog, $ResourceTypeName, $ControlIds, $scanResultData, $isLAFile, $false);

    }

    AzSKADOAutoBugLogging([string] $organizationName, $BugLogProject, $ResourceTypeName, $ControlIds, $scanResultData, [InvocationInfo] $invocationContext, $isLAFile, $MaxBugLog): 

        Base($organizationName, $invocationContext) 

    { 

        $this.OrgName = $organizationName;

        $this.BugLogProjectName = $BugLogProject;

        $this.IsLAFile = $isLAFile;

        $this.MaxBugsToLog = $MaxBugLog

        #Can remove later if not needed.

        $resourcetypes = @()

        if($ResourceTypeName -ne [ResourceTypeName]::All)

        {

            $resourcetypes += ([SVTMapping]::AzSKADOResourceMapping |

                    Where-Object { $_.ResourceTypeName -eq $ResourceTypeName } | Select-Object JsonFileName, ResourceTypeName)

        }

        else

        {

            $resourcetypes += ([SVTMapping]::AzSKADOResourceMapping | Sort-Object ResourceTypeName | Select-Object JsonFileName, ResourceTypeName)

        }

        $resourcetypes = $resourcetypes | Sort-Object -Property JsonFileName -Unique

        foreach ($item in $resourcetypes) {

            $this.ResourceControlJson += [ConfigurationManager]::LoadServerConfigFile("$($item.JsonFileName)").Controls;

        }

        $this.GetAndFilterScanResultData($null, $ResourceTypeName, $ControlIds, $scanResultData, $isLAFile, $true);

    }

    [SVTEventContext[]] StartBugLogging()

    {

        return $this.InitiateBugLogging($false);

    }

    [SVTEventContext[]] ClosingLoggedBugs()

    {

        return $this.InitiateBugLogging($true);

    }

    hidden [SVTEventContext[]] InitiateBugLogging($isCloseBug) {  

        [ResourceContext] $ResourceContext = $null;

        [SVTEventContext[]] $ResourceContextControlResult = $null;

        $resourcesToLogBugs = @($this.ScanResult | Group-Object -Property ResourceId);

        if ($isCloseBug) {

            $this.PublishCustomMessage("`nNumber of resources for which bug clossing will be evaluated: $($resourcesToLogBugs.count)",[MessageType]::Info);

        }

        else {

            $this.PublishCustomMessage("`nNumber of resources for which bug logging will be evaluated: $($resourcesToLogBugs.count)",[MessageType]::Info);

        }

        foreach ($controlResult in $resourcesToLogBugs) {

            if ($this.IsLAFile) {

                $ResourceContext = [ResourceContext]@{

                    ResourceGroupName = $controlResult.Group[0].ResourceGroup;

                    ResourceName = $controlResult.Group[0].ResourceName_s;

                    ResourceType = "ADO."+$controlResult.Group[0].FeatureName_s;

                    ResourceTypeName = $controlResult.Group[0].FeatureName_s;

                    ResourceId = $controlResult.Group[0].ResourceId

                    ResourceDetails = @{ResourceLink = $controlResult.Group[0].ResourceLink_s}

                };    

            }

            else {

                $ResourceContext = [ResourceContext]@{

                    ResourceGroupName = $controlResult.Group[0].ResourceGroupName;

                    ResourceName = $controlResult.Group[0].ResourceName;

                    ResourceType = "ADO."+$controlResult.Group[0].FeatureName;

                    ResourceTypeName = $controlResult.Group[0].FeatureName;

                    ResourceId = $controlResult.Group[0].ResourceId

                    ResourceDetails = @{ResourceLink = $controlResult.Group[0].ResourceLink}

                };

            }

            $ResourceContextControlResult += $this.CreateResultContextObject($ResourceContext, $controlResult.Group);

        }

        return $this.BugLoggingEvaluation($ResourceContextControlResult, $isCloseBug);

    }

    #function to call AutoBugLog class for performing bug logging

    hidden [SVTEventContext []] BugLoggingEvaluation([SVTEventContext []] $ControlResults, $isCloseBug)

    {

        $AutoBugLog = $null;

        if (!$isCloseBug) {

            $AutoBugLog = [AutoBugLog]::AutoBugInstance

            if (!$AutoBugLog) {

                [BugLogPathManager]::checkValidPathFlag = $true;

                $BugLogParameterValue = $this.InvocationContext.BoundParameters["AutoBugLog"];

                $AutoBugLog = [AutoBugLog]::GetInstance($this.OrgName, $this.InvocationContext, $null, $BugLogParameterValue);

            }

            $resourcename = "";

            $resourceid = "";

            $assignee = "";

            #$ControlResults = $ControlResults | sort-object -property @{e={$_.ResourceContext.ResourceName}}

            foreach ($controlResult in $ControlResults) {

                #if different resource then only display message.

                if ($resourceid -ne $controlResult.ResourceContext.ResourceId ) {

                    $this.PublishCustomMessage([Constants]::DoubleDashLine, [MessageType]::Info);

                    $this.PublishCustomMessage("Running bug logging: [FeatureName: $($controlResult.FeatureName)] [ParentGroupName: $($controlResult.ResourceContext.ResourceGroupName)] [ResourceName: $($controlResult.ResourceContext.ResourceName)]", [MessageType]::Info);                

                }

                $resourcename = $controlResult.ResourceContext.ResourceName

                #if different resource then black assignee as for different resource assigneed need to evaluate again.

                if($resourceid -ne $controlResult.ResourceContext.ResourceId){

                    $assignee = "";

                }

                #if resource alredy ran bug logging for control and servicetree info is not find, then dont run bug logging for next control.

                if (($resourceid -ne $controlResult.ResourceContext.ResourceId) -or ($assignee) -or ($controlResult.FeatureName -eq "Organization" -or $controlResult.FeatureName -eq "Project")) {

                    $assignee = $AutoBugLog.LogBugsInADOFromCSV($controlResult, $this.BugLogProjectName, $this.BugTemplate, $this.STMappingFilePath, $this.BugDescription, $assignee)  

                }

                $resourceid = $controlResult.ResourceContext.ResourceId

            }

        }

        else {

            $this.PublishCustomMessage([Constants]::DoubleDashLine, [MessageType]::Info);

            $this.PublishCustomMessage("Closing bugs in bulk mode...", [MessageType]::Info);

            #$AutoClose = [AutoCloseBugManager]::new($this.OrganizationContext.OrganizationName);

            #$AutoClose.AutoCloseBugCSV($ControlResults)

        }

        $this.PublishCustomMessage([Constants]::DoubleDashLine, [MessageType]::Info);

        $this.PublishCustomMessage("Bug logging has been completed.", [MessageType]::Info);

        $this.PublishCustomMessage([Constants]::DoubleDashLine, [MessageType]::Info);

        return $ControlResults;

    }

    hidden [bool] GetAndFilterScanResultData($AutoBugLog, $ResourceTypeName, $ControlIds, $scanResultData, $isLAFile, $AutoCloseBug)

    {

        try {

            $this.PublishCustomMessage("`nFiltering scan result data.....",[MessageType]::Info);

            if (!$isLAFile) {

                if ($ResourceTypeName) {

                    $scanResultData = $scanResultData | Where { $_.FeatureName -eq $ResourceTypeName }

                }

                if ($AutoBugLog -eq "BaseLineControls" -and $scanResultData) {

                    $scanResultData = $scanResultData | Where { $_.IsBaselineControl -eq "Yes" }

                }

                if ($ControlIds -and $scanResultData) {

                    $cids = $this.ConvertToStringArray($ControlIds);

                    $scanResultData = $scanResultData | Where { $_.ControlId -In $cids }

                }

                if ($scanResultData -and $AutoBugLog -ne $null) {

                    $scanResultData = $scanResultData | Where {$_.Status -eq "Failed" -or $_.Status -eq "Varify"} 

                }

                if ($AutoCloseBug) {

                    $scanResultData = $scanResultData | Where {$_.Status -eq "Passed"} 

                }

                if ($scanResultData -and $this.MaxBugsToLog -and ($scanResultData.count -gt $this.MaxBugsToLog)) {

                    $scanResultData = $scanResultData[0..($this.MaxBugsToLog - 1)];

                }

                $this.ScanResult += $scanResultData;   

            }

            else {

                if ($ResourceTypeName) {

                    $scanResultData = $scanResultData | Where { $_.FeatureName_s -eq $ResourceTypeName }

                }

                if ($AutoBugLog -eq "BaseLineControls" -and $scanResultData) {

                    $scanResultData = $scanResultData | Where { $_.IsBaselineControl_b -eq "TRUE" }

                    Write-Host 'Can not read IsBaselineControl_b data from csv.' -ForegroundColor Yellow

                }

                if ($ControlIds -and $scanResultData) {

                    $cids = $this.ConvertToStringArray($ControlIds);

                    $scanResultData = $scanResultData | Where { $_.ControlId_s -In $cids }

                }

                if ($scanResultData -and $AutoBugLog -ne $null) {

                    $scanResultData = $scanResultData | Where {$_.ControlStatus_s -eq "Failed" -or $_.ControlStatus_s -eq "Verify"}

                }

                if ($AutoCloseBug) {

                    $scanResultData = $scanResultData | Where {$_.ControlStatus_s -eq "Passed"}

                }

                if ($scanResultData -and $this.MaxBugsToLog -and ($scanResultData.count -gt $this.MaxBugsToLog)) {

                    $scanResultData = $scanResultData[0..($this.MaxBugsToLog - 1)];

                }

                $this.ScanResult += $scanResultData;

            }

            return $true;   

        }

        catch {

            return $false;

        }

    }

    hidden [SVTEventContext[]] CreateResultContextObject($ResourceContext, $controlResult)

    {

        [SVTEventContext[]] $ResourceContextControlResult = @();

        [ControlResult[]] $controlResults = @();

        [ControlItem[]] $controlResults = @();

        foreach ($item in $controlResult) {

            $CtrlItm = [ControlItem]::new();

            if ($this.IsLAFile) 

            {

                $currentControlJson = $this.ResourceControlJson | Where {$_.ControlId -eq $item.ControlID_s}

                $CtrlItm.ID = $currentControlJson.ID

                $CtrlItm.ControlID = $item.ControlID_s

                $CtrlItm.ControlSeverity = $item.ControlSeverity_s

                #$CtrlItm.IsBaselineControl = $item.IsBaselineControl

                $CtrlItm.Description = $currentControlJson.Description 

                $CtrlItm.Recommendation = $currentControlJson.Recommendation

                $CtrlItm.Rationale = $currentControlJson.Rationale

                $CtrlResult = [ControlResult]::new();

                $CtrlResult.VerificationResult = $item.ControlStatus_s

                #$CtrlResult.ActualVerificationResult = $item.ActualVerificationResult_s

                $CtrlResult.AdditionalInfoInCSV = $item.AdditionalInfo_s

            }

            else {

                $currentControlJson = $this.ResourceControlJson | Where {$_.ControlId -eq $item.ControlID}

                $CtrlItm.ID = $currentControlJson.ID

                $CtrlItm.ControlID = $item.ControlID

                $CtrlItm.ControlSeverity = $item.ControlSeverity

                $CtrlItm.IsBaselineControl = $item.IsBaselineControl

                $CtrlItm.Description = $item.Description

                $CtrlItm.Recommendation = $item.Recommendation

                $CtrlItm.Rationale = $item.Rationale

                $CtrlResult = [ControlResult]::new();

                $CtrlResult.VerificationResult = $item.Status

                #$CtrlResult.ActualVerificationResult = $item.ActualStatus

                $CtrlResult.AdditionalInfoInCSV = $item.AdditionalInfo

            }

            $svtControlResult = [SVTEventContext]@{

                FeatureName = $ResourceContext[0].ResourceTypeName 

                Metadata = [Metadata]@{

                    Reference = "";

                };

                OrganizationContext = $this.OrganizationContext;

                ResourceContext = $ResourceContext;

                ControlResults = $CtrlResult;

                ControlItem = $CtrlItm;

            };

            $ResourceContextControlResult += $svtControlResult;

        }

        return $ResourceContextControlResult;

    }

}

# SIG # Begin signature block

# MIInwgYJKoZIhvcNAQcCoIInszCCJ68CAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCDnkvDsQZ6nMzDl

# tf5aAOaFN6GETNjQx1YZ2gtUaxkMUaCCDXYwggX0MIID3KADAgECAhMzAAADrzBA

# DkyjTQVBAAAAAAOvMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjMxMTE2MTkwOTAwWhcNMjQxMTE0MTkwOTAwWjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDOS8s1ra6f0YGtg0OhEaQa/t3Q+q1MEHhWJhqQVuO5amYXQpy8MDPNoJYk+FWA

# hePP5LxwcSge5aen+f5Q6WNPd6EDxGzotvVpNi5ve0H97S3F7C/axDfKxyNh21MG

# 0W8Sb0vxi/vorcLHOL9i+t2D6yvvDzLlEefUCbQV/zGCBjXGlYJcUj6RAzXyeNAN

# xSpKXAGd7Fh+ocGHPPphcD9LQTOJgG7Y7aYztHqBLJiQQ4eAgZNU4ac6+8LnEGAL

# go1ydC5BJEuJQjYKbNTy959HrKSu7LO3Ws0w8jw6pYdC1IMpdTkk2puTgY2PDNzB

# tLM4evG7FYer3WX+8t1UMYNTAgMBAAGjggFzMIIBbzAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQURxxxNPIEPGSO8kqz+bgCAQWGXsEw

# RQYDVR0RBD4wPKQ6MDgxHjAcBgNVBAsTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEW

# MBQGA1UEBRMNMjMwMDEyKzUwMTgyNjAfBgNVHSMEGDAWgBRIbmTlUAXTgqoXNzci

# tW2oynUClTBUBgNVHR8ETTBLMEmgR6BFhkNodHRwOi8vd3d3Lm1pY3Jvc29mdC5j

# b20vcGtpb3BzL2NybC9NaWNDb2RTaWdQQ0EyMDExXzIwMTEtMDctMDguY3JsMGEG

# CCsGAQUFBwEBBFUwUzBRBggrBgEFBQcwAoZFaHR0cDovL3d3dy5taWNyb3NvZnQu

# Y29tL3BraW9wcy9jZXJ0cy9NaWNDb2RTaWdQQ0EyMDExXzIwMTEtMDctMDguY3J0

# MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIBAISxFt/zR2frTFPB45Yd

# mhZpB2nNJoOoi+qlgcTlnO4QwlYN1w/vYwbDy/oFJolD5r6FMJd0RGcgEM8q9TgQ

# 2OC7gQEmhweVJ7yuKJlQBH7P7Pg5RiqgV3cSonJ+OM4kFHbP3gPLiyzssSQdRuPY

# 1mIWoGg9i7Y4ZC8ST7WhpSyc0pns2XsUe1XsIjaUcGu7zd7gg97eCUiLRdVklPmp

# XobH9CEAWakRUGNICYN2AgjhRTC4j3KJfqMkU04R6Toyh4/Toswm1uoDcGr5laYn

# TfcX3u5WnJqJLhuPe8Uj9kGAOcyo0O1mNwDa+LhFEzB6CB32+wfJMumfr6degvLT

# e8x55urQLeTjimBQgS49BSUkhFN7ois3cZyNpnrMca5AZaC7pLI72vuqSsSlLalG

# OcZmPHZGYJqZ0BacN274OZ80Q8B11iNokns9Od348bMb5Z4fihxaBWebl8kWEi2O

# PvQImOAeq3nt7UWJBzJYLAGEpfasaA3ZQgIcEXdD+uwo6ymMzDY6UamFOfYqYWXk

# ntxDGu7ngD2ugKUuccYKJJRiiz+LAUcj90BVcSHRLQop9N8zoALr/1sJuwPrVAtx

# HNEgSW+AKBqIxYWM4Ev32l6agSUAezLMbq5f3d8x9qzT031jMDT+sUAoCw0M5wVt

# CUQcqINPuYjbS1WgJyZIiEkBMIIHejCCBWKgAwIBAgIKYQ6Q0gAAAAAAAzANBgkq

# hkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x

# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv

# bjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5

# IDIwMTEwHhcNMTEwNzA4MjA1OTA5WhcNMjYwNzA4MjEwOTA5WjB+MQswCQYDVQQG

# EwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG

# A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSgwJgYDVQQDEx9NaWNyb3NvZnQg

# Q29kZSBTaWduaW5nIFBDQSAyMDExMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIIC

# CgKCAgEAq/D6chAcLq3YbqqCEE00uvK2WCGfQhsqa+laUKq4BjgaBEm6f8MMHt03

# a8YS2AvwOMKZBrDIOdUBFDFC04kNeWSHfpRgJGyvnkmc6Whe0t+bU7IKLMOv2akr

# rnoJr9eWWcpgGgXpZnboMlImEi/nqwhQz7NEt13YxC4Ddato88tt8zpcoRb0Rrrg

# OGSsbmQ1eKagYw8t00CT+OPeBw3VXHmlSSnnDb6gE3e+lD3v++MrWhAfTVYoonpy

# 4BI6t0le2O3tQ5GD2Xuye4Yb2T6xjF3oiU+EGvKhL1nkkDstrjNYxbc+/jLTswM9

# sbKvkjh+0p2ALPVOVpEhNSXDOW5kf1O6nA+tGSOEy/S6A4aN91/w0FK/jJSHvMAh

# dCVfGCi2zCcoOCWYOUo2z3yxkq4cI6epZuxhH2rhKEmdX4jiJV3TIUs+UsS1Vz8k

# A/DRelsv1SPjcF0PUUZ3s/gA4bysAoJf28AVs70b1FVL5zmhD+kjSbwYuER8ReTB

# w3J64HLnJN+/RpnF78IcV9uDjexNSTCnq47f7Fufr/zdsGbiwZeBe+3W7UvnSSmn

# Eyimp31ngOaKYnhfsi+E11ecXL93KCjx7W3DKI8sj0A3T8HhhUSJxAlMxdSlQy90

# lfdu+HggWCwTXWCVmj5PM4TasIgX3p5O9JawvEagbJjS4NaIjAsCAwEAAaOCAe0w

# ggHpMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRIbmTlUAXTgqoXNzcitW2o

# ynUClTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTALBgNVHQ8EBAMCAYYwDwYD

# VR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBRyLToCMZBDuRQFTuHqp8cx0SOJNDBa

# BgNVHR8EUzBRME+gTaBLhklodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtpL2Ny

# bC9wcm9kdWN0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFfMDNfMjIuY3JsMF4GCCsG

# AQUFBwEBBFIwUDBOBggrBgEFBQcwAoZCaHR0cDovL3d3dy5taWNyb3NvZnQuY29t

# L3BraS9jZXJ0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFfMDNfMjIuY3J0MIGfBgNV

# HSAEgZcwgZQwgZEGCSsGAQQBgjcuAzCBgzA/BggrBgEFBQcCARYzaHR0cDovL3d3

# dy5taWNyb3NvZnQuY29tL3BraW9wcy9kb2NzL3ByaW1hcnljcHMuaHRtMEAGCCsG

# AQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAHAAbwBsAGkAYwB5AF8AcwB0AGEAdABl

# AG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQBn8oalmOBUeRou09h0ZyKb

# C5YR4WOSmUKWfdJ5DJDBZV8uLD74w3LRbYP+vj/oCso7v0epo/Np22O/IjWll11l

# hJB9i0ZQVdgMknzSGksc8zxCi1LQsP1r4z4HLimb5j0bpdS1HXeUOeLpZMlEPXh6

# I/MTfaaQdION9MsmAkYqwooQu6SpBQyb7Wj6aC6VoCo/KmtYSWMfCWluWpiW5IP0

# wI/zRive/DvQvTXvbiWu5a8n7dDd8w6vmSiXmE0OPQvyCInWH8MyGOLwxS3OW560

# STkKxgrCxq2u5bLZ2xWIUUVYODJxJxp/sfQn+N4sOiBpmLJZiWhub6e3dMNABQam

# ASooPoI/E01mC8CzTfXhj38cbxV9Rad25UAqZaPDXVJihsMdYzaXht/a8/jyFqGa

# J+HNpZfQ7l1jQeNbB5yHPgZ3BtEGsXUfFL5hYbXw3MYbBL7fQccOKO7eZS/sl/ah

# XJbYANahRr1Z85elCUtIEJmAH9AAKcWxm6U/RXceNcbSoqKfenoi+kiVH6v7RyOA

# 9Z74v2u3S5fi63V4GuzqN5l5GEv/1rMjaHXmr/r8i+sLgOppO6/8MO0ETI7f33Vt

# Y5E90Z1WTk+/gFcioXgRMiF670EKsT/7qMykXcGhiJtXcVZOSEXAQsmbdlsKgEhr

# /Xmfwb1tbWrJUnMTDXpQzTGCGaIwghmeAgEBMIGVMH4xCzAJBgNVBAYTAlVTMRMw

# EQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVN

# aWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNp

# Z25pbmcgUENBIDIwMTECEzMAAAOvMEAOTKNNBUEAAAAAA68wDQYJYIZIAWUDBAIB

# BQCgga4wGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIBCzEO

# MAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEICX+hHwNSaQajmRj2ppSwRtG

# TsJ5+3AXtlSXn1wCY8W9MEIGCisGAQQBgjcCAQwxNDAyoBSAEgBNAGkAYwByAG8A

# cwBvAGYAdKEagBhodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20wDQYJKoZIhvcNAQEB

# BQAEggEAGB3g9Uva+4GLfOJ+FFb8COQHIWhtjGc/pGGW9yMPKAga/DTF4UdDANOA

# CUpjZrodyo5gzl72vV104/wyTj+yPq/7NX5jqDr/21z7t4qiunaMJY0EP8EHlUgQ

# dVqXLqx8ywym1Eog2QWv+N7TKg2cVcDLYxBCXj2ZE5muu6TELBj7rCNf/NCXWSiN

# O2uTiBFjlBhndHCm6JaT5DacsILwIoJc+vk/tjVZ2bKvxcsDiUoRll8pvGHRHU4s

# Z2CVWUtZVzs9f5svb8OuD7yOhuCN2hmuiAHbH7Zjeo99dML68ExVwc2jTL1kx4w1

# 6mkOumnXihAp477rgrsyg8E22j6eOaGCFywwghcoBgorBgEEAYI3AwMBMYIXGDCC

# FxQGCSqGSIb3DQEHAqCCFwUwghcBAgEDMQ8wDQYJYIZIAWUDBAIBBQAwggFZBgsq

# hkiG9w0BCRABBKCCAUgEggFEMIIBQAIBAQYKKwYBBAGEWQoDATAxMA0GCWCGSAFl

# AwQCAQUABCBfAZBKT1940lGn9HEG1G7FEQKlKvR/HAWLI7Z13IXrQgIGZbqfiijx

# GBMyMDI0MDIxNTA4MzIzMS45ODlaMASAAgH0oIHYpIHVMIHSMQswCQYDVQQGEwJV

# UzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UE

# ChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJl

# bGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxJjAkBgNVBAsTHVRoYWxlcyBUU1MgRVNO

# OjA4NDItNEJFNi1DMjlBMSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBT

# ZXJ2aWNloIIRezCCBycwggUPoAMCAQICEzMAAAHajtXJWgDREbEAAQAAAdowDQYJ

# KoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x

# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv

# bjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwHhcNMjMx

# MDEyMTkwNjU5WhcNMjUwMTEwMTkwNjU5WjCB0jELMAkGA1UEBhMCVVMxEzARBgNV

# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv

# c29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxhbmQgT3Bl

# cmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjowODQyLTRC

# RTYtQzI5QTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZTCC

# AiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAJOQBgh2tVFR1j8jQA4NDf8b

# cVrXSN080CNKPSQo7S57sCnPU0FKF47w2L6qHtwm4EnClF2cruXFp/l7PpMQg25E

# 7X8xDmvxr8BBE6iASAPCfrTebuvAsZWcJYhy7prgCuBf7OidXpgsW1y8p6Vs7sD2

# aup/0uveYxeXlKtsPjMCplHkk0ba+HgLho0J68Kdji3DM2K59wHy9xrtsYK+X9er

# bDGZ2mmX3765aS5Q7/ugDxMVgzyj80yJn6ULnknD9i4kUQxVhqV1dc/DF6UBeuzf

# ukkMed7trzUEZMRyla7qhvwUeQlgzCQhpZjz+zsQgpXlPczvGd0iqr7lACwfVGog

# 5plIzdExvt1TA8Jmef819aTKwH1IVEIwYLA6uvS8kRdA6RxvMcb//ulNjIuGceyy

# kMAXEynVrLG9VvK4rfrCsGL3j30Lmidug+owrcCjQagYmrGk1hBykXilo9YB8Qyy

# 5Q1KhGuH65V3zFy8a0kwbKBRs8VR4HtoPYw9z1DdcJfZBO2dhzX3yAMipCGm6Smv

# mvavRsXhy805jiApDyN+s0/b7os2z8iRWGJk6M9uuT2493gFV/9JLGg5YJJCJXI+

# yxkO/OXnZJsuGt0+zWLdHS4XIXBG17oPu5KsFfRTHREloR2dI6GwaaxIyDySHYOt

# vIydla7u4lfnfCjY/qKTAgMBAAGjggFJMIIBRTAdBgNVHQ4EFgQUoXyNyVE9ZhOV

# izEUVwhNgL8PX0UwHwYDVR0jBBgwFoAUn6cVXQBeYl2D9OXSZacbUzUZ6XIwXwYD

# VR0fBFgwVjBUoFKgUIZOaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9j

# cmwvTWljcm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIwMTAoMSkuY3JsMGwG

# CCsGAQUFBwEBBGAwXjBcBggrBgEFBQcwAoZQaHR0cDovL3d3dy5taWNyb3NvZnQu

# Y29tL3BraW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBUaW1lLVN0YW1wJTIwUENBJTIw

# MjAxMCgxKS5jcnQwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcD

# CDAOBgNVHQ8BAf8EBAMCB4AwDQYJKoZIhvcNAQELBQADggIBALmDVdTtuI0jAEt4

# 1O2OM8CU237TGMyhrGr7FzKCEFaXxtoqk/IObQriq1caHVh2vyuQ24nz3TdOBv7r

# cs/qnPjOxnXFLyZPeaWLsNuARVmUViyVYXjXYB5DwzaWZgScY8GKL7yGjyWrh78W

# JUgh7rE1+5VD5h0/6rs9dBRqAzI9fhZz7spsjt8vnx50WExbBSSH7rfabHendpeq

# bTmW/RfcaT+GFIsT+g2ej7wRKIq/QhnsoF8mpFNPHV1q/WK/rF/ChovkhJMDvlqt

# ETWi97GolOSKamZC9bYgcPKfz28ed25WJy10VtQ9P5+C/2dOfDaz1RmeOb27Kbeg

# ha0SfPcriTfORVvqPDSa3n9N7dhTY7+49I8evoad9hdZ8CfIOPftwt3xTX2RhMZJ

# CVoFlabHcvfb84raFM6cz5EYk+x1aVEiXtgK6R0xn1wjMXHf0AWlSjqRkzvSnRKz

# FsZwEl74VahlKVhI+Ci9RT9+6Gc0xWzJ7zQIUFE3Jiix5+7KL8ArHfBY9UFLz4sn

# boJ7Qip3IADbkU4ZL0iQ8j8Ixra7aSYfToUefmct3dM69ff4Eeh2Kh9NsKiiph58

# 9Ap/xS1jESlrfjL/g/ZboaS5d9a2fA598mubDvLD5x5PP37700vm/Y+PIhmp2fTv

# uS2sndeZBmyTqcUNHRNmCk+njV3nMIIHcTCCBVmgAwIBAgITMwAAABXF52ueAptJ

# mQAAAAAAFTANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgT

# Cldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29m

# dCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNh

# dGUgQXV0aG9yaXR5IDIwMTAwHhcNMjEwOTMwMTgyMjI1WhcNMzAwOTMwMTgzMjI1

# WjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH

# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD

# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDCCAiIwDQYJKoZIhvcNAQEB

# BQADggIPADCCAgoCggIBAOThpkzntHIhC3miy9ckeb0O1YLT/e6cBwfSqWxOdcjK

# NVf2AX9sSuDivbk+F2Az/1xPx2b3lVNxWuJ+Slr+uDZnhUYjDLWNE893MsAQGOhg

# fWpSg0S3po5GawcU88V29YZQ3MFEyHFcUTE3oAo4bo3t1w/YJlN8OWECesSq/XJp

# rx2rrPY2vjUmZNqYO7oaezOtgFt+jBAcnVL+tuhiJdxqD89d9P6OU8/W7IVWTe/d

# vI2k45GPsjksUZzpcGkNyjYtcI4xyDUoveO0hyTD4MmPfrVUj9z6BVWYbWg7mka9

# 7aSueik3rMvrg0XnRm7KMtXAhjBcTyziYrLNueKNiOSWrAFKu75xqRdbZ2De+JKR

# Hh09/SDPc31BmkZ1zcRfNN0Sidb9pSB9fvzZnkXftnIv231fgLrbqn427DZM9itu

# qBJR6L8FA6PRc6ZNN3SUHDSCD/AQ8rdHGO2n6Jl8P0zbr17C89XYcz1DTsEzOUyO

# ArxCaC4Q6oRRRuLRvWoYWmEBc8pnol7XKHYC4jMYctenIPDC+hIK12NvDMk2ZItb

# oKaDIV1fMHSRlJTYuVD5C4lh8zYGNRiER9vcG9H9stQcxWv2XFJRXRLbJbqvUAV6

# bMURHXLvjflSxIUXk8A8FdsaN8cIFRg/eKtFtvUeh17aj54WcmnGrnu3tz5q4i6t

# AgMBAAGjggHdMIIB2TASBgkrBgEEAYI3FQEEBQIDAQABMCMGCSsGAQQBgjcVAgQW

# BBQqp1L+ZMSavoKRPEY1Kc8Q/y8E7jAdBgNVHQ4EFgQUn6cVXQBeYl2D9OXSZacb

# UzUZ6XIwXAYDVR0gBFUwUzBRBgwrBgEEAYI3TIN9AQEwQTA/BggrBgEFBQcCARYz

# aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9Eb2NzL1JlcG9zaXRvcnku

# aHRtMBMGA1UdJQQMMAoGCCsGAQUFBwMIMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIA

# QwBBMAsGA1UdDwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFNX2

# VsuP6KJcYmjRPZSQW9fOmhjEMFYGA1UdHwRPME0wS6BJoEeGRWh0dHA6Ly9jcmwu

# bWljcm9zb2Z0LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dF8yMDEw

# LTA2LTIzLmNybDBaBggrBgEFBQcBAQROMEwwSgYIKwYBBQUHMAKGPmh0dHA6Ly93

# d3cubWljcm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYt

# MjMuY3J0MA0GCSqGSIb3DQEBCwUAA4ICAQCdVX38Kq3hLB9nATEkW+Geckv8qW/q

# XBS2Pk5HZHixBpOXPTEztTnXwnE2P9pkbHzQdTltuw8x5MKP+2zRoZQYIu7pZmc6

# U03dmLq2HnjYNi6cqYJWAAOwBb6J6Gngugnue99qb74py27YP0h1AdkY3m2CDPVt

# I1TkeFN1JFe53Z/zjj3G82jfZfakVqr3lbYoVSfQJL1AoL8ZthISEV09J+BAljis

# 9/kpicO8F7BUhUKz/AyeixmJ5/ALaoHCgRlCGVJ1ijbCHcNhcy4sa3tuPywJeBTp

# kbKpW99Jo3QMvOyRgNI95ko+ZjtPu4b6MhrZlvSP9pEB9s7GdP32THJvEKt1MMU0

# sHrYUP4KWN1APMdUbZ1jdEgssU5HLcEUBHG/ZPkkvnNtyo4JvbMBV0lUZNlz138e

# W0QBjloZkWsNn6Qo3GcZKCS6OEuabvshVGtqRRFHqfG3rsjoiV5PndLQTHa1V1QJ

# sWkBRH58oWFsc/4Ku+xBZj1p/cvBQUl+fpO+y/g75LcVv7TOPqUxUYS8vwLBgqJ7

# Fx0ViY1w/ue10CgaiQuPNtq6TPmb/wrpNPgkNWcr4A245oyZ1uEi6vAnQj0llOZ0

# dFtq0Z4+7X6gMTN9vMvpe784cETRkPHIqzqKOghif9lwY1NNje6CbaUFEMFxBmoQ

# tB1VM1izoXBm8qGCAtcwggJAAgEBMIIBAKGB2KSB1TCB0jELMAkGA1UEBhMCVVMx

# EzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoT

# FU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxh

# bmQgT3BlcmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjow

# ODQyLTRCRTYtQzI5QTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vy

# dmljZaIjCgEBMAcGBSsOAwIaAxUAQqIfIYljHUbNoY0/wjhXRn/sSA2ggYMwgYCk

# fjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH

# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD

# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIF

# AOl4OVUwIhgPMjAyNDAyMTUxNTE4NDVaGA8yMDI0MDIxNjE1MTg0NVowdzA9Bgor

# BgEEAYRZCgQBMS8wLTAKAgUA6Xg5VQIBADAKAgEAAgIBcwIB/zAHAgEAAgIR0DAK

# AgUA6XmK1QIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIB

# AAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAKCvblXsjSLTfd3P

# 2QAQZYrNwkQ+oIyY49nPcXdtze0vTtWfJp93KvNmW7EacU5+5PJvRdZwUMOgaWcg

# EEzMxyxYm8/DmXBrrpJhnYLohJO7QNl5GLxhMXF+RS/JBObcDi9W3g5gSeo8C+3x

# c2BhlJiOuQ3e9kXbp7yyoJsu+4rvMYIEDTCCBAkCAQEwgZMwfDELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp

# bWUtU3RhbXAgUENBIDIwMTACEzMAAAHajtXJWgDREbEAAQAAAdowDQYJYIZIAWUD

# BAIBBQCgggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0B

# CQQxIgQgUZUUsn3odk2j+G4ZxsVzgO8RZ5QmIGre+34dwJDJG48wgfoGCyqGSIb3

# DQEJEAIvMYHqMIHnMIHkMIG9BCAipaNpYsDvnqTe95Dj1C09020I5ljibrW/ndIC

# Oxg9xjCBmDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u

# MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp

# b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAAB

# 2o7VyVoA0RGxAAEAAAHaMCIEIB7rxM/LsedRyf1X20Ifl3wW+XS9YShocIhKX9T9

# BZOBMA0GCSqGSIb3DQEBCwUABIICAE/rzK9P3BeMuLQZnXR0n39aG9cfin5KtDHj

# +XCGMiE4Jsu5Or0ELzC7jqvEe1plqfy380lnAj6vH1Gm/xPTs9qWXkZju0xk4/0f

# LbfNhw/beA7kG9sAeEYqszUBTQNR0bb+pk8Wd/F5lBAPLmjXIo84oLD6NAAxF6ZE

# qyxpn/fdZV65keHz6rZKMNtt6zSLpgecvsGMM/jqbo+Ll2Ao8jkQo1n2xrjVBD3c

# q/fmf0ITItrqz/1q3U7QG5deixGpTSjE4Gt8uTJkOJ6n9ndxoW86ge6yKT9Wr55S

# ANkFqr43xmJU2rL6VVYVS6USLtaJWWn7z660kg7KxMjfDmoCdmEB+rrznzuMtfsv

# w40bm3Da+EID9m8z+Mm0v3jZ84U9LmMmcITxo2AIIXF5TmUNRUWval3DDgcO8OKX

# CkA2TvkETkqdUdBnSf6QZthCeLpcvwwQuXjknc1msdjg2err6EPCFJOjp1XyEPXM

# ujd0up8jjV8a774VZyLWU+/bQrqE7IkmQjW/fg4a9mBMn/mYzDCKlcE8h5si1IrZ

# /iy97y7ErjRQtRzBedeah+Q60Czs/T+Y9/gD+4Ec0lnL8YZeLr+KUYTN2OxMFxRD

# 1NqpQvEZ76kwcyQ1VbB7LneUFl0sebpBqpuzY3/VD7UHVG9xBUq1RBRNKbjM3HL8

# VSIqKdD2

# SIG # End signature block