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