Public/Install-SifPreReqs.ps1

#Requires -RunAsAdministrator

Function Install-SifPreReqs {
    [CmdletBinding(SupportsShouldProcess = $true)]
    param(
    )


    $nugetPackageProvider = Get-PackageProvider -Name NuGet -Force -Verbose -ErrorAction Stop
    if (!$nugetPackageProvider) {
        Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force -Confirm:$false -Verbose
    }

    # TODO remove the module imports for PKI and WebAdministration.. should be done in module .PSD1
    if (!(Get-Module PKI)) { Import-Module PKI -ErrorAction Stop -Verbose }

    if (!(Get-Module WebAdministration) -or (!(Get-PSDrive IIS -ErrorAction SilentlyContinue -Verbose))) {
        Get-Module WebAdministration | Remove-Module -Force -Confirm:$false
        Import-Module WebAdministration -ErrorAction Stop -Force -Verbose
    }

    $SitecoreGalleryUrl = "https://sitecore.myget.org/F/sc-powershell/api/v2"

    if (-not(Get-PSRepository -name SitecoreGallery)) {
        Register-PSRepository -Name SitecoreGallery -SourceLocation $SitecoreGalleryUrl -InstallationPolicy Trusted -Verbose
    }

    ("SitecoreInstallFramework", "SqlServer") | ForEach-Object -Verbose {

        if ((Get-InstalledModule -Name $_ -Verbose -ErrorAction SilentlyContinue)) {
            Update-Module $_ -Confirm:$false -Verbose
        }
        else {
            Install-Module $_ -Confirm:$false -AllowClobber -SkipPublisherCheck -Force -Verbose
        }

        if (!(Get-Module $_)) {
            Write-Warning "Module '$_' is not loaded!"
            Import-Module $_ -Force -Verbose
        }
    }

    $dacFxBinPath = $null

    function Get-DacFxPath {

        $dacFxBinPath =  $null


        $sqlPackagePath = Get-SQLPackagePath -ErrorAction SilentlyContinue

        if ($sqlPackagePath) {
            $dacFxBinPath = Split-Path -Path $sqlPackagePath -Parent
        }

        return $dacFxBinPath
    }

    $dacFxBinPath = Get-DacFxPath
    Write-Verbose "dacFxBinPath: $dacFxBinPath"

    function Install-DacFx {

        Write-Verbose "Installing DacFx 17.3"

        function silentInstallMsi {
            param (
                [ValidateScript( { Test-Path $_ -IsValid })]
                [string]$path
            )
            $DataStamp = get-date -Format yyyyMMddTHHmmss
            $file = get-item $path
            $logFile = '{0}-{1}.log' -f $file.fullname, $DataStamp
            $MSIArguments = @(
                "/i"
                ('"{0}"' -f $file.fullname)
                "/qn"
                "/norestart"
                "/L*v"
                $logFile
            )
            Start-Process "msiexec.exe" -ArgumentList $MSIArguments -Wait -NoNewWindow
        }

        $sqlClrTypes = 'https://download.microsoft.com/download/C/0/2/C02DBE78-3265-4779-9AE1-634A4BF1CD6E/EN/SQL140/amd64/SQLSysClrTypes.msi'
        $sqlClrTypesFilename = Split-Path $sqlClrTypes -Leaf
        $sqlClrTypesTempFile = Join-Path $env:TEMP $sqlClrTypesFilename

        $dacFx173 = 'https://download.microsoft.com/download/3/7/F/37F3C5CE-E96B-41AC-B361-27735365AA16/EN/x64/DacFramework.msi'
        $dacFx173Filename = Split-Path $dacFx173 -Leaf
        $dacFx173TempFile = Join-Path $env:TEMP $dacFx173Filename

        # Start-BitsTransfer -Source $sqlClrTypes, $dacFx173 -Destination $sqlClrTypesTempFile, $dacFx173TempFile
        $startTime = Get-Date

        try {
            Write-Verbose "Downloading $sqlClrTypes to $sqlClrTypesTempFile"

            Invoke-WebRequest -Uri $sqlClrTypes -OutFile $sqlClrTypesTempFile -UseBasicParsing
            $endTime = Get-Date
            $timeTaken = $endTime.Subtract($startTime)
            Write-Verbose "Time taken: $($timeTaken.TotalSeconds) seconds"
        }
        catch {
            Write-Error -Message ("Error downloading $sqlClrTypes" + ": $($_.Exception.Message)")
            throw
        }

        $startTime = Get-Date

        try {
            Write-Verbose "Downloading $dacFx173 to $dacFx173TempFile"

            Invoke-WebRequest -Uri $dacFx173 -OutFile $dacFx173TempFile -UseBasicParsing
            $endTime = Get-Date
            $timeTaken = $endTime.Subtract($startTime)
            Write-Verbose "Time taken: $($timeTaken.TotalSeconds) seconds"
        }
        catch {
            Write-Error -Message ("Error downloading $dacFx173" + ": $($_.Exception.Message)")
            throw
        }


        # install sql clr types
        silentInstallMsi -path $sqlClrTypesTempFile

        # install dac fx 17.3
        silentInstallMsi -path $dacFx173TempFile

        Write-Verbose "Completed DacFx 17.3 installation."
    }

    $dacVersion = $null

    if ($dacFxBinPath) {
        $dacFxPath = Split-Path $dacFxBinPath -Parent
        $dacVersionPath = Split-Path $dacFxPath -Parent
        $dacVersion = Split-Path $dacVersionPath -Leaf
    }

    if (!$dacVersion -or ($dacVersion -and $dacVersion -ne 140)) {

        Install-DacFx

    }

    $chocoInstallScript = (New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1')
    Set-ExecutionPolicy Bypass -Scope Process -Force
    Invoke-Expression $chocoInstallScript
    choco upgrade webdeploy -y -r

    $msDeployKeyName = 'HKLM:\SOFTWARE\Microsoft\IIS Extensions\MSDeploy\3'
    $msDeployKeyProperties = Get-ItemProperty -Path $msDeployKeyName -ErrorAction SilentlyContinue

    if ($msDeployKeyProperties) {

        $dacFxPathKeyProp = $msDeployKeyProperties | Select-Object -ExpandProperty DacFxPath -ErrorAction SilentlyContinue

        if (!$dacFxPathKeyProp) {
            New-ItemProperty -Path $msDeployKeyName -Name 'DacFxPath' -Value $dacFxBinPath -Force
        }
        else {
            Set-ItemProperty -Path $msDeployKeyName -Name 'DacFxPath' -Value $dacFxBinPath -Force
        }

        $dacFxDependenciesPathKeyProp = $msDeployKeyProperties | Select-Object -ExpandProperty DacFxDependenciesPath -ErrorAction SilentlyContinue

        if (!$dacFxDependenciesPathKeyProp) {
            New-ItemProperty -Path $msDeployKeyName -Name 'DacFxDependenciesPath' -Value $dacFxBinPath -Force
        }
        else {
            Set-ItemProperty -Path $msDeployKeyName -Name 'DacFxDependenciesPath' -Value $dacFxBinPath -Force
        }
    }
    else {
        Write-Warning 'Could not find MSDeploy in registry.'
    }

    choco upgrade urlrewrite -y -r

}