public static string GetNameDisciplineBySeanceID(long id)
{
dbAssoSportEntities db = new dbAssoSportEntities();
long dis_id = db.section.Find(id).discipline_id;
return(db.discipline.Find(dis_id).discipline_nom);
}
public static string FindFullTitleById(long section_id)
{
dbAssoSportEntities db = new dbAssoSportEntities();
section s = db.section.Find(section_id);
discipline d = db.discipline.Find(s.discipline_id);
return(d.discipline_nom + " - " + s.section_nom);
}
public static section FindSectionById(long?id)
{
if (id.HasValue)
{
dbAssoSportEntities db = new dbAssoSportEntities();
return(db.section.Find(id));
}
return(null);
}
public static string FindDisciplineNameById(long?id)
{
if (id.HasValue)
{
dbAssoSportEntities db = new dbAssoSportEntities();
return(db.discipline.Find(id).discipline_nom);
}
return("empty");
}
public static string FindSectionNameById(long?id)
{
if (id.HasValue)
{
dbAssoSportEntities db = new dbAssoSportEntities();
return(db.section.Find(id).section_nom);
}
return("empty");
}
public static string FindLieuFullNameById(long?id)
{
if (id.HasValue)
{
dbAssoSportEntities db = new dbAssoSportEntities();
lieu l = db.lieu.Find(id);
return(l.lieu_nom);
}
return("non affecté");
}
public static string FindUserFullNameById(long?id)
{
if (id.HasValue)
{
dbAssoSportEntities db = new dbAssoSportEntities();
utilisateur u = db.utilisateur.Find(id);
return(u.prenom + ' ' + u.nom);
}
return("non affecté");
}
public static long GetIdByUserName(string login)
{
dbAssoSportEntities db = new dbAssoSportEntities();
foreach (utilisateur u in db.utilisateur)
{
if (u.login == login)
{
return(u.utilisateur_id);
}
}
return(0);
}
public static utilisateur FindUserByLogin(string login)
{
dbAssoSportEntities db = new dbAssoSportEntities();
foreach (utilisateur u in db.utilisateur)
{
if (u.login == login)
{
return(u);
}
}
return(new utilisateur());
}
public static string GetNameSectionByID(long id)
{
dbAssoSportEntities db = new dbAssoSportEntities();
return(db.section.Find(id).section_nom);
}
