Remove-WEMStorefrontSetting.ps1

<#
    .Synopsis
    Removes a Storefront Setting object from the WEM Database.

    .Description
    Removes a Storefront Setting object from the WEM Database.

    .Link
    https://msfreaks.wordpress.com

    .Parameter IdStorefrontSetting
    ..

    .Parameter Connection
    ..
    
    .Example

    .Notes
    Author: Arjan Mensch
#>
function Remove-WEMStorefrontSetting {
    [CmdletBinding()]
    param (
        [Parameter(Mandatory=$True, ValueFromPipelineByPropertyName=$True)]
        [int]$IdStorefrontSetting,

        [Parameter(Mandatory=$True)]
        [System.Data.SqlClient.SqlConnection]$Connection
    )

    process {
        Write-Verbose "Working with database version $($script:databaseVersion)"

        # grab original object
        $origObject = Get-WEMStorefrontSetting -Connection $Connection -IdStorefrontSetting $IdStorefrontSetting

        # only continue if the action was found
        if (-not $origObject) { 
            Write-Warning "No Storefront Setting Object found for Id $($IdStorefrontSetting)"
            Return
        }
        
        # build query
        $SQLQuery = "DELETE FROM VUEMStorefrontSettings WHERE IdItem = $($IdStorefrontSetting)"
        $null = Invoke-SQL -Connection $Connection -Query $SQLQuery

        # BUG IN THIS FUNCTIONALITY!
        # ChangeLog DOES not get updated when you enter a Storefront Settings object in the WEM Administration Console
        # Updating the ChangeLog
        New-ChangesLogEntry -Connection $Connection -IdSite $origObject.IdSite -IdElement $IdStorefrontSetting -ChangeType "Delete" -ObjectName $IdStorefrontSetting -ObjectType "Unknown Object" -NewValue "N/A" -ChangeDescription $null -Reserved01 $null
    }
}