$csvoct1 = Import-Csv "./oct1.csv" -Delimiter ';'
$csvoct2 = Import-Csv "./oct2.csv" -Delimiter ';'
$csvduree = Import-Csv "./duree.csv" -Delimiter ';'
$sheet = Import-Csv "./sheet.csv" -Delimiter ';'

$oct1 = @{}
foreach ($row in $csvoct1) {
    $key = $row.note
    $value = $row.frequence
    $oct1[$key] = $value
}

$oct2 = @{}
foreach ($row in $csvoct2) {
    $key = $row.note
    $value = $row.frequence
    $oct2[$key] = $value
}

$duree = @{}
foreach ($row in $csvduree) {
    $key = $row.DureeNote
    $value = $row.Valeur
    $duree[$key] = $value
}

foreach ($row in $sheet){
    switch ($row.Octave) {
        "1" { $oct = $oct1 }
        "2" { $oct = $oct2 }
        default { $oct = "pause" }
    }
    switch ($row.Note) {
        "pause" { $note = "pause" }
        default { $note = [int]$oct[$row.Note] }
    }
    switch ($row.Duree) {
        "pause" { $length = $row.Duree }
        default { $length = $duree[$row.Duree] }
    }
    switch ($note) {
        "pause" { start-sleep -m $length*1000 }
        Default {
            Write-Host  "La note est $note et la durée est $length"
            [System.Console]::beep($note, $length) }
    }
}