protected void Responsable(object sender, EventArgs e) { Assigned.DataSource = AssignedResponsable; Assigned.DataBind(); using (Helpdesk.Entities.Agences.AgenceEntities dba = new Entities.Agences.AgenceEntities()) { var req = from value in dba.Agences select value; var res = req.ToList(); if (res.Count == 0) { AutreResponsable.SelectCommand = "SELECT DISTINCT Responsables.ID, Responsables.Nom + ' ' + Responsables.Prenom AS Detaille FROM Responsables WHERE (Responsables.Niveau = 3) AND (Responsables.Role = 2)"; Autres.DataSource = AutreResponsable; Autres.DataBind(); } else { AutreResponsable.SelectCommand = "SELECT DISTINCT Responsables.ID, Responsables.Nom + ' ' + Responsables.Prenom AS Detaille FROM Responsables CROSS JOIN Agences WHERE (Responsables.Niveau = 3) AND (Responsables.Role = 2) AND (Responsables.ID NOT IN (SELECT Responsable FROM Agences AS Agences_1))"; Autres.DataSource = AutreResponsable; Autres.DataBind(); } } }
public EntreprisesPageVM() { #region Init Commands AddEntreprise = new RelayCommand(() => { switch (SelectedList) { case TypeListe.Importateur: container.Entreprises.Add(new Importateur() { Denomination = "Nouveau" }); container.SaveChanges(); OnPropertyChanged(nameof(Importateurs)); SelectedEntreprise = Importateurs.Last(); break; case TypeListe.Fournisseur: container.Entreprises.Add(new Fournisseur() { Denomination = "Nouveau" }); container.SaveChanges(); OnPropertyChanged(nameof(Fournisseurs)); SelectedEntreprise = Fournisseurs.Last(); break; case TypeListe.Banque: container.Entreprises.Add(new Banque() { Denomination = "Nouveau" }); container.SaveChanges(); OnPropertyChanged(nameof(Banques)); SelectedEntreprise = Banques.Last(); break; case TypeListe.Transit: container.Entreprises.Add(new Transit() { Denomination = "Nouveau" }); container.SaveChanges(); OnPropertyChanged(nameof(Transitaires)); SelectedEntreprise = Transitaires.Last(); break; case TypeListe.Autre: container.Entreprises.Add(new Entreprise() { Denomination = "Nouveau" }); container.SaveChanges(); OnPropertyChanged(nameof(Autres)); SelectedEntreprise = Autres.Last(); break; } IsDialogHostOpen = true; }); DeleteEntreprise = new RelayCommand(() => { container.Entreprises.Remove(SelectedEntreprise.Entreprise); container.SaveChanges(); switch (SelectedList) { case TypeListe.Importateur: OnPropertyChanged(nameof(Importateurs)); break; case TypeListe.Fournisseur: OnPropertyChanged(nameof(Fournisseurs)); break; case TypeListe.Banque: OnPropertyChanged(nameof(Banques)); break; case TypeListe.Transit: OnPropertyChanged(nameof(Transitaires)); break; case TypeListe.Autre: OnPropertyChanged(nameof(Autres)); break; } }); EditEntreprise = new RelayCommand(() => { IsDialogHostOpen = true; }); CloseDialogHost = new RelayCommand(() => { IsDialogHostOpen = false; }); #endregion }