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 static void UpdTrad(string[] trad) { using (var db = new MarcassinEntities()) { string intitulefr = trad[0]; string intitulelang = trad[1]; var req_id_comp = from lc in db.Langue_Competence where lc.Traduction == intitulefr select lc.id_Competence ; int id_comp = req_id_comp.FirstOrDefault(); Langue_Competence langcomp = db.Langue_Competence.Where(l => l.id_Competence == id_comp).Where(l => l.Langue.Langue_intitule == intitulelang).FirstOrDefault(); langcomp.Traduction = trad[2]; db.SaveChanges(); } }