public function run()
{
$programme = Programme::where('id', '=', '420AA')->first();
$classeCN2 = Classe::where('code', '=', '420-CN2-DM')->first();
$classeDM1 = Classe::where('code', '=', '420-DM1-DM')->first();
$classeDM2 = Classe::where('code', '=', '420-DM2-DM')->first();
$roleadmin = Role::where('name', '=', 'admin')->first();
$roleprof = Role::where('name', '=', 'professeur')->first();
$roleetudiant = Role::where('name', '=', 'etudiant')->first();
DB::table('users_classes')->delete();
DB::table('users')->delete();
$user = new User();
$user->name = 'Admin';
$user->nom = 'systeme';
$user->prenom = 'admin';
$user->type = 'p';
$user->email = '*****@*****.**';
$user->password = Hash::make('usager');
$user->save();
$user->attachRole($roleadmin);
$user = new User();
$user->name = 'prof1';
$user->nom = 'prof1 ';
$user->prenom = 'un';
$user->type = 'p';
$user->email = '*****@*****.**';
$user->password = Hash::make('usager');
$programme->users()->save($user);
$user->attachRole($roleprof);
$user->classes()->sync([$classeCN2->id, $classeDM1->id]);
$user = new User();
$user->name = 'prof2';
$user->nom = 'prof2 ';
$user->prenom = 'deux';
$user->type = 'p';
$user->email = '*****@*****.**';
$user->password = Hash::make('usager');
$programme->users()->save($user);
$user->attachRole($roleprof);
$user->classes()->sync([$classeCN2->id, $classeDM2->id]);
$user = new User();
$user->name = 'etudiant1';
$user->nom = 'etudiant';
$user->prenom = 'un';
$user->type = 'e';
$user->email = '*****@*****.**';
$user->password = Hash::make('usager');
$programme->users()->save($user);
$user->attachRole($roleetudiant);
$user->classes()->sync([$classeCN2->id, $classeDM1->id]);
$user = new User();
$user->name = 'etudiant2';
$user->nom = 'etudiant2';
$user->prenom = 'deux';
$user->type = 'e';
$user->email = '*****@*****.**';
$user->password = Hash::make('usager');
$programme->users()->save($user);
$role = Role::where('name', '=', 'etudiant')->first();
$user->attachRole($roleetudiant);
$user->classes()->sync([$classeCN2->id, $classeDM1->id, $classeDM2->id]);
}
