public static double GetSumPrestaAnnualizedFromSP(string dossier, DateTime dateArret) { try { double sumPresta = 0; using (var context = new CompteResultatEntities()) { var res = context.SPGetSumPrestaAnnualized(dossier, dateArret).FirstOrDefault(); if (res.HasValue) { sumPresta = res.Value; } } return(sumPresta); } catch (Exception ex) { log.Error("Error :: GetSumPrestaAnnualizedFromSP : " + ex.Message); throw ex; } }