Zbiór zmian 754 dla branches/Abonament/BazaReklam/Classes/Repositories/TitleRepository.cs

Data:

2009-07-17 16:17:17 (17 years ago)

Autor:

marek

Opis:

merged with latest trunk

Lokalizacja:

branches/Abonament

Pliki:

• . (zmodyfikowane) (1 prop)
• BazaReklam/Classes/Repositories/TitleRepository.cs (skopiowane) (skopiowane from trunk/BazaReklam/Classes/Repositories/TitleRepository.cs) (3 diffs)

branches/Abonament/BazaReklam/Classes/Repositories/TitleRepository.cs

@@ -8 +8 @@
     public class TitleRepository : Repository<Title>
     {
-        private readonly string _connectionString;
-
         public TitleRepository(string connectionString)
+            : base(connectionString)
         {
-            _connectionString = connectionString;
         }
 
@@ -21 +19 @@
             List<Title> titles = new List<Title>();
 
-            SqlConnection conn = null;
-            SqlCommand cmd = null;
-            SqlDataReader reader = null;
             try
             {
-                conn = new SqlConnection(_connectionString);
-                conn.Open();
-                cmd = new SqlCommand(query, conn);
-                reader = cmd.ExecuteReader();
-                if (reader != null)
+                _connection.Open();
+                _command = new SqlCommand(query, _connection);
+                _reader = _command.ExecuteReader();
+                if (_reader != null)
                 {
-                    while (reader.Read())
+                    while (_reader.Read())
                     {
-                        titles.Add(new Title(reader.GetInt32(0), reader.GetString(1), reader.GetString(2).Trim(), reader.GetDouble(3)));
+                        titles.Add(new Title(_reader.GetInt32(0), _reader.GetString(1), _reader.GetString(2).Trim(), _reader.GetDouble(3)));
                     }
                 }
@@ -40 +34 @@
             finally
             {
-                if (reader != null)
-                {
-                    reader.Close();
-                    reader.Dispose();
-                }
-                if (cmd != null) cmd.Dispose();
-                if (conn != null)
-                {
-                    conn.Close();
-                    conn.Dispose();
-                }
-
+               CleanUp();
             }
             return titles;
         }
+
+        public List<Section> FindSectionsByTitle(Title title)
+        {
+            SectionRepository sectionRepository = new SectionRepository(_connectionString);
+            return sectionRepository.FindAllActiveByTitle(title); 
+        }
     }
 }