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(); }