biz.dfch.PS.Appclusive.Client

5.2.0.20161201

Set-KeyNameValue.ps1

                                function Set-KeyNameValue {

<#

.SYNOPSIS

Sets or creates a K/N/V entry in Appclusive.

.DESCRIPTION

Sets or creates a K/N/V entry in Appclusive.

By updating a K/N/V entry you can specify if you want to update the Key, Name, Value or any combination thereof.

.OUTPUTS

default | json | json-pretty | xml | xml-pretty | PSCredential | Clear

.EXAMPLE

Set-KeyNameValue myKey myName myValue -CreateIfNotExist

Id         : 3131

Key        : myKey

Name       : myName

Value      : myValue

CreatedBy  : SERVER1\Administrator

Created    : 11/13/2014 11:08:46 PM +00:00

ModifiedBy : SERVER1\Administrator

Modified   : 11/13/2014 11:08:46 PM +00:00

RowVersion : {0, 0, 0, 0...}

Create a new K/N/V entry if it does not exists.

.EXAMPLE

Set-KeyNameValue myKey -NewKey myNewKey myName myValue -NewValue myNewValue

Id         : 3131

Key        : myNewKey

Name       : myName

Value      : myNewValue

CreatedBy  : SERVER1\Administrator

Created    : 11/13/2014 11:08:46 PM +00:00

ModifiedBy : SERVER1\Administrator

Modified   : 11/13/2014 11:08:46 PM +00:00

RowVersion : {0, 0, 0, 0...}

Update an existing K/N/V with new key and new value.

.EXAMPLE

Set-KeyNameValue myNewKey -NewKey myNewKey2 myName myNewValue -NewValue myNewValue2 -as json-pretty

{

  "Id":  3131,

  "Key":  "myNewKey2",

  "Name":  "myName",

  "Value":  "myNewValue2",

  "CreatedBy":  "SERVER1\\Administrator",

  "Created":  "\/Date(1415920126010)\/",

  "ModifiedBy":  "SERVER1\\Administrator",

  "Modified":  "\/Date(1415920126010)\/",

  "RowVersion":  [

    0,

    0,

    0,

    0,

    0,

    2,

    152,

    17

    ]

}

Update an existing K/N/V with new key and new value. Return format is json with pretty-print.

.LINK

Online Version: http://dfch.biz/biz/dfch/PS/Appclusive/Client/Set-KeyNameValue/

.NOTES

See module manifest for dependencies and further requirements.

#>

[CmdletBinding(

    SupportsShouldProcess = $false

    ,

    ConfirmImpact = 'Low'

    ,

    HelpURI = 'http://dfch.biz/biz/dfch/PS/Appclusive/Client/Set-KeyNameValue/'

)]

[Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseShouldProcessForStateChangingFunctions", "")]

Param 

(

    # Specifies the key to modify

    [Parameter(Mandatory = $true, Position = 0)]

    [Alias("k")]

    [string] $Key

    ,

    # Specifies the new key name

    [Parameter(Mandatory = $false)]

    [string] $NewKey

    ,

    # Specifies the name to modify

    [Parameter(Mandatory = $true, Position = 1)]

    [Alias('n')]

    [string] $Name

    ,

    # Specifies the new name name

    [Parameter(Mandatory = $false)]

    [string] $NewName

    ,

    # Specifies the value to modify

    [Parameter(Mandatory = $true, Position = 2)]

    [Alias("v")]

    [string] $Value

    ,

    # Specifies the new value name to modify

    [Parameter(Mandatory = $false)]

    [string] $NewValue

    ,

    # Specifies the description

    [Parameter(Mandatory = $false)]

    [string] $Description

    ,

    # Specifies to create a KNV if it does not exist

    [Parameter(Mandatory = $false)]

    [Alias("c")]

    [switch] $CreateIfNotExist = $false

    ,

    # Service reference to Appclusive

    [Parameter(Mandatory = $false)]

    [Alias('Services')]

    [hashtable] $svc = (Get-Variable -Name $MyInvocation.MyCommand.Module.PrivateData.MODULEVAR -ValueOnly).Services

    ,

    # Specifies the return format of the Cmdlet

    [ValidateSet('default', 'json', 'json-pretty', 'xml', 'xml-pretty')]

    [Parameter(Mandatory = $false)]

    [alias('ReturnFormat')]

    [string] $As = 'default'

)

Begin 

{

    trap { Log-Exception $_; break; }

    $datBegin = [datetime]::Now;

    [string] $fn = $MyInvocation.MyCommand.Name;

    Log-Debug -fn $fn -msg ("CALL. svc '{0}'. Name '{1}'." -f ($svc -is [Object]), $Name) -fac 1;

    $MaxPropertyLength = 475;

    # Parameter validation

    Contract-Requires ($svc.Core -is [biz.dfch.CS.Appclusive.Api.Core.Core]) "Connect to the server before using the Cmdlet"

}

# Begin

Process 

{

# Default test variable for checking function response codes.

[Boolean] $fReturn = $false;

# Return values are always and only returned via OutputParameter.

$OutputParameter = $null;

$AddedEntity = $null;

try 

{

    $Exp = @();

    $KeyNameValueContents = @();

    if($Key.Length -lt $MaxPropertyLength) 

    { 

        $Exp += ("(tolower(Key) eq '{0}')" -f $Key.ToLower());

        $KeyNameValueContents += $Key;

    }

    else

    {

        $shortenedKey = $Key.substring(0,$MaxPropertyLength);

        $Exp += ("(startswith(tolower(Key), '{0}'))" -f $shortenedKey.ToLower());

        $KeyNameValueContents += $Key;

    }

    if($Name.Length -lt $MaxPropertyLength) 

    { 

        $Exp += ("(tolower(Name) eq '{0}')" -f $Name.ToLower());

        $KeyNameValueContents += $Name;

    }

    else

    {

        $shortenedName = $Name.substring(0,$MaxPropertyLength);

        $Exp += ("(startswith(tolower(Name), '{0}'))" -f $shortenedName.ToLower());

        $KeyNameValueContents += $Name;

    }

    if($Value.Length -lt $MaxPropertyLength) 

    { 

        $Exp += ("(tolower(Value) eq '{0}')" -f $Value.ToLower());

        $KeyNameValueContents += $Value;

    }

    else

    {

        $shortenedValue = $Value.substring(0,$MaxPropertyLength);

        $Exp += ("(startswith(tolower(Value), '{0}'))" -f $shortenedValue.ToLower());

        $KeyNameValueContents += $Value;

    }

    $FilterExpression = [String]::Join(' and ', $Exp);

    $KeyNameValueContentsString = [String]::Join(',', $KeyNameValueContents);

    try

    {

        $knv = $svc.Core.KeyNameValues.AddQueryOption('$filter', $FilterExpression).AddQueryOption('$top',1) | Select;

    }

    catch

    {

        $exceptionMsg = $error[0].Exception.InnerException.InnerException.ToString();

        if (!!$exceptionMsg -and $exceptionMsg -match "Http Error 404\.15 - Not Found")

        {

            $queryStringLength = $FilterExpression.Length + '$filter='.Length;

            $msg = "Key/Name/Value: Filter expression to query for existing entity exceeds maxQueryString (Length: '{0}'). To avoid this exception increase the maximum URL length on the IIS server." -f $queryStringLength;

            $e = New-CustomErrorRecord -m $msg -cat LimitsExceeded -o "maxQueryString";

            throw($gotoError);

        }

        throw;

    }

    if(!$CreateIfNotExist -And !$knv) 

    {

        $msg = "Key/Name/Value: Parameter validation FAILED. Entity does not exist. Use '-CreateIfNotExist' to create resource: '{0}'" -f $KeyNameValueContentsString;

        $e = New-CustomErrorRecord -m $msg -cat ObjectNotFound -o $Name;

        throw($gotoError);

    }

    if(!$knv) 

    {

        $knv = New-Object biz.dfch.CS.Appclusive.Api.Core.KeyNameValue;

        $knv.Key = $Key;

        $knv.Name = $Name;

        $knv.Value = $Value;

        $svc.Core.AddToKeyNameValues($knv);

        $AddedEntity = $knv;

        $knv.Created = [System.DateTimeOffset]::Now;

        $knv.Modified = $knv.Created;

        $knv.CreatedById = 0;

        $knv.ModifiedById = 0;

        $knv.Tid = [guid]::Empty.ToString();

    }

    if($NewKey) { $knv.Key = $NewKey; }

    if($NewName) { $knv.Name = $NewName; }

    if($NewValue) { $knv.Value = $NewValue; }

    if($PSBoundParameters.ContainsKey('Description'))

    {

        $knv.Description = $Description;

    }

    $svc.Core.UpdateObject($knv);

    $r = $svc.Core.SaveChanges();

    $r = $knv;

    $OutputParameter = Format-ResultAs $r $As;

    $fReturn = $true;

}

catch 

{

    if($gotoSuccess -eq $_.Exception.Message) 

    {

        $fReturn = $true;

    } 

    else 

    {

        [string] $ErrorText = "catch [$($_.FullyQualifiedErrorId)]";

        $ErrorText += (($_ | fl * -Force) | Out-String);

        $ErrorText += (($_.Exception | fl * -Force) | Out-String);

        $ErrorText += (Get-PSCallStack | Out-String);

        if($_.Exception -is [System.Net.WebException]) 

        {

            Log-Critical $fn ("[WebException] Request FAILED with Status '{0}'. [{1}]." -f $_.Exception.Status, $_);

            Log-Debug $fn $ErrorText -fac 3;

        }

        else 

        {

            Log-Error $fn $ErrorText -fac 3;

            if($gotoError -eq $_.Exception.Message) 

            {

                Log-Error $fn $e.Exception.Message;

                $PSCmdlet.ThrowTerminatingError($e);

            } 

            elseif($gotoFailure -ne $_.Exception.Message) 

            { 

                Write-Verbose ("$fn`n$ErrorText"); 

            } 

            else 

            {

                # N/A

            }

        }

        $fReturn = $false;

        $OutputParameter = $null;

        if($AddedEntity) 

        { 

            $svc.Core.DeleteObject($AddedEntity); 

        }

    }

}

finally 

{

    # Clean up

    # N/A

}

}

# Process

End 

{

$datEnd = [datetime]::Now;

Log-Debug -fn $fn -msg ("RET. fReturn: [{0}]. Execution time: [{1}]ms. Started: [{2}]." -f $fReturn, ($datEnd - $datBegin).TotalMilliseconds, $datBegin.ToString('yyyy-MM-dd HH:mm:ss.fffzzz')) -fac 2;

# Return values are always and only returned via OutputParameter.

return $OutputParameter;

}

# End

}

if($MyInvocation.ScriptName) { Export-ModuleMember -Function Set-KeyNameValue; } 

# 

# Copyright 2014-2015 d-fens GmbH

# 

# Licensed under the Apache License, Version 2.0 (the "License");

# you may not use this file except in compliance with the License.

# You may obtain a copy of the License at

# 

# http://www.apache.org/licenses/LICENSE-2.0

# 

# Unless required by applicable law or agreed to in writing, software

# distributed under the License is distributed on an "AS IS" BASIS,

# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

# See the License for the specific language governing permissions and

# limitations under the License.

# 

# SIG # Begin signature block

# MIIXDwYJKoZIhvcNAQcCoIIXADCCFvwCAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUyHKwACLh1wptrQrifNqcsn2Q

# CAegghHCMIIEFDCCAvygAwIBAgILBAAAAAABL07hUtcwDQYJKoZIhvcNAQEFBQAw

# VzELMAkGA1UEBhMCQkUxGTAXBgNVBAoTEEdsb2JhbFNpZ24gbnYtc2ExEDAOBgNV

# BAsTB1Jvb3QgQ0ExGzAZBgNVBAMTEkdsb2JhbFNpZ24gUm9vdCBDQTAeFw0xMTA0

# MTMxMDAwMDBaFw0yODAxMjgxMjAwMDBaMFIxCzAJBgNVBAYTAkJFMRkwFwYDVQQK

# ExBHbG9iYWxTaWduIG52LXNhMSgwJgYDVQQDEx9HbG9iYWxTaWduIFRpbWVzdGFt

# cGluZyBDQSAtIEcyMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAlO9l

# +LVXn6BTDTQG6wkft0cYasvwW+T/J6U00feJGr+esc0SQW5m1IGghYtkWkYvmaCN

# d7HivFzdItdqZ9C76Mp03otPDbBS5ZBb60cO8eefnAuQZT4XljBFcm05oRc2yrmg

# jBtPCBn2gTGtYRakYua0QJ7D/PuV9vu1LpWBmODvxevYAll4d/eq41JrUJEpxfz3

# zZNl0mBhIvIG+zLdFlH6Dv2KMPAXCae78wSuq5DnbN96qfTvxGInX2+ZbTh0qhGL

# 2t/HFEzphbLswn1KJo/nVrqm4M+SU4B09APsaLJgvIQgAIMboe60dAXBKY5i0Eex

# +vBTzBj5Ljv5cH60JQIDAQABo4HlMIHiMA4GA1UdDwEB/wQEAwIBBjASBgNVHRMB

# Af8ECDAGAQH/AgEAMB0GA1UdDgQWBBRG2D7/3OO+/4Pm9IWbsN1q1hSpwTBHBgNV

# HSAEQDA+MDwGBFUdIAAwNDAyBggrBgEFBQcCARYmaHR0cHM6Ly93d3cuZ2xvYmFs

# c2lnbi5jb20vcmVwb3NpdG9yeS8wMwYDVR0fBCwwKjAooCagJIYiaHR0cDovL2Ny

# bC5nbG9iYWxzaWduLm5ldC9yb290LmNybDAfBgNVHSMEGDAWgBRge2YaRQ2XyolQ

# L30EzTSo//z9SzANBgkqhkiG9w0BAQUFAAOCAQEATl5WkB5GtNlJMfO7FzkoG8IW

# 3f1B3AkFBJtvsqKa1pkuQJkAVbXqP6UgdtOGNNQXzFU6x4Lu76i6vNgGnxVQ380W

# e1I6AtcZGv2v8Hhc4EvFGN86JB7arLipWAQCBzDbsBJe/jG+8ARI9PBw+DpeVoPP

# PfsNvPTF7ZedudTbpSeE4zibi6c1hkQgpDttpGoLoYP9KOva7yj2zIhd+wo7AKvg

# IeviLzVsD440RZfroveZMzV+y5qKu0VN5z+fwtmK+mWybsd+Zf/okuEsMaL3sCc2

# SI8mbzvuTXYfecPlf5Y1vC0OzAGwjn//UYCAp5LUs0RGZIyHTxZjBzFLY7Df8zCC

# BCkwggMRoAMCAQICCwQAAAAAATGJxjfoMA0GCSqGSIb3DQEBCwUAMEwxIDAeBgNV

# BAsTF0dsb2JhbFNpZ24gUm9vdCBDQSAtIFIzMRMwEQYDVQQKEwpHbG9iYWxTaWdu

# MRMwEQYDVQQDEwpHbG9iYWxTaWduMB4XDTExMDgwMjEwMDAwMFoXDTE5MDgwMjEw

# MDAwMFowWjELMAkGA1UEBhMCQkUxGTAXBgNVBAoTEEdsb2JhbFNpZ24gbnYtc2Ex

# MDAuBgNVBAMTJ0dsb2JhbFNpZ24gQ29kZVNpZ25pbmcgQ0EgLSBTSEEyNTYgLSBH

# MjCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAKPv0Z8p6djTgnY8YqDS

# SdYWHvHP8NC6SEMDLacd8gE0SaQQ6WIT9BP0FoO11VdCSIYrlViH6igEdMtyEQ9h

# JuH6HGEVxyibTQuCDyYrkDqW7aTQaymc9WGI5qRXb+70cNCNF97mZnZfdB5eDFM4

# XZD03zAtGxPReZhUGks4BPQHxCMD05LL94BdqpxWBkQtQUxItC3sNZKaxpXX9c6Q

# MeJ2s2G48XVXQqw7zivIkEnotybPuwyJy9DDo2qhydXjnFMrVyb+Vpp2/WFGomDs

# KUZH8s3ggmLGBFrn7U5AXEgGfZ1f53TJnoRlDVve3NMkHLQUEeurv8QfpLqZ0BdY

# Nc0CAwEAAaOB/TCB+jAOBgNVHQ8BAf8EBAMCAQYwEgYDVR0TAQH/BAgwBgEB/wIB

# ADAdBgNVHQ4EFgQUGUq4WuRNMaUU5V7sL6Mc+oCMMmswRwYDVR0gBEAwPjA8BgRV

# HSAAMDQwMgYIKwYBBQUHAgEWJmh0dHBzOi8vd3d3Lmdsb2JhbHNpZ24uY29tL3Jl

# cG9zaXRvcnkvMDYGA1UdHwQvMC0wK6ApoCeGJWh0dHA6Ly9jcmwuZ2xvYmFsc2ln

# bi5uZXQvcm9vdC1yMy5jcmwwEwYDVR0lBAwwCgYIKwYBBQUHAwMwHwYDVR0jBBgw

# FoAUj/BLf6guRSSuTVD6Y5qL3uLdG7wwDQYJKoZIhvcNAQELBQADggEBAHmwaTTi

# BYf2/tRgLC+GeTQD4LEHkwyEXPnk3GzPbrXsCly6C9BoMS4/ZL0Pgmtmd4F/ximl

# F9jwiU2DJBH2bv6d4UgKKKDieySApOzCmgDXsG1szYjVFXjPE/mIpXNNwTYr3MvO

# 23580ovvL72zT006rbtibiiTxAzL2ebK4BEClAOwvT+UKFaQHlPCJ9XJPM0aYx6C

# WRW2QMqngarDVa8z0bV16AnqRwhIIvtdG/Mseml+xddaXlYzPK1X6JMlQsPSXnE7

# ShxU7alVrCgFx8RsXdw8k/ZpPIJRzhoVPV4Bc/9Aouq0rtOO+u5dbEfHQfXUVlfy

# GDcy1tTMS/Zx4HYwggSfMIIDh6ADAgECAhIRIdaZp2SXPvH4Qn7pGcxTQRQwDQYJ

# KoZIhvcNAQEFBQAwUjELMAkGA1UEBhMCQkUxGTAXBgNVBAoTEEdsb2JhbFNpZ24g

# bnYtc2ExKDAmBgNVBAMTH0dsb2JhbFNpZ24gVGltZXN0YW1waW5nIENBIC0gRzIw

# HhcNMTYwNTI0MDAwMDAwWhcNMjcwNjI0MDAwMDAwWjBgMQswCQYDVQQGEwJTRzEf

# MB0GA1UEChMWR01PIEdsb2JhbFNpZ24gUHRlIEx0ZDEwMC4GA1UEAxMnR2xvYmFs

# U2lnbiBUU0EgZm9yIE1TIEF1dGhlbnRpY29kZSAtIEcyMIIBIjANBgkqhkiG9w0B

# AQEFAAOCAQ8AMIIBCgKCAQEAsBeuotO2BDBWHlgPse1VpNZUy9j2czrsXV6rJf02

# pfqEw2FAxUa1WVI7QqIuXxNiEKlb5nPWkiWxfSPjBrOHOg5D8NcAiVOiETFSKG5d

# QHI88gl3p0mSl9RskKB2p/243LOd8gdgLE9YmABr0xVU4Prd/4AsXximmP/Uq+yh

# RVmyLm9iXeDZGayLV5yoJivZF6UQ0kcIGnAsM4t/aIAqtaFda92NAgIpA6p8N7u7

# KU49U5OzpvqP0liTFUy5LauAo6Ml+6/3CGSwekQPXBDXX2E3qk5r09JTJZ2Cc/os

# +XKwqRk5KlD6qdA8OsroW+/1X1H0+QrZlzXeaoXmIwRCrwIDAQABo4IBXzCCAVsw

# DgYDVR0PAQH/BAQDAgeAMEwGA1UdIARFMEMwQQYJKwYBBAGgMgEeMDQwMgYIKwYB

# BQUHAgEWJmh0dHBzOi8vd3d3Lmdsb2JhbHNpZ24uY29tL3JlcG9zaXRvcnkvMAkG

# A1UdEwQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUHAwgwQgYDVR0fBDswOTA3oDWg

# M4YxaHR0cDovL2NybC5nbG9iYWxzaWduLmNvbS9ncy9nc3RpbWVzdGFtcGluZ2cy

# LmNybDBUBggrBgEFBQcBAQRIMEYwRAYIKwYBBQUHMAKGOGh0dHA6Ly9zZWN1cmUu

# Z2xvYmFsc2lnbi5jb20vY2FjZXJ0L2dzdGltZXN0YW1waW5nZzIuY3J0MB0GA1Ud

# DgQWBBTUooRKOFoYf7pPMFC9ndV6h9YJ9zAfBgNVHSMEGDAWgBRG2D7/3OO+/4Pm

# 9IWbsN1q1hSpwTANBgkqhkiG9w0BAQUFAAOCAQEAj6kakW0EpjcgDoOW3iPTa24f

# bt1kPWghIrX4RzZpjuGlRcckoiK3KQnMVFquxrzNY46zPVBI5bTMrs2SjZ4oixNK

# Eaq9o+/Tsjb8tKFyv22XY3mMRLxwL37zvN2CU6sa9uv6HJe8tjecpBwwvKu8LUc2

# 35IgA+hxxlj2dQWaNPALWVqCRDSqgOQvhPZHXZbJtsrKnbemuuRQ09Q3uLogDtDT

# kipbxFm7oW3bPM5EncE4Kq3jjb3NCXcaEL5nCgI2ZIi5sxsm7ueeYMRGqLxhM2zP

# TrmcuWrwnzf+tT1PmtNN/94gjk6Xpv2fCbxNyhh2ybBNhVDygNIdBvVYBAexGDCC

# BNYwggO+oAMCAQICEhEhDRayW4wRltP+V8mGEea62TANBgkqhkiG9w0BAQsFADBa

# MQswCQYDVQQGEwJCRTEZMBcGA1UEChMQR2xvYmFsU2lnbiBudi1zYTEwMC4GA1UE

# AxMnR2xvYmFsU2lnbiBDb2RlU2lnbmluZyBDQSAtIFNIQTI1NiAtIEcyMB4XDTE1

# MDUwNDE2NDMyMVoXDTE4MDUwNDE2NDMyMVowVTELMAkGA1UEBhMCQ0gxDDAKBgNV

# BAgTA1p1ZzEMMAoGA1UEBxMDWnVnMRQwEgYDVQQKEwtkLWZlbnMgR21iSDEUMBIG

# A1UEAxMLZC1mZW5zIEdtYkgwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDNPSzSNPylU9jFM78Q/GjzB7N+VNqikf/use7p8mpnBZ4cf5b4qV3rqQd62rJH

# RlAsxgouCSNQrl8xxfg6/t/I02kPvrzsR4xnDgMiVCqVRAeQsWebafWdTvWmONBS

# lxJejPP8TSgXMKFaDa+2HleTycTBYSoErAZSWpQ0NqF9zBadjsJRVatQuPkTDrwL

# eWibiyOipK9fcNoQpl5ll5H9EG668YJR3fqX9o0TQTkOmxXIL3IJ0UxdpyDpLEkt

# tBG6Y5wAdpF2dQX2phrfFNVY54JOGtuBkNGMSiLFzTkBA1fOlA6ICMYjB8xIFxVv

# rN1tYojCrqYkKMOjwWQz5X8zAgMBAAGjggGZMIIBlTAOBgNVHQ8BAf8EBAMCB4Aw

# TAYDVR0gBEUwQzBBBgkrBgEEAaAyATIwNDAyBggrBgEFBQcCARYmaHR0cHM6Ly93

# d3cuZ2xvYmFsc2lnbi5jb20vcmVwb3NpdG9yeS8wCQYDVR0TBAIwADATBgNVHSUE

# DDAKBggrBgEFBQcDAzBCBgNVHR8EOzA5MDegNaAzhjFodHRwOi8vY3JsLmdsb2Jh

# bHNpZ24uY29tL2dzL2dzY29kZXNpZ25zaGEyZzIuY3JsMIGQBggrBgEFBQcBAQSB

# gzCBgDBEBggrBgEFBQcwAoY4aHR0cDovL3NlY3VyZS5nbG9iYWxzaWduLmNvbS9j

# YWNlcnQvZ3Njb2Rlc2lnbnNoYTJnMi5jcnQwOAYIKwYBBQUHMAGGLGh0dHA6Ly9v

# Y3NwMi5nbG9iYWxzaWduLmNvbS9nc2NvZGVzaWduc2hhMmcyMB0GA1UdDgQWBBTN

# GDddiIYZy9p3Z84iSIMd27rtUDAfBgNVHSMEGDAWgBQZSrha5E0xpRTlXuwvoxz6

# gIwyazANBgkqhkiG9w0BAQsFAAOCAQEAAApsOzSX1alF00fTeijB/aIthO3UB0ks

# 1Gg3xoKQC1iEQmFG/qlFLiufs52kRPN7L0a7ClNH3iQpaH5IEaUENT9cNEXdKTBG

# 8OrJS8lrDJXImgNEgtSwz0B40h7bM2Z+0DvXDvpmfyM2NwHF/nNVj7NzmczrLRqN

# 9de3tV0pgRqnIYordVcmb24CZl3bzpwzbQQy14Iz+P5Z2cnw+QaYzAuweTZxEUcJ

# bFwpM49c1LMPFJTuOKkUgY90JJ3gVTpyQxfkc7DNBnx74PlRzjFmeGC/hxQt0hvo

# eaAiBdjo/1uuCTToigVnyRH+c0T2AezTeoFb7ne3I538hWeTdU5q9jGCBLcwggSz

# AgEBMHAwWjELMAkGA1UEBhMCQkUxGTAXBgNVBAoTEEdsb2JhbFNpZ24gbnYtc2Ex

# MDAuBgNVBAMTJ0dsb2JhbFNpZ24gQ29kZVNpZ25pbmcgQ0EgLSBTSEEyNTYgLSBH

# MgISESENFrJbjBGW0/5XyYYR5rrZMAkGBSsOAwIaBQCgeDAYBgorBgEEAYI3AgEM

# MQowCKACgAChAoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3AgEEMBwGCisGAQQB

# gjcCAQsxDjAMBgorBgEEAYI3AgEVMCMGCSqGSIb3DQEJBDEWBBSvUp0C5elo01ix

# 56a9SuZIWPGaJzANBgkqhkiG9w0BAQEFAASCAQBqdnlOE96ymaW2iTYbTyu0dKWK

# zKDpEcU2or92GwSz3qGGUaq0kDVciV7Cb53ynaZ6N3cboSQGm92s8vufUX5vUXbo

# E/tXtEkKhNUCqqhoDMxtyojQSH20XiSHyZlNdlfqZJxz120uHyqX/Au3Xq+kRPk2

# A5zJ1rS4m2DisBTvMPIJh3XZn1+WonYWtOF5qSt/HeTd84zKeozYMx5QNBXBDpWk

# H5NdTJU2jPyKQIt4Beuktas2hndWxKHVOFTAfPb6/X7RbA4ux6cFqn3XNTbLpMMi

# v4ViQnOh02se9Ktmf2VmQw0PAn4smqnhTASsjPXI7/3mYFVwIftLLjWgmMtzoYIC

# ojCCAp4GCSqGSIb3DQEJBjGCAo8wggKLAgEBMGgwUjELMAkGA1UEBhMCQkUxGTAX

# BgNVBAoTEEdsb2JhbFNpZ24gbnYtc2ExKDAmBgNVBAMTH0dsb2JhbFNpZ24gVGlt

# ZXN0YW1waW5nIENBIC0gRzICEhEh1pmnZJc+8fhCfukZzFNBFDAJBgUrDgMCGgUA

# oIH9MBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTE2

# MDgzMTE5MTcwNVowIwYJKoZIhvcNAQkEMRYEFBkagLxArWwX7jG+uTx9iNi4QAw+

# MIGdBgsqhkiG9w0BCRACDDGBjTCBijCBhzCBhAQUY7gvq2H1g5CWlQULACScUCkz

# 7HkwbDBWpFQwUjELMAkGA1UEBhMCQkUxGTAXBgNVBAoTEEdsb2JhbFNpZ24gbnYt

# c2ExKDAmBgNVBAMTH0dsb2JhbFNpZ24gVGltZXN0YW1waW5nIENBIC0gRzICEhEh

# 1pmnZJc+8fhCfukZzFNBFDANBgkqhkiG9w0BAQEFAASCAQBfTkiYRS/AfgrjwfuO

# 651Ts1c1QSODayABW61V8w3jjIUQjNwSG6G2AIWMPHsGggV4qRoA4k6MzyZpuJ88

# AzcDyAgYMvLwygBhdxYa2/aHvp7oamv3GnnKzcnKdUr0iLwIh3wA9J3hk82tFktf

# SGxQreSFesGiJhwUyXaPY9b5UMRULAkEynWQqPJzDyZ0hKQunxE2aYWf0K1lXF3Z

# ZUlTdeHIX8IfXBmUv9Gt60h2alfL+kTb9zvUKrRdEsNKNOUFR0B7v69Q5ekgcGJP

# vHuTj4nfDGqs55IOTQG/bnajmkceZ9GxIWI3YMSOVMWPC75S99+OZRueFo5lS/MA

# QMLr

# SIG # End signature block