vexx32

function Invoke-SqlSelect {
    <#
        .DESCRIPTION
        This is a re-usable function that makes a connection to the database and retrieves a result set.
    #>
    [CmdletBinding()]
    param(
        [Parameter(Mandatory, Position = 0)]
        [string]
        $Command,

vexx32

namespace PSFSharp
open System.Management.Automation
open System.Management.Automation.Internal

[<Cmdlet(VerbsLifecycle.Invoke, "ConditionalAction",
    ConfirmImpact = ConfirmImpact.Medium, SupportsShouldProcess = true)>]
[<Alias("?!")>]
type InvokeConditionalActionCommand() =
    inherit PSCmdlet()

vexx32

Get-Content -Path $File | ForEach-Object {
    if ($_ -match '(?<MethodName>\w+)\((<Arguments>.*?)\) *(?={)') {
        $matches['Method'] = $matches[0]
        $matches.Remove(0)
        [PSCustomObject]$matches
    }
}

vexx32

function prompt {
    $Success = $?
    $ConsoleWidth = ($host.UI.RawUI.WindowSize.Width, $Host.UI.RawUI.BufferSize.Width -gt 0)[0]
    $Escape = "`e["
    $EndEscape = "m"

    $Slash = [IO.Path]::DirectorySeparatorChar
    $Path = $ExecutionContext.SessionState.Path.CurrentLocation
    $CurrentFolder = Split-Path -Path $Path -Leaf
    $Host.UI.RawUI.WindowTitle = "PS $Path"

vexx32

$string = 'hostname.database.table.schema'

if ($string -match '(?<Hostname>\w+)\.(?<Database>\w+)\.(?<Table>\w+)\.(?<Schema>\w+)') {
    $matches.Remove(0)
    [PSCustomObject]$matches
}

vexx32

internal static float GetEnclosedArea(this SKPath path)
{
    SKRect bounds = path.TightBounds;
    var boundedArea = bounds.Width * bounds.Height;
    var totalPoints = 10000;
    var enclosedPoints = 0;

    for (float x = bounds.Left; x < bounds.Right; x += bounds.Width / (float)Math.Sqrt(totalPoints))
    {
        for (float y = bounds.Top; y < bounds.Bottom; y += bounds.Height / (float)Math.Sqrt(totalPoints))

vexx32

// Generic this --> multiple type handling

internal static bool TryConvertSByte(double value, out sbyte outValue)
{
    if (value < sbyte.MinValue || value > sbyte.MaxValue)
    {
        outValue = 0;
        return false;
    }

vexx32

$Module = New-Module -Name 'ImportMe' -ScriptBlock {
    class TryMeException : System.Exception {
        TryMeException() : base() {}
        TryMeException([string]$Message) : base($Message) {}
    }
    $onremove = {
        throw [TryMeException]::new("HOW DARE YOU STEAL THAT CAR")
    }
    $ExecutionContext.SessionState.Module.OnRemove += $onremove
}

vexx32

function New-Shortcut {
    [CmdletBinding()]
    Param(
        [Parameter(Mandatory)]
        [ValidateScript({ Test-Path -IsValid $_ })]
        [string]$Path, 
        
        [Parameter(Mandatory, ValueFromPipeline)]
        [ValidateScript({ Test-Path $_ })]
        [string]$Target, 

vexx32

$Properties = 'GivenName', 'Surname', 'Department', 'EmailAddress', 'Office'
Get-ADUser -Filter 'Department -like "*"' -Properties $Properties |
    Select-Object -Property $Properties |
    ConvertTo-Csv -NoTypeInformation | # Convert to CSV string data without the type metadata
    Select-Object -Skip 1 | # Trim header row, leaving only data columns
    Set-Content -Path "c:\emailaddress.csv"