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
}
