HBS.Data.Concrete.AdminRepository.GetModules C# (CSharp) Méthode

        public List<Module> GetModules()
        {
            List<Module> lstModules = null;
            Module module = null;
            using (var conn = new SqlConnection(PrescienceRxConnectionString))
            {
                conn.Open();
                using (var cmd = new SqlCommand(GetModulesSp, conn))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    using (var myReader = cmd.ExecuteReader())
                    {
                        try
                        {
                            if (myReader.HasRows)
                            {
                                lstModules = new List<Module>();
                                while (myReader.Read())
                                {
                                    module = new Module(myReader);
                                    lstModules.Add(module);
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            // TODO Logg Error here
                        }
                    }
                }

            }

            return lstModules;
        }