UblionConnect

1.0.148

Public/ps1/UblionConfiguration.ps1

function Validate-Configuration {
    $testSql = "Server=10.21.0.199\\LEFTPRD14;Database=AxillaApprx;Integrated Security=False;Persist Security Info=True;User ID=axillaApprx;Password=dUj0RyWL2D71;MultipleActiveResultSets=True"

}

function Install-LeftConnectRemoteControllerSQL
{    
    [CmdletBinding()]
    param(
        [Parameter(Mandatory)]
        [String]$Tenant,
        
        [System.Management.Automation.PSCredential]
        $Credential = $(Get-Credential),

        [Parameter(Mandatory)]
        [String]$SqlConnectionString,

        [String]$channelId,
        [String] $LogFolder

    )
        
    
    Set-ConfigurationValue -name SqlConnectionString -value $SqlConnectionString -secure

    Install-LeftConnectionBase -Tenant $Tenant -Credential $Credential -LogFolder $LogFolder

    Log("LeftConnect + SQL installed")
}


### Storing the remote connection credentials on a save way
function Install-LeftConnectionBase{
    param(
        [Parameter(Mandatory)]
        [String]$Tenant,
                
        $Credential,
        [String] $LogFolder,
        [int] $LogHours,
        [int] $LogRetention
    )
    
    
    Set-ConfigurationValue -name UserName -value $Credential.UserName
    Set-ConfigurationValue -name Tenant -value $Tenant
    Set-ConfigurationValue -name Password -value ($Credential.Password | ConvertFrom-SecureString)

    Set-LogConfiguration -LogFilder $LogFolder -LogHours $LogHours -LogRetention $LogRetention


}



function Set-ConfigurationValue{
    param($name, $value, [switch]$secure)

    
    $folder = Get-LeftConnectConfigurationFolder


    if ($secure) {
        $value = ConvertTo-SecureString -Force -AsPlainText $value | ConvertFrom-SecureString 
    }
    
    if (Test-Path "$folder\config.json") {
    } else {
        "{}"|set-content "$folder\config.json"
    }

    $config = Get-Content "$folder\config.json" | ConvertFrom-Json
    # the prpoerty does not exist
    if (($config.$name -ne $null)) {
        $config.$name = $value
    } else {
        $config | Add-Member -MemberType NoteProperty -Name $name -Value $value
    }


    $config | ConvertTo-Json | Set-Content "$folder\config.json" 

}

function Remove-ConfigurationValue{
    param($name)

    
    $folder = Get-LeftConnectConfigurationFolder


    
    if (Test-Path "$folder\config.json") {
    } else {
        "{}"|set-content "$folder\config.json"
    }

    $config = Get-Content "$folder\config.json" | ConvertFrom-Json
    # the prpoerty does not exist

    $config.PSObject.Properties.Remove($name)


    $config | ConvertTo-Json | Set-Content "$folder\config.json" 

}


function Get-ConfigurationValue{
    param($name,[switch]$secure, $defaultValue)

    
    $folder = Get-LeftConnectConfigurationFolder

       
    if (Test-Path "$folder\config.json") {
    } else {
        "{}"|set-content "$folder\config.json"
    }

    $config = Get-Content "$folder\config.json" | ConvertFrom-Json
    # the prpoerty does not exist
    if (($config.$name -ne $null)) {
        if ($secure) {
            
            $secureString = $config.$name | ConvertTo-SecureString
            $BSTR = [System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($secureString)
            [System.Runtime.InteropServices.Marshal]::PtrToStringAuto($BSTR)
        } else {
            $config.$name
        }
    } else {
        $defaultValue
    }
}

function Get-Configuration {
       
    $folder = Get-LeftConnectConfigurationFolder
    
    
    if (Test-Path "$folder\config.json") {
    } else {
        "{}"|set-content "$folder\config.json"
    }

    Get-Content "$folder\config.json" | ConvertFrom-Json
}


function Get-LeftConnectSqlConfiguration {
    
    @{
        connectionString = Get-ConfigurationValue -name SqlConnectionString -secure
    }
}

function Get-LeftConnectBaseConfiguration {
    @{
        user =     Get-ConfigurationValue -name UserName 
        pass =     Get-ConfigurationValue -name Password -secure 
        tenant =   Get-ConfigurationValue -name Tenant
    }
}

<#
.SYNOPSIS
Get the tenant url
 
.DESCRIPTION
Returns the url host
 
.EXAMPLE
An example
 
.NOTES
General notes
#>#
function Get-LeftConnectUrlHost {
    $tenant = (Get-LeftConnectBaseConfiguration).tenant

    if ($tenant -eq $null){
        throw "Tenant not specified."
    }
    if (-not $tenant.Contains("-connectapi")) {
        $tenant = $tenant -replace ".apprx.eu", "-connectapi.apprx.eu"
    }
    "https://$tenant/"
}



<#
.SYNOPSIS
Create an folder
 
.DESCRIPTION
Long description
 
.PARAMETER DirectoryToCreate
Parameter description
 
.EXAMPLE
An example
 
.NOTES
General notes
#>#
function Install-AppData{
    [CmdletBinding()]
    Param(
    [Parameter(Mandatory = $True)]
    [String] $DirectoryToCreate)

    if (-not (Test-Path -LiteralPath $DirectoryToCreate)) {
        
        try {
            New-Item -Path $DirectoryToCreate -ItemType Directory -ErrorAction Stop | Out-Null #-Force
        }
        catch {
            Write-Error -Message "Unable to create directory '$DirectoryToCreate'. Error was: $_" -ErrorAction Stop
        }
        Write-host "Successfully saved credentials"
        $DirectoryToCreate

    }
    else {
        Write-host "Directory already existed"
        $DirectoryToCreate
    }
}

function Get-LeftConnectConfigurationFolder{
    $folder = $env:LOCALAPPDATA + "\LeftConnect"
    
    if( -not (Test-path $folder)){
      Install-AppData -DirectoryToCreate $folder -ErrorAction Ignore
    }
    $folder
}







Export-ModuleMember -function  Install-LeftConnectRemoteControllerSQL


Export-ModuleMember -function  Install-LeftConnectionBase


Export-ModuleMember -function  Set-ConfigurationValue


Export-ModuleMember -function  Remove-ConfigurationValue


Export-ModuleMember -function  Get-ConfigurationValue


Export-ModuleMember -function  Get-Configuration


Export-ModuleMember -function  Get-LeftConnectSqlConfiguration


Export-ModuleMember -function  Get-LeftConnectBaseConfiguration


Export-ModuleMember -function  Get-LeftConnectUrlHost


Export-ModuleMember -function  Install-AppData


Export-ModuleMember -function  Get-LeftConnectConfigurationFolder