public List <Cour> AfficherChatRoom()
{
using (var db = new MarcassinEntities1()) {
List <Cour> list = db.Cours.Include("ChatRoom").ToList();
return(list);
}
}
public List <Admin> AfficherAdmin()
{
using (var db = new MarcassinEntities1()) {
List <Admin> list = db.Admins.ToList();
return(list);
}
}
public PageAjouterCours(Cour a)
{
InitializeComponent();
WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
txt_Nom.Text = a.nomCours;
cb_Finis.IsChecked = a.estFinit;
d_Date.SelectedDate = a.dateCours;
using (var db = new MarcassinEntities1()) {
cmb_Competence.ItemsSource = db.Competences.ToList();
cmb_Competence.DisplayMemberPath = "nomCompetence";
cmb_Competence.SelectedValuePath = "idCompetence";
int index = 0;
for (int i = 0; i < cmb_Competence.Items.Count; i++)
{
List <Competence> parts = db.Competences.ToList();
if (parts[i].nomCompetence == a.Competence.nomCompetence)
{
index = i;
}
}
this.cmb_Competence.SelectedIndex = index;
}
Id = a.idCours;
Action = "update";
Btn_ajouter.Content = "Modifier";
Btn_ajouter.Background = new SolidColorBrush(Color.FromRgb(255, 200, 0));
}
public PageAjouterBadge(Badge a)
{
InitializeComponent();
WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
txt_Nom.Text = a.nomBadge;
using (var db = new MarcassinEntities1()) {
cmb_Langue.ItemsSource = db.Langues.ToList();
cmb_Langue.DisplayMemberPath = "nomLangue";
cmb_Langue.SelectedValuePath = "idLangue";
int index = 0;
for (int i = 0; i < cmb_Langue.Items.Count; i++)
{
List <Langue> parts = db.Langues.ToList();
if (parts[i].nomLangue == a.Langue.nomLangue)
{
index = i;
}
}
this.cmb_Langue.SelectedIndex = index;
}
Id = a.id_Badge;
Action = "update";
Btn_ajouter.Content = "Modifier";
Btn_ajouter.Background = new SolidColorBrush(Color.FromRgb(255, 200, 0));
}
public PageAjouterVille(Ville a)
{
InitializeComponent();
WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
txt_Ville.Text = a.nomVille;
using (var db = new MarcassinEntities1()) {
cmb_Pays.ItemsSource = db.Pays.ToList();
cmb_Pays.DisplayMemberPath = "nomPays";
cmb_Pays.SelectedValuePath = "id_Pays";
int index = 0;
for (int i = 0; i < cmb_Pays.Items.Count; i++)
{
List <Pay> parts = db.Pays.ToList();
if (parts[i].nomPays == a.Pay.nomPays)
{
index = i;
}
}
this.cmb_Pays.SelectedIndex = index;
}
Id = a.id_Ville;
Action = "update";
Btn_ajouter.Content = "Modifier";
Btn_ajouter.Background = new SolidColorBrush(Color.FromRgb(255, 200, 0));
}
public void SupprEnt(Entreprise a)
{
using (var db = new MarcassinEntities1()) {
Entreprise b = db.Entreprises.Find(a.id_Entreprise);
db.Entreprises.Remove(b);
db.SaveChanges();
}
}
public void SupprComp(Competence a)
{
using (var db = new MarcassinEntities1()) {
Competence b = db.Competences.Find(a.idCompetence);
db.Competences.Remove(b);
db.SaveChanges();
}
}
public void SupprVille(Ville a)
{
using (var db = new MarcassinEntities1()) {
Ville b = db.Villes.Find(a.id_Ville);
db.Villes.Remove(b);
db.SaveChanges();
}
}
public void SupprPays(Pay a)
{
using (var db = new MarcassinEntities1()) {
Pay b = db.Pays.Find(a.id_Pays);
db.Pays.Remove(b);
db.SaveChanges();
}
}
public void SupprChat(ChatRoom a)
{
using (var db = new MarcassinEntities1()) {
ChatRoom b = db.ChatRooms.Find(a.idChatRoom);
db.ChatRooms.Remove(b);
db.SaveChanges();
}
}
public void SupprLangue(Langue a)
{
using (var db = new MarcassinEntities1()) {
Langue b = db.Langues.Find(a.idLangue);
db.Langues.Remove(b);
db.SaveChanges();
}
}
public void SupprCours(Cour a)
{
using (var db = new MarcassinEntities1()) {
Cour b = db.Cours.Find(a.idCours);
db.Cours.Remove(b);
db.SaveChanges();
}
}
public void SupprUtil(Utilisateur a)
{
using (var db = new MarcassinEntities1()) {
Utilisateur b = db.Utilisateurs.Find(a.idUtilisateur);
db.Utilisateurs.Remove(b);
db.SaveChanges();
}
}
public void SupprAdmin(Admin a)
{
using (var db = new MarcassinEntities1()) {
Admin b = db.Admins.Find(a.idAdmin);
db.Admins.Remove(b);
db.SaveChanges();
}
}
public void ModifyPays(int Id, string Nom)
{
using (var db = new MarcassinEntities1()) {
Pay b = db.Pays.Find(Id);
b.nomPays = Nom;
db.Entry(b).State = EntityState.Modified;
db.SaveChanges();
}
}
public void ModifyChat(int Id, string Nom)
{
using (var db = new MarcassinEntities1()) {
ChatRoom b = db.ChatRooms.Find(Id);
b.nomduRoom = Nom;
db.Entry(b).State = EntityState.Modified;
db.SaveChanges();
}
}
public void ModifyLangue(int Id, string Nom)
{
using (var db = new MarcassinEntities1()) {
Langue b = db.Langues.Find(Id);
b.nomLangue = Nom;
db.Entry(b).State = EntityState.Modified;
db.SaveChanges();
}
}
public void ModifyEnt(int Id, string Nom, Ville Ville)
{
using (var db = new MarcassinEntities1()) {
Entreprise b = db.Entreprises.Find(Id);
b.nomEntreprise = Nom;
b.Ville = db.Villes.Find(Ville.id_Ville);
db.Entry(b).State = EntityState.Modified;
db.SaveChanges();
}
}
public void ModifyVille(int Id, string Nom, Pay pays)
{
using (var db = new MarcassinEntities1()) {
Ville b = db.Villes.Find(Id);
b.nomVille = Nom;
b.Pay = db.Pays.Find(pays.id_Pays);
db.Entry(b).State = EntityState.Modified;
db.SaveChanges();
}
}
public void InsertVille(string Nom, Pay pays)
{
using (var db = new MarcassinEntities1()) {
db.Villes.Add(new Ville()
{
nomVille = Nom, Pay = pays
});
db.SaveChanges();
}
}
public void InsertPays(string Nom)
{
using (var db = new MarcassinEntities1()) {
db.Pays.Add(new Pay()
{
nomPays = Nom
});
db.SaveChanges();
}
}
public void InsertLangue(string Nom)
{
using (var db = new MarcassinEntities1()) {
db.Langues.Add(new Langue()
{
nomLangue = Nom
});
db.SaveChanges();
}
}
public void ModifyBadge(int Id, string Nom, Langue Lang)
{
using (var db = new MarcassinEntities1()) {
Badge b = db.Badges.Find(Id);
b.nomBadge = Nom;
b.Langue = db.Langues.Find(Lang.idLangue);
db.Entry(b).State = EntityState.Modified;
db.SaveChanges();
}
}
public void InsertBadge(string Nom, Langue Lang)
{
using (var db = new MarcassinEntities1()) {
db.Badges.Add(new Badge()
{
nomBadge = Nom, Langue = Lang
});
db.SaveChanges();
}
}
public void InsertAdmin(string Prenom, string Nom, string Mdp)
{
using (var db = new MarcassinEntities1()) {
db.Admins.Add(new Admin()
{
prenomAdmin = Prenom, nomAdmin = Nom, motDePasseAdmin = Mdp
});
db.SaveChanges();
}
}
public void InsertChat(string Nom)
{
using (var db = new MarcassinEntities1()) {
db.ChatRooms.Add(new ChatRoom()
{
nomduRoom = Nom
});
db.SaveChanges();
}
}
public void InsertEnt(string Nom, Ville Ville)
{
using (var db = new MarcassinEntities1()) {
db.Entreprises.Add(new Entreprise()
{
nomEntreprise = Nom, Ville = Ville
});
db.SaveChanges();
}
}
public PageAjouterCours()
{
InitializeComponent();
WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
using (var db = new MarcassinEntities1()) {
cmb_Competence.ItemsSource = db.Competences.ToList();
}
cmb_Competence.DisplayMemberPath = "nomCompetence";
cmb_Competence.SelectedValuePath = "idCompetence";
Action = "add";
}
private void txt_recherche_TextChanged(object sender, TextChangedEventArgs e)
{
if (txt_recherche.Text != "Recherche")
{
using (var db = new MarcassinEntities1())
{
Lv_Util.ItemsSource = db.Utilisateurs.Include("Ville").Include("Entreprise")
.Where(k => k.nomUtilisateur.ToUpper().Contains(txt_recherche.Text.ToUpper()) || k.prenomUtilisateur.Contains(txt_recherche.Text)).ToList();
}
}
}
public PageAjouterVille()
{
InitializeComponent();
WindowStartupLocation = System.Windows.WindowStartupLocation.CenterScreen;
using (var db = new MarcassinEntities1()) {
cmb_Pays.ItemsSource = db.Pays.ToList();
}
cmb_Pays.DisplayMemberPath = "nomPays";
cmb_Pays.SelectedValuePath = "id_Pays";
Action = "add";
}
