C# (CSharp) CompteResultat.DAL CompteResultatEntities.SPGetSumPrestaForDossier Examples

Example #1

        public static double GetSumPrestaForDossierFromSP(string dossier, DateTime dateArret)
        {
            try
            {
                double sumPresta = 0;

                using (var context = new CompteResultatEntities())
                {
                    var res = context.SPGetSumPrestaForDossier(dossier, dateArret).FirstOrDefault();

                    if (res.HasValue)
                    {
                        sumPresta = res.Value;
                    }
                }

                return(sumPresta);
            }
            catch (Exception ex)
            {
                log.Error("Error :: GetSumPrestaForDossierFromSP : " + ex.Message);
                throw ex;
            }
        }