Import-Module ActiveDirectory
Import-Module 'Microsoft.PowerShell.Security'

$users = Import-Csv -Delimiter ";" -Path "C:\Users\Administrateur\Desktop\import.csv"

#********Création des Groupes*********

New-ADGroup -Name Direction -GroupScope Global -GroupCategory Security -Path "ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name Financier -GroupScope Global -GroupCategory Security -Path "ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name Administratif -GroupScope Global -GroupCategory Security -Path "ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name Gestion -GroupScope Global -GroupCategory Security -Path "ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name Commerciale -GroupScope Global -GroupCategory Security -Path "ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name Comptable -GroupScope Global -GroupCategory Security -Path "ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name Transport -GroupScope Global -GroupCategory Security -Path "ou=Employés,dc=BTC,dc=com"

#*********************Groupes sous Paris************************

New-ADGroup -Name DirectionParis -GroupScope Global -GroupCategory Security -Path "ou=Paris,ou=France,ou=Europe,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name FinancierParis -GroupScope Global -GroupCategory Security -Path "ou=Paris,ou=France,ou=Europe,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name AdministratifParis -GroupScope Global -GroupCategory Security -Path "ou=Paris,ou=France,ou=Europe,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name GestionParis -GroupScope Global -GroupCategory Security -Path "ou=Paris,ou=France,ou=Europe,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name CommercialeParis -GroupScope Global -GroupCategory Security -Path "ou=Paris,ou=France,ou=Europe,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name ComptableParis -GroupScope Global -GroupCategory Security -Path "ou=Paris,ou=France,ou=Europe,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name TransportParis -GroupScope Global -GroupCategory Security -Path "ou=Paris,ou=France,ou=Europe,ou=Employés,dc=BTC,dc=com"


#*********************Groupes sous Pékin************************

New-ADGroup -Name DirectionPékin -GroupScope Global -GroupCategory Security -Path "ou=Pékin,ou=Chine,ou=Asie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name GestionPékin -GroupScope Global -GroupCategory Security -Path "ou=Pékin,ou=Chine,ou=Asie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name AdministratifPékin -GroupScope Global -GroupCategory Security -Path "ou=Pékin,ou=Chine,ou=Asie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name ComptablePékin -GroupScope Global -GroupCategory Security -Path "ou=Pékin,ou=Chine,ou=Asie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name CommercialePékin -GroupScope Global -GroupCategory Security -Path "ou=Pékin,ou=Chine,ou=Asie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name FinancierPékin -GroupScope Global -GroupCategory Security -Path "ou=Pékin,ou=Chine,ou=Asie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name TransportPékin -GroupScope Global -GroupCategory Security -Path "ou=Pékin,ou=Chine,ou=Asie,ou=Employés,dc=BTC,dc=com"

#*********************Groupes sous Canberra************************

New-ADGroup -Name DirectionCanberra -GroupScope Global -GroupCategory Security -Path "ou=Canberra,ou=Australie,ou=Océanie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name FinancierCanberra -GroupScope Global -GroupCategory Security -Path "ou=Canberra,ou=Australie,ou=Océanie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name AdministratifCanberra -GroupScope Global -GroupCategory Security -Path "ou=Canberra,ou=Australie,ou=Océanie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name GestionCanberra -GroupScope Global -GroupCategory Security -Path "ou=Canberra,ou=Australie,ou=Océanie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name CommercialeCanberra -GroupScope Global -GroupCategory Security -Path "ou=Canberra,ou=Australie,ou=Océanie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name ComptableCanberra -GroupScope Global -GroupCategory Security -Path "ou=Canberra,ou=Australie,ou=Océanie,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name TransportCanberra -GroupScope Global -GroupCategory Security -Path "ou=Canberra,ou=Australie,ou=Océanie,ou=Employés,dc=BTC,dc=com"

#*********************Groupes sous Rabat************************

New-ADGroup -Name DirectionRabat -GroupScope Global -GroupCategory Security -Path "ou=Rabat,ou=Maroc,ou=Afrique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name FinancierRabat -GroupScope Global -GroupCategory Security -Path "ou=Rabat,ou=Maroc,ou=Afrique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name AdministratifRabat -GroupScope Global -GroupCategory Security -Path "ou=Rabat,ou=Maroc,ou=Afrique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name GestionRabat -GroupScope Global -GroupCategory Security -Path "ou=Rabat,ou=Maroc,ou=Afrique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name CommercialeRabat -GroupScope Global -GroupCategory Security -Path "ou=Rabat,ou=Maroc,ou=Afrique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name ComptableRabat -GroupScope Global -GroupCategory Security -Path "ou=Rabat,ou=Maroc,ou=Afrique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name TransportRabat -GroupScope Global -GroupCategory Security -Path "ou=Rabat,ou=Maroc,ou=Afrique,ou=Employés,dc=BTC,dc=com"

#*********************Groupes sous Washington************************

New-ADGroup -Name DirectionWashington -GroupScope Global -GroupCategory Security -Path "ou=Washington,ou=USA,ou=Amérique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name FinancierWashington -GroupScope Global -GroupCategory Security -Path "ou=Washington,ou=USA,ou=Amérique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name AdministratifWashington -GroupScope Global -GroupCategory Security -Path "ou=Washington,ou=USA,ou=Amérique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name GestionWashington -GroupScope Global -GroupCategory Security -Path "ou=Washington,ou=USA,ou=Amérique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name CommercialeWashington -GroupScope Global -GroupCategory Security -Path "ou=Washington,ou=USA,ou=Amérique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name ComptableWashington -GroupScope Global -GroupCategory Security -Path "ou=Washington,ou=USA,ou=Amérique,ou=Employés,dc=BTC,dc=com"
New-ADGroup -Name TransportWashington -GroupScope Global -GroupCategory Security -Path "ou=Washington,ou=USA,ou=Amérique,ou=Employés,dc=BTC,dc=com"






 
foreach ($user in $users){

    $name = $user.firstName + " " + $user.lastName
    $fname = $user.firstName
    $lname = $user.lastName
    $login = $user.firstName + "." + $user.lastName
    $UContinent = $user.Continent
    $UPays = $user.Pays
    $UVilles = $user.Villes
    $Upassword = $user.password
    $dept = $user.department 
    $UprincpaleName=$user.firstName + $user.lastName   + "@"+ "BTC" + "." + "com"


#********Ajout des utilisateurs de Paris dans leurs groupes********************

if ($UVilles -eq "Paris" -and $dept -eq "Direction"){

    Add-ADGroupMember -Identity 'DirectionParis' -Members $login

}
elseif ($UVilles -eq "Paris" -and $dept -eq "Administratif"){

    Add-ADGroupMember -Identity 'AdministratifParis' -Members $login

}


elseif ($UVilles -eq "Paris" -and $dept -eq "Financier"){

    Add-ADGroupMember -Identity 'FinancierParis' -Members $login
} 


elseif ($UVilles -eq "Paris" -and $dept -eq "Comptable"){

    Add-ADGroupMember -Identity 'ComptableParis' -Members $login
} 


elseif ($UVilles -eq "Paris" -and $dept -eq "Commerciale"){

    Add-ADGroupMember -Identity 'CommercialeParis' -Members $login
} 

elseif ($UVilles -eq "Paris" -and $dept -eq "Gestion"){

    Add-ADGroupMember -Identity 'GestionParis' -Members $login
} 

elseif ($UVilles -eq "Paris" -and $dept -eq "Transport"){

    Add-ADGroupMember -Identity 'TransportParis' -Members $login
} 





#********Ajout des users de Pékin dans leurs groupes********************


if ($UVilles -eq "Pékin" -and $dept -eq "Direction"){

    Add-ADGroupMember -Identity 'DirectionPékin' -Members $login

}
elseif ($UVilles -eq "Pékin" -and $dept -eq "Administratif"){

    Add-ADGroupMember -Identity 'AdministratifPékin' -Members $login

}


elseif ($UVilles -eq "Pékin" -and $dept -eq "Financier"){

    Add-ADGroupMember -Identity 'FinancierPékin' -Members $login
} 


elseif ($UVilles -eq "Pékin" -and $dept -eq "Comptable"){

    Add-ADGroupMember -Identity 'ComptablePékin' -Members $login
} 


elseif ($UVilles -eq "Pékin" -and $dept -eq "Commerciale"){

    Add-ADGroupMember -Identity 'CommercialePékin' -Members $login
} 

elseif ($UVilles -eq "Pékin" -and $dept -eq "Gestion"){

    Add-ADGroupMember -Identity 'GestionPékin' -Members $login
} 

elseif ($UVilles -eq "Pékin" -and $dept -eq "Transport"){

    Add-ADGroupMember -Identity 'TransportPékin' -Members $login
} 




#********Ajout des users de Canberra dans leurs groupes********************


if ($UVilles -eq "Canberra" -and $dept -eq "Direction"){

    Add-ADGroupMember -Identity 'DirectionCanberra' -Members $login

}
elseif ($UVilles -eq "Canberra" -and $dept -eq "Administratif"){

    Add-ADGroupMember -Identity 'AdministratifCanberra' -Members $login

}

elseif ($UVilles -eq "Canberra" -and $dept -eq "Financier"){

    Add-ADGroupMember -Identity 'FinancierCanberra' -Members $login
} 


elseif ($UVilles -eq "Canberra" -and $dept -eq "Comptable"){

    Add-ADGroupMember -Identity 'ComptableCanberra' -Members $login
} 


elseif ($UVilles -eq "Canberra" -and $dept -eq "Commerciale"){

    Add-ADGroupMember -Identity 'CommercialeCanberra' -Members $login
} 

elseif ($UVilles -eq "Canberra" -and $dept -eq "Gestion"){

    Add-ADGroupMember -Identity 'GestionCanberra' -Members $login
} 

elseif ($UVilles -eq "Canberra" -and $dept -eq "Transport"){

    Add-ADGroupMember -Identity 'TransportCanberra' -Members $login
} 

#*********************Groupes sous Rabat************************


if ($UVilles -eq "Rabat" -and $dept -eq "Direction"){

    Add-ADGroupMember -Identity 'DirectionRabat' -Members $login

}
elseif ($UVilles -eq "Rabat" -and $dept -eq "Administratif"){

    Add-ADGroupMember -Identity 'AdministratifRabat' -Members $login

}


elseif ($UVilles -eq "Rabat" -and $dept -eq "Financier"){

    Add-ADGroupMember -Identity 'FinancierRabat' -Members $login
} 


elseif ($UVilles -eq "Rabat" -and $dept -eq "Comptable"){

    Add-ADGroupMember -Identity 'ComptableRabat' -Members $login
} 


elseif ($UVilles -eq "Rabat" -and $dept -eq "Commerciale"){

    Add-ADGroupMember -Identity 'CommercialeRabat' -Members $login
} 

elseif ($UVilles -eq "Rabat" -and $dept -eq "Gestion"){

    Add-ADGroupMember -Identity 'GestionRabat' -Members $login
} 

elseif ($UVilles -eq "Rabat" -and $dept -eq "Transport"){

    Add-ADGroupMember -Identity 'TransportRabat' -Members $login
} 



#*********************Groupes sous Washington************************


if ($UVilles -eq "Washington" -and $dept -eq "Direction"){

    Add-ADGroupMember -Identity 'DirectionWashington' -Members $login

}
elseif ($UVilles -eq "Washington" -and $dept -eq "Administratif"){

    Add-ADGroupMember -Identity 'AdministratifWashington' -Members $login

}


elseif ($UVilles -eq "Washington" -and $dept -eq "Financier"){

    Add-ADGroupMember -Identity 'FinancierWashington' -Members $login
} 


elseif ($UVilles -eq "Washington" -and $dept -eq "Comptable"){

    Add-ADGroupMember -Identity 'ComptableWashington' -Members $login
} 


elseif ($UVilles -eq "Washington" -and $dept -eq "Commerciale"){

    Add-ADGroupMember -Identity 'CommercialeWashington' -Members $login
} 

elseif ($UVilles -eq "Washington" -and $dept -eq "Gestion"){

    Add-ADGroupMember -Identity 'GestionWashington' -Members $login
} 

elseif ($UVilles -eq "Washington" -and $dept -eq "Transport"){

    Add-ADGroupMember -Identity 'TransportWashington' -Members $login
} 


}







#Ajout des groupes dans les groupes


Add-ADGroupMember -Identity 'Direction' -Members DirectionParis,DirectionCanberra,DirectionPékin,DirectionRabat,DirectionWashington
Add-ADGroupMember -Identity 'Financier' -Members FinancierParis,FinancierCanberra,FinancierPékin,FinancierRabat,FinancierWashington
Add-ADGroupMember -Identity 'Administratif' -Members AdministratifParis,AdministratifCanberra,AdministratifPékin,AdministratifRabat,AdministratifWashington
Add-ADGroupMember -Identity 'Gestion' -Members GestionParis,GestionCanberra,GestionPékin,GestionRabat,GestionWashington
Add-ADGroupMember -Identity 'Commerciale' -Members CommercialeParis,CommercialeCanberra,CommercialePékin,CommercialeRabat,CommercialeWashington
Add-ADGroupMember -Identity 'Comptable' -Members ComptableParis,ComptableCanberra,ComptablePékin,ComptableRabat,ComptableWashington
Add-ADGroupMember -Identity 'Transport' -Members TransportParis,TransportCanberra,TransportPékin,TransportRabat,TransportWashington