fixed chapter retrieval

1 files changed, 27 insertions, 28 deletions

diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteChapterRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteChapterRepository.cs
index c9acc2172..ff97bc40c 100644
--- a/MediaBrowser.Server.Implementations/Persistence/SqliteChapterRepository.cs
+++ b/MediaBrowser.Server.Implementations/Persistence/SqliteChapterRepository.cs
@@ -99,22 +99,7 @@ namespace MediaBrowser.Server.Implementations.Persistence
                 {
                     while (reader.Read())
                     {
-                        var chapter = new ChapterInfo
-                        {
-                            StartPositionTicks = reader.GetInt64(0)
-                        };
-
-                        if (!reader.IsDBNull(1))
-                        {
-                            chapter.Name = reader.GetString(1);
-                        }
-
-                        if (!reader.IsDBNull(2))
-                        {
-                            chapter.ImagePath = reader.GetString(2);
-                        }
-
-                        yield return chapter;
+                        yield return GetChapter(reader);
                     }
                 }
             }
@@ -145,18 +130,7 @@ namespace MediaBrowser.Server.Implementations.Persistence
                 {
                     if (reader.Read())
                     {
-                        var chapter = new ChapterInfo
-                        {
-                            StartPositionTicks = reader.GetInt64(0),
-                            Name = reader.GetString(1)
-                        };
-
-                        if (!reader.IsDBNull(2))
-                        {
-                            chapter.ImagePath = reader.GetString(2);
-                        }
-
-                        return chapter;
+                        return GetChapter(reader);
                     }
                 }
                 return null;
@@ -164,6 +138,31 @@ namespace MediaBrowser.Server.Implementations.Persistence
         }
 
         /// <summary>
+        /// Gets the chapter.
+        /// </summary>
+        /// <param name="reader">The reader.</param>
+        /// <returns>ChapterInfo.</returns>
+        private ChapterInfo GetChapter(IDataReader reader)
+        {
+            var chapter = new ChapterInfo
+            {
+                StartPositionTicks = reader.GetInt64(0)
+            };
+
+            if (!reader.IsDBNull(1))
+            {
+                chapter.Name = reader.GetString(1);
+            }
+
+            if (!reader.IsDBNull(2))
+            {
+                chapter.ImagePath = reader.GetString(2);
+            }
+
+            return chapter;
+        }
+
+        /// <summary>
         /// Saves the chapters.
         /// </summary>
         /// <param name="id">The id.</param>