public static void UpdCompetence(Competence_BO compBO)
{
using (var db = new MarcassinEntities())
{
Competence comp = db.Competence.Find(compBO.Id_Competence);
var cat = from ca in db.Categorie
where ca.Intitule == compBO.Categorie
select ca.id_Categorie;
comp.id_categorie = cat.FirstOrDefault();
db.SaveChanges();
if (compBO.Competence_mere != "")
{
var comref = from lc in db.Langue_Competence
where lc.Traduction == compBO.Competence_mere
select lc.id_Competence;
comp.id_Competence_ref = comref.FirstOrDefault();
comp.est_actif = false;
}
db.SaveChanges();
Langue_Competence langcomp = db.Langue_Competence.Where(l => l.id_Competence == compBO.Id_Competence).Where(l => l.id_Langue == 1).FirstOrDefault();
langcomp.Traduction = compBO.Competence;
db.SaveChanges();
}
}
public Competence_trad_ajout(Competence_BO compBO)
{
InitializeComponent();
listLangues = Appel_List.GetLangues();
langue.ItemsSource = listLangues;
comp.Content = compBO.Competence;
compeBO = compBO;
}
public Competence_trad_list(Competence_BO compBO)
{
InitializeComponent();
listtrad = Appel_List.GetTradCompetence(compBO);
list1.ItemsSource = listtrad.Keys;
Intitule.Content = compBO.Competence;
compeBO = compBO;
}
public UpdateCompetence(Competence_BO compBO)
{
InitializeComponent();
C1.Text = compBO.Competence;
listCategories = Appel_List.GetCategories();
C2.ItemsSource = listCategories;
C2.SelectedItem = compBO.Categorie;
listCompetences = Appel_List.GetCompetences();
C3.ItemsSource = listCompetences;
id = compBO.Id_Competence;
}
private void Creation_Click(object sender, RoutedEventArgs e)
{
var comp = new Competence_BO
{
Competence = C1.Text,
Categorie = C2.Text
};
MarcassinLightBLL.Create.CreateCompetence(comp);
this.NavigationService.Navigate(new Uri("Competences.xaml", UriKind.Relative));
}
private void Modification_Click(object sender, RoutedEventArgs e)
{
Competence_BO compBO = new Competence_BO
{
Competence = C1.Text,
Categorie = C2.Text,
Competence_mere = C3.Text,
Id_Competence = id
};
Update.UpdateCompetence(compBO);
this.NavigationService.Navigate(new Uri("Competences.xaml", UriKind.Relative));
}
public static Dictionary <string, string> GetTrad(Competence_BO compBO)
{
using (var db = new MarcassinEntities())
{
Dictionary <string, string> res = new Dictionary <string, string>();
List <Langue_Competence> langcomp = db.Langue_Competence.Where(l => l.id_Competence == compBO.Id_Competence).ToList();
foreach (var trad in langcomp)
{
string lang = db.Langue.Find(trad.id_Langue).Langue_intitule.ToString();
string traduction = trad.Traduction.ToString();
res.Add(lang, traduction);
}
return(res);
}
}
public static List <Competence_BO> ToListCompetenceBO(this List <Competence> list)
{
if (list == null)
{
return(null);
}
List <Competence_BO> listCompetenceBO = new List <Competence_BO>();
foreach (Competence cpt in list)
{
using (var db = new MarcassinEntities())
{
var comp = from lc in db.Langue_Competence
where lc.id_Competence == cpt.id_Competence && lc.id_Langue == 1
select lc.Traduction;
var compm = from lc in db.Langue_Competence
where lc.id_Competence == cpt.id_Competence_ref && lc.id_Langue == 1
select lc.Traduction;
var compme = "";
if (compm != null)
{
compme = compm.FirstOrDefault();
}
var bo = new Competence_BO
{
Id_Competence = cpt.id_Competence,
Id_Categorie = cpt.id_categorie,
Id_Competence_mere = cpt.id_Competence_ref,
Competence = comp.First(),
Categorie = cpt.Categorie.Intitule,
Competence_mere = compme,
Est_active = cpt.est_actif
};
listCompetenceBO.Add(bo);
}
}
return(listCompetenceBO);
}
public static void AddCompetence(Competence_BO compBO)
{
using (var db = new MarcassinEntities())
{
var cat = from ca in db.Categorie
where ca.Intitule == compBO.Categorie
select ca.id_Categorie;
Competence comp = new Competence
{
id_categorie = cat.FirstOrDefault(),
est_actif = true
};
db.Competence.Add(comp);
db.SaveChanges();
db.Langue_Competence.Add(new Langue_Competence
{
id_Competence = comp.id_Competence,
Traduction = compBO.Competence,
id_Langue = 1,
});
db.SaveChanges();
}
}
public static Dictionary <string, string> GetTradCompetence(Competence_BO compBO)
{
Dictionary <string, string> listTrad = LangueCompetence_DAL.GetTrad(compBO);
return(listTrad);
}
public static void CreateCompetence(Competence_BO compBO)
{
Competence_DAL.AddCompetence(compBO);
}
public static void UpdateCompetence(Competence_BO compBO)
{
Competence_DAL.UpdCompetence(compBO);
}
