/// <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();
}
}
