PesterCheck.ps1

# Validates the Sessionize schedule against the Speaker Requests

BeforeDiscovery {
    $file = 'PATH TO \SpeakerRequests.xlsx'
    $SpeakerRequests = Import-Excel -Path $file -WorksheetName SpeakerRequests

    $Schedule = Get-PSConfEUSchedule -Output object
    $plenarysessions = 'Registration', 'Quick Break', 'Closing Keynote and Prize Giving', 'End - TearDown', 'Coffee Break', 'Lunch', 'Free Time', 'Prize Giving', 'Party', 'Pub Quiz', 'Keynote by The Community'

    $Rooms = ($Schedule[0].psobject.properties | Where-Object { $_.Name -notin 'Day', 'Date', 'StartTime', 'EndTime', 'All Rooms' }).Name
    $Checking = $Schedule | Where-Object { $PsItem.'All Rooms'.Trim() -notin $plenarysessions -and $PsItem.Auditorium.Trim() -ne 'Opening Keynote' } | ForEach-Object {
        $Speakers = @{Name = 'Speakers'; Expression = { $_.psobject.properties | Where-Object Name -In $rooms | ForEach-Object { ($_.value -Split "`n")[1] } } }
        $PsItem | select Day, StartTime, EndTime, $Speakers
    }
    $Thursday = $Checking | Where-Object Day -EQ 'Thursday'
    $Friday = $Checking | Where-Object Day -EQ 'Friday'
    $Saturday = $Checking | Where-Object Day -EQ 'Saturday'
}

Describe "Ensuring <_.'Speaker Name'> available days are granted" -ForEach ($SpeakerRequests | where Available -NE 0) {
    BeforeDiscovery {
        $Available = $Psitem.Available
        $SpeakerName = $Psitem.'Speaker Name'
    }
    BeforeAll {
        $Available = $Psitem.Available
        $SpeakerName = $Psitem.'Speaker Name'
    }
    It "The Speaker $SpeakerName's session starting at <_.StartTime> on <_.Day> should be on the correct day $Available " -ForEach (($Checking | where Speakers -Like "*$SpeakerName*" )) {
        $Available.ToUpper().Replace('AM', '').Replace('PM', '').Replace(' ', '') | Should -BeLike "*$($PsItem.day.ToString().ToUpper())*"  -Because "The Speaker $SpeakerName should be on the correct day $Available "
    }
}

Describe "Ensuring <_.'Speaker Name'> available days AM and PM are granted" -ForEach ($SpeakerRequests | Where-Object { ($_.Available -like '*AM*') -or ($_.Available -like '*PM*') }) {
    BeforeDiscovery {
        $Available = $Psitem.Available
        $SpeakerName = $Psitem.'Speaker Name'
    }
    BeforeAll {
        $Available = $Psitem.Available
        $SpeakerName = $Psitem.'Speaker Name'
    }
    Context "Should be AM" -ForEach ($Available | Where-Object { $_ -like '*AM*' } ) {
        It "The Speaker $SpeakerName's session starting at <_.StartTime> on <_.Day> should be on the correct day $Available " -ForEach (($Checking | where Speakers -Like "*$SpeakerName*" )) {
            ([datetime]$Psitem.StartTime).Hour | Should -BeLessThan 13  -Because "The Speaker $SpeakerName should be in the AM"
            $Available.ToUpper().Replace('AM', '').Replace('PM', '').Replace(' ', '') | Should -BeLike "*$($PsItem.day.ToString().ToUpper())*"  -Because "The Speaker $SpeakerName should be on the correct day $Available "
           
        }
    }
    Context "Should be PM" -ForEach ($Available | Where-Object { $_ -like '*PM*' } ) {
        It "The Speaker $SpeakerName's session starting at <_.StartTime> on <_.Day> should be on the correct day $Available " -ForEach (($Checking | where Speakers -Like "*$SpeakerName*" )) {
            ([datetime]$Psitem.StartTime).Hour | Should -BeGreaterThan 12  -Because "The Speaker $SpeakerName should be in the PM"
            $Available.ToUpper().Replace('AM', '').Replace('PM', '').Replace(' ', '') | Should -BeLike "*$($PsItem.day.ToString().ToUpper())*"  -Because "The Speaker $SpeakerName should be on the correct day $Available "
        }
    }

}

Describe "Ensuring <_.'Speaker Name'> unavailable wishes are granted" -ForEach ($SpeakerRequests | where 'Not Available' -NE 0) {
    BeforeDiscovery {
        $NotAvailable = $Psitem.'Not Available'
        $SpeakerName = $Psitem.'Speaker Name'
    }
    BeforeAll {
        $NotAvailable = $Psitem.'Not Available'
        $SpeakerName = $Psitem.'Speaker Name'
    }
    It "$SpeakerName's session starting at <_.StartTime> on <_.Day> should not be scheduled on the wrong day $NotAvailable " -ForEach (($Checking | Where-Object { $_.Speakers -Like "*$SpeakerName*" -and $NotAvailable -notlike '*AM*' -and $NotAvailable -notlike '*PM*' })) {
        $NotAvailable.ToUpper().Replace('AM', '').Replace('PM', '').Replace(' ', '') | Should -Not -BeLike "*$($PsItem.day.ToString().ToUpper())*"  -Because "The Speaker $SpeakerName should not be on the wrong day $NotAvailable "
    }
}

Describe "Ensuring <_.'Speaker Name'> unavailable days AM and PM are granted" -ForEach ($SpeakerRequests | Where-Object { ($_.'Not Available' -like '*AM*') -or ($_.'Not Available' -like '*PM*') }) {
    BeforeDiscovery {
        $NotAvailable = $Psitem.'Not Available'
        $SpeakerName = $Psitem.'Speaker Name'
    }
    BeforeAll {
        $NotAvailable = $Psitem.Available
        $SpeakerName = $Psitem.'Speaker Name'
    }
    Context "Should NOT be AM" -ForEach ($NotAvailable | Where-Object { $_ -like '*AM*' } ) {
        It "The Speaker $SpeakerName's session starting at <_.StartTime> on <_.Day> should be on the correct day $NotAvailable and time" -ForEach (($Checking | Where-Object { $_.Speakers -Like "*$SpeakerName*" -and $_.Day -eq $NotAvailable.ToUpper().Replace('AM', '').Replace('PM', '').Replace(' ', '')  })) {
            ([datetime]$Psitem.StartTime).Hour | Should -BeGreaterThan 12  -Because "The Speaker $SpeakerName should not be in the AM"
            }
        }
        Context "Should NOT be PM" -ForEach ($NotAvailable | Where-Object { $_ -like '*PM*' } ) {
            It "The Speaker $SpeakerName's session starting at <_.StartTime> on <_.Day> should be on the correct day $NotAvailable and time" -ForEach (($Checking | Where-Object { $_.Speakers -Like "*$SpeakerName*" -and $_.Day -eq $NotAvailable.ToUpper().Replace('AM', '').Replace('PM', '').Replace(' ', '') } )) {
            ([datetime]$Psitem.StartTime).Hour | Should -BeLessThan 13  -Because "The Speaker $SpeakerName should not be in the PM"
            }
        }

    }