public async Task OnSaveDepartment()
{
Department.Name = Name;
Department.Code = Code;
try
{
Department = await _departmentRepository.AddDepartment(Department);
}
catch (DbException ex)
{
Console.WriteLine(ex.Message);
}
if (Professor.Id != 0)
{
var profDep = new ProfessorDepartment()
{
DepartmentId = Department.Id, ProfessorId = Professor.Id, IsHead = true
};
try
{
await _departmentRepository.ProfessorDepartment(profDep);
}
catch (DbException ex)
{
Console.WriteLine(ex.Message);
}
}
await OnCancel();
}
public async Task <ProfessorDepartment> ProfessorDepartment(ProfessorDepartment professorDepartment)
{
await _context.ProfessorDepartments.AddAsync(professorDepartment);
await _context.SaveChangesAsync();
return(professorDepartment);
}
public Task HandleAsync(ProfessorDepartment message, CancellationToken cancellationToken)
{
GetProfessor = _professorRepository.GetProfessorById(message.ProfessorId);
Department = Departments.Where(dep => dep.DepartmentId == message.DepartmentId).FirstOrDefault();
FirstName = GetProfessor.FirstName;
LastName = GetProfessor.LastName;
Email = GetProfessor.Email;
Photo = GetProfessor.MainPhotoUrl;
Cin = GetProfessor.Cin;
Diploma = GetProfessor.Diplome;
return(Task.CompletedTask);
}
public async Task <ProfessorDepartment> UpdateProfessorDepartment(ProfessorDepartment professorDepartment)
{
var professor = _context.ProfessorDepartments.Where(pro => pro.Id == professorDepartment.Id).FirstOrDefault();
if (professor != null)
{
professor.ProfessorId = professorDepartment.ProfessorId;
professor.DepartmentId = professorDepartment.DepartmentId;
professor.IsHead = professorDepartment.IsHead;
await _context.SaveChangesAsync();
return(professor);
}
else
{
await ProfessorDepartment(professorDepartment);
return(professorDepartment);
}
}
public async Task OnUpdateProfessor(Professor professor)
{
await _eventAggregator.PublishOnCurrentThreadAsync(ViewType.UpdateProfessor);
var depId = GetProfessorDepartments
.Where(profDepart => profDepart.ProfessorId == professor.Id).FirstOrDefault();
if (depId != null)
{
ProfessorDepartment temp = new ProfessorDepartment()
{
ProfessorId = professor.Id,
DepartmentId = depId.DepartmentId,
IsHead = depId.IsHead,
Id = depId.Id
};
await _eventAggregator.PublishOnCurrentThreadAsync(temp);
}
else
{
await _eventAggregator.PublishOnCurrentThreadAsync(professor);
}
}
public async Task OnUpdateDepartment()
{
var depart = new Department()
{
Id = Department.Id,
Code = Code,
Name = Name
};
try
{
await _departmentRepository.UpdateDepartment(depart);
}
catch (DbException ex)
{
Console.WriteLine(ex.Message);
}
if (Professor.Id != Id)
{
var newHeadDep = new ProfessorDepartment()
{
Id = DepartmentProfessor.Id,
DepartmentId = Department.Id,
ProfessorId = Professor.Id,
IsHead = true
};
try
{
await _departmentRepository.UpdateProfessorDepartment(newHeadDep);
}
catch (DbException ex)
{
Console.WriteLine(ex.Message);
}
}
await OnClose();
}
public async Task OnUpdate()
{
Professor.Id = GetProfessor.Id;
Professor.FirstName = FirstName;
Professor.LastName = LastName;
Professor.Cin = Cin;
Professor.Email = Email;
Professor.HiringDate = DateTime.Now;
Professor.Diplome = Diploma;
Professor.MainPhotoUrl = Photo;
try
{
await _professorRepository.UpdateProfessor(Professor);
var proDep = new ProfessorDepartment()
{
ProfessorId = Professor.Id,
DepartmentId = Department.DepartmentId,
};
if (GetProfessorDepartments.Where(proDep => proDep.ProfessorId == Professor.Id).FirstOrDefault() != null)
{
proDep.IsHead = GetProfessorDepartments.Where(proDep => proDep.ProfessorId == Professor.Id)
.FirstOrDefault().IsHead;
}
else
{
proDep.IsHead = false;
}
await _departmentRepository.UpdateProfessorDepartment(proDep);
}
catch (Exception ex)
{
Console.WriteLine("Exception de type " + ex.Message);
}
await OnCancel();
}
public async void DeleteProfessorDepartment(ProfessorDepartment professorDepartment)
{
_context.ProfessorDepartments.Remove(professorDepartment);
await _context.SaveChangesAsync();
}
public static void init(PFEContext context)
{
context.Database.EnsureCreated();
if (context.Etudiants.Any())
{
return;
}
var Professors = new Professeur[] {
new Professeur {
Fname = "BELOUADHA", Lname = "Fatima Zahra", ID_prof = "benlouadha", Disponible = 0
},
new Professeur {
Fname = "KABBAJ", Lname = "Mohamed Issam", ID_prof = "kabbaj", Disponible = 1
},
new Professeur {
Fname = "HASBI", Lname = "Abderrahim", ID_prof = "hasbi", Disponible = 1
},
};
foreach (var prof in Professors)
{
context.Professeurs.Add(prof);
}
context.SaveChanges();
var dept = new Departement {
nom = "Informatique", code_ID = "INF", ID_chef = "belouadha"
};
var specialty = new Specialty {
name = "système d'information", code_dept = "INF", ID_specialty = "SI"
};
context.Departement.Add(dept);
context.SaveChanges();
context.Specialtys.Add(specialty);
context.SaveChanges();
var Etudiants = new Etudiant[] {
new Etudiant {
Fname = "AIT BEN EL ARBI", Lname = "Anass", Email = "*****@*****.**", ID = 12345, Branch = "INF", Specialty = "SI"
},
new Etudiant {
Fname = "EL JALAOUI", Lname = "Omar", Email = "*****@*****.**", ID = 123456, Branch = "INF", Specialty = "SI"
}
};
foreach (var stud in Etudiants)
{
context.Etudiants.Add(stud);
}
context.SaveChanges();
var Prof_dept = new ProfessorDepartment[] {
new ProfessorDepartment {
ID_departement = "INF", ID_prof = "belouadha"
},
new ProfessorDepartment {
ID_departement = "INF", ID_prof = "kabbaj"
}
};
foreach (var prof_dept in Prof_dept)
{
context.ProfessorDepartment.Add(prof_dept);
}
context.SaveChanges();
context.PFEs.Add(new PFE {
id_prof = "kabbaj", id_student = 12345, lien_PFE = "https://wwww.google.com", sujet = "Delivery Optimizer"
});
context.PFEs.Add(new PFE {
id_prof = "kabbaj", id_student = 123456, lien_PFE = "https://wwww.google.com", sujet = "Delivery Optimizer"
});
context.SaveChanges();
context.DemandeEncadrements.Add(new DemandeEncadrements {
date_depot = new DateTime(2020, 04, 01, 10, 00, 03),
ID_Etudiant = 12345,
ID_Prof = "kabbaj",
ETAT = 1,
liens_complementaires = "https://www.google.com,https://www.thexcoders.net,https://www.youtube.com",
SujetPFE = "développement d'une platforme pour réduire le temps d'execution d'attente des packets d'une entreprise de livraison"
});
context.DemandeEncadrements.Add(new DemandeEncadrements
{
date_depot = new DateTime(2020, 04, 01, 16, 16, 44),
ID_Etudiant = 12345,
ETAT = 0,
ID_Prof = "benlouadha",
liens_complementaires = "https://www.google.com",
SujetPFE = "développement d'une platforme pour réduire le temps d'execution d'attente des packets d'une entreprise de livraison"
});
context.DemandeEncadrements.Add(new DemandeEncadrements
{
date_depot = new DateTime(2020, 04, 01, 16, 20, 44),
ID_Etudiant = 12345,
ETAT = 0,
ID_Prof = "hasbi",
liens_complementaires = "https://www.google.com",
SujetPFE = "développement d'une platforme pour réduire le temps d'execution d'attente des packets d'une entreprise de livraison"
});
context.SaveChanges();
context.RemarqueProf.Add(new RemarqueProf
{
id_prof = "kabbaj",
id_student = 12345,
date_remarque = new DateTime(2020, 05, 15, 16, 16, 44),
remarque = "Refaire l'étude des technologies ( techno u tilisé non justifié)",
liens_complementaires = "",
seen = true
});
context.RemarqueProf.Add(new RemarqueProf
{
id_prof = "kabbaj",
id_student = 12345,
date_remarque = new DateTime(2020, 05, 15, 20, 16, 44),
remarque = "le plan de la présentation",
liens_complementaires = "https://www.youtube.com,https://scholar.google.com",
seen = false
});
context.SaveChanges();
}
