public static ITLang getInfoItLang(int identifiant)
{
List <Dictionary <string, object> > infoUnelang = GestionConnexion.Instance.getData("Select * from ITLang where idIT= " + identifiant);
ITLang l = Associe(infoUnelang[0]);
return(l);
}
private static ITLang Associe(Dictionary <string, object> infoUnelang)
{
ITLang itl = new ITLang();
itl.IdIT = (int)infoUnelang["idIT"];
itl.ITLabel = infoUnelang["ITLabel"].ToString();
return(itl);
}
private static ITLang Associe(Dictionary <string, object> item)
{
ITLang lang = new ITLang()
{
IdIT = int.Parse(item["idIT"].ToString()),
ITLabel = item["ITLabel"].ToString()
};
return(lang);
}
private List <ITLang> ChargerLesITLangs()
{
string query = @"select i.idIT,i.ITLabel from ITLang i
inner join DevLang d
on d.idIT = i.idIT
where d.Developer =" + this.IdDev;
List <ITLang> retour = new List <ITLang>();
List <Dictionary <string, object> > MesLangs = GestionConnexion.Instance.getData(query);
foreach (Dictionary <string, object> item in MesLangs)
{
ITLang l = new ITLang();
l.IdIT = (int)item["idIT"];
l.ITLabel = item["ITLabel"].ToString();
retour.Add(l);
}
return(retour);
}