/// <summary> /// Adds a categorie in database /// Simon-HUET /// </summary> /// <param name="catBO">Categorie to add</param> public static void AddCategorie(Categorie_BO catBO) { using (var db = new MarcassinEntities()) { var catMere = from ca in db.Categorie where ca.Intitule == catBO.Categorie_mere select ca.id_Categorie; int?id_Cat_Mere = catMere.FirstOrDefault(); if (catMere.FirstOrDefault() == 0) { id_Cat_Mere = null; } var cat = new Categorie { id_Categorie_Mere = id_Cat_Mere, Intitule = catBO.Intitule, }; Console.Write(cat); db.Categorie.Add(cat); db.SaveChanges(); db.Categorie_Langue.Add(new Categorie_Langue { Id_Categorie = cat.id_Categorie, Traduction = catBO.Intitule, id_Langue = 1, }); db.SaveChanges(); } }
public static List <LangueCategorie_BO> GetLangueCategoriesByIdCategorie(Categorie_BO Categorie) { using (var context = new MarcassinEntities()) { var listLangueCategorie = from lanComp in context.Categorie_Langue where lanComp.Id_Categorie == Categorie.Id_Categorie select lanComp; List <LangueCategorie_BO> listLangueCategorieBO = new List <LangueCategorie_BO>(); foreach (Categorie_Langue catLan in listLangueCategorie) { var lan = from la in context.Langue where la.id_Langue == catLan.id_Langue select la.Langue_intitule; var obj = new LangueCategorie_BO { Categorie = Categorie.Intitule, Id_Categorie = Categorie.Id_Categorie, Id_Langue = catLan.id_Langue, Langue = lan.FirstOrDefault(), Traduction = catLan.Traduction }; listLangueCategorieBO.Add(obj); } return(listLangueCategorieBO); } }
public static void AddLangueCategories(LangueCategorie_BO langCatBO) { using (var db = new MarcassinEntities()) { var catId = from ca in db.Categorie where ca.Intitule == langCatBO.Categorie select ca.id_Categorie; var LangId = from la in db.Langue where la.Langue_intitule == langCatBO.Langue select la.id_Langue; var langCompDb = from laC in db.Categorie_Langue where laC.id_Langue == langCatBO.Id_Langue & laC.Id_Categorie == langCatBO.Id_Categorie select laC.Id_Categorie; Categorie_Langue lanCat = new Categorie_Langue { Id_Categorie = catId.FirstOrDefault(), id_Langue = LangId.FirstOrDefault(), Traduction = langCatBO.Traduction }; // if traduction already exists if (langCompDb.Count() == 0) { db.Categorie_Langue.Add(lanCat); } db.SaveChanges(); } }
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 List <Categorie_BO> ToListCategorieBO(this List <Categorie> list) { if (list == null) { return(null); } List <Categorie_BO> listCategorieBO = new List <Categorie_BO>(); foreach (Categorie cat in list) { using (var db = new MarcassinEntities()) { var cate = from c in db.Categorie where c.id_Categorie == cat.id_Categorie_Mere select c.Intitule; var catme = "Aucune catégorie mère"; if (cate != null) { catme = cate.FirstOrDefault(); } var bo = new Categorie_BO { Id_Categorie = cat.id_Categorie, Id_Categorie_mere = cat.id_Categorie_Mere, Categorie_mere = catme, Intitule = cat.Intitule }; listCategorieBO.Add(bo); } } return(listCategorieBO); }
public static List <LangueCategorie_BO> GetLangueCategories() { using (var context = new MarcassinEntities()) { List <Categorie_Langue> listLangueCategorie = context.Categorie_Langue.ToList(); List <LangueCategorie_BO> listLangueCategorieBO = listLangueCategorie.ToListLangueCategorieBO(); return(listLangueCategorieBO); } }
public static List <Competence_BO> GetCompetence() { using (var context = new MarcassinEntities()) { List <Competence> listCompetences = context.Competence.ToList(); List <Competence_BO> listCompetencesBO = listCompetences.ToListCompetenceBO(); return(listCompetencesBO); } }
public static List <Langue_Badge_BO> GetTraductionBadge() { using (var context = new MarcassinEntities()) { List <Langue_Badge> listLangueBadge = context.Langue_Badge.ToList(); List <Langue_Badge_BO> listLangueBadgeBO = listLangueBadge.ToListLangueBadgeBO(); return(listLangueBadgeBO); } }
public static List <Langue_BO> GetLangue() { using (var context = new MarcassinEntities()) { List <Langue> listLangues = context.Langue.ToList(); List <Langue_BO> listLanguesBO = listLangues.ToListLangueBO(); return(listLanguesBO); } }
public static List <Badge_BO> GetBadge() { using (var context = new MarcassinEntities()) { List <Badge> listBadges = context.Badge.ToList(); List <Badge_BO> listBadgesBO = listBadges.ToListBadgeBO(); return(listBadgesBO); } }
public static List <Categorie_BO> GetCategorie() { using (var context = new MarcassinEntities()) { List <Categorie> listCategories = context.Categorie.ToList(); List <Categorie_BO> listCategoriesBO = listCategories.ToListCategorieBO(); return(listCategoriesBO); } }
public static void AddBadge(Badge_BO badgBO) { using (var db = new MarcassinEntities()) { db.Badge.Add(new Badge { nom = badgBO.Intitule }); db.SaveChanges(); } }
public static void UpdBadge(Badge_BO badBO) { using (var db = new MarcassinEntities()) { Badge badg = db.Badge.Where(b => b.id_Badge == badBO.Id_Badge).FirstOrDefault(); badg.nom = badBO.Intitule; db.SaveChanges(); Langue_Badge lanbad = db.Langue_Badge.Where(lb => lb.id_Badge == badBO.Id_Badge) .Where(lb => lb.Traduction == badBO.Intitule).Where(lb => lb.id_Langue == 1).FirstOrDefault(); db.SaveChanges(); } }
public static void AddTrad(int id_comp, string lang, string trad) { using (var db = new MarcassinEntities()) { db.Langue_Competence.Add(new Langue_Competence { id_Competence = id_comp, id_Langue = db.Langue.Where(l => l.Langue_intitule == lang).Select(l => l.id_Langue).FirstOrDefault(), Traduction = trad }); db.SaveChanges(); } }
public static void AddLangue(Langue_BO langBO) { using (var db = new MarcassinEntities()) { db.Langue.Add(new Langue { Langue_intitule = langBO.Intitule }); db.SaveChanges(); } }
public static void UpdLangueBadge(Langue_Badge_BO lanBad) { using (var db = new MarcassinEntities()) { int id_langue = db.Langue.Where(l => l.Langue_intitule == lanBad.Langue).Select(l => l.id_Langue).FirstOrDefault(); Langue_Badge laBa = db.Langue_Badge.Where(lb => lb.id_Langue == id_langue).Where(lb => lb.id_Badge == lanBad.Badge) .FirstOrDefault(); laBa.Traduction = lanBad.Traduction; db.SaveChanges(); } }
/// <summary> /// Adds a categorie in database /// Simon-HUET /// </summary> /// <param name="catLanBO">Categorie langue to add</param> public static void AddCategorieLangue(CategorieLangue_BO catLanBO) { using (var db = new MarcassinEntities()) { var catLan = new Categorie_Langue { Id_Categorie = catLanBO.Id_Categorie, id_Langue = catLanBO.id_Langue, Traduction = catLanBO.Traduction }; db.Categorie_Langue.Add(catLan); db.SaveChanges(); } }
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 void UpdLangueCategorie(LangueCategorie_BO lanCatBO) { using (var db = new MarcassinEntities()) { var lanCat = from ca in db.Langue where ca.Langue_intitule == lanCatBO.Langue select ca.id_Langue; lanCatBO.Id_Langue = lanCat.FirstOrDefault(); Categorie_Langue catLan = db.Categorie_Langue.Where(lc => lc.Id_Categorie == lanCatBO.Id_Categorie).Where( l => l.id_Langue == lanCatBO.Id_Langue).FirstOrDefault(); catLan.Traduction = lanCatBO.Traduction; 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(); } }
public static void UpdCategorie(Categorie_BO catBO) { using (var db = new MarcassinEntities()) { var catMere = from ca in db.Categorie where ca.Intitule == catBO.Categorie_mere select ca.id_Categorie; int?id_Cat_Mere = catMere.FirstOrDefault(); if (catMere.FirstOrDefault() == 0) { id_Cat_Mere = null; } Categorie cat = db.Categorie.Find(catBO.Id_Categorie); cat.Intitule = catBO.Intitule; cat.id_Categorie_Mere = id_Cat_Mere; db.SaveChanges(); } }
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 List <Langue_Badge_BO> GetTraductionByBadge(Badge_BO bad) { List <Langue_Badge_BO> bla = new List <Langue_Badge_BO>(); using (var db = new MarcassinEntities()) { var trad = from tra in db.Langue_Badge where tra.id_Badge == bad.Id_Badge join lan in db.Langue on tra.id_Langue equals lan.id_Langue select tra; foreach (var item in trad) { bla.Add(new Langue_Badge_BO { Traduction = item.Traduction, Langue = item.Langue.Langue_intitule, Badge = item.id_Badge }); } } return(bla); }
public static List <Badge_BO> ToListBadgeBO(this List <Badge> list) { if (list == null) { return(null); } List <Badge_BO> listBadgeBO = new List <Badge_BO>(); foreach (Badge bad in list) { using (var db = new MarcassinEntities()) { var bo = new Badge_BO { Id_Badge = bad.id_Badge, Intitule = bad.nom }; listBadgeBO.Add(bo); } } return(listBadgeBO); }
public static List <Langue_BO> ToListLangueBO(this List <Langue> list) { if (list == null) { return(null); } List <Langue_BO> listLangueBO = new List <Langue_BO>(); foreach (Langue lan in list) { using (var db = new MarcassinEntities()) { var bo = new Langue_BO { Id_Langue = lan.id_Langue, Intitule = lan.Langue_intitule, Par_Defaut = lan.Par_Defaut }; listLangueBO.Add(bo); } } return(listLangueBO); }
public static List <Categorie_BO> ToListCategorieBO(this List <Categorie> list) { if (list == null) { return(null); } List <Categorie_BO> listCategorieBO = new List <Categorie_BO>(); foreach (Categorie cat in list) { using (var db = new MarcassinEntities()) { var bo = new Categorie_BO { Id_Categorie = cat.id_Categorie, Id_Categorie_mere = cat.id_Categorie_Mere, Intitule = cat.Intitule }; listCategorieBO.Add(bo); } } return(listCategorieBO); }
public static List <Langue_Badge_BO> ToListLangueBadgeBO(this List <Langue_Badge> list) { if (list == null) { return(null); } List <Langue_Badge_BO> listLangueBadgeBO = new List <Langue_Badge_BO>(); foreach (Langue_Badge lanbad in list) { using (var db = new MarcassinEntities()) { var bo = new Langue_Badge_BO { Traduction = lanbad.Traduction, Langue = lanbad.Langue.Langue_intitule, Id_Langue = lanbad.id_Langue }; listLangueBadgeBO.Add(bo); } } return(listLangueBadgeBO); }
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(); } }