public List <FifaModeles.QuartersModele> ListAll() { try { List <FifaModeles.QuartersModele> lQuarters = new List <FifaModeles.QuartersModele>(); using (FifaManagerEphecEntities ctx = new FifaManagerEphecEntities(_Connection)) { foreach (Quarters_GetAll_Result oQuart in ctx.Quarters_GetAll()) { FifaModeles.QuartersModele quarter = new FifaModeles.QuartersModele(); quarter.quartersId = oQuart.quartersId; quarter.dateDebut = oQuart.dateDebut; quarter.dateFin = oQuart.dateFin; quarter.lastUpdate = oQuart.lastUpdate; quarter.championnatId = oQuart.championnatId; lQuarters.Add(quarter); } } return(lQuarters); } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException is SqlException) { TechnicalError oErreur = new TechnicalError((SqlException)ex.InnerException); throw oErreur; } else { throw ex; } } }