public static BibleReferenceRange From(BibleReferenceParser.Data.BibleReferenceRange referenceRange) { var startReference = referenceRange.First; var endReference = referenceRange.Last == null ? referenceRange.First : referenceRange.Last; var model = new BibleReferenceRange(); model.StartBook = (int)startReference.Book; model.StartChapter = startReference.Chapter.GetValueOrDefault(1); model.StartVerse = startReference.Verse.GetValueOrDefault(1); model.EndBook = (int)endReference.Book; model.EndChapter = endReference.Chapter.GetValueOrDefault(BibleDetails.GetLastChapterForBook(endReference.Book)); model.EndVerse = endReference.Verse.GetValueOrDefault(BibleDetails.GetLastVerseForBookChapter(endReference.Book, model.EndChapter)); return(model); }
// Debug method private static void SeedDatabase(MessageContext context) { // Series var series0 = new Series(); series0.Name = "Series 0"; context.Series.Add(series0); var series1 = new Series(); series1.Name = "Series 1"; context.Series.Add(series1); context.SaveChanges(); // Playlists var playlist0 = new Playlist(); playlist0.YouTubePlaylistId = "abcdefghijklmnopqrstuvwxyz01234567"; playlist0.SeriesId = series0.Id; context.Playlist.Add(playlist0); context.SaveChanges(); // Messages for (var i = 1; i <= 10; ++i) { var message = new Message(); message.Title = "Message " + i; message.Description = "Description for message " + i; message.Date = new DateTime(i, i, i); message.SeriesId = series0.Id; context.Message.Add(message); context.SaveChanges(); if (i % 2 == 1) { var audio = new Audio(); audio.DownloadUrl = "http://dl.audio.com/" + i; audio.StreamUrl = "http://stream.audio.com/" + i; audio.MessageId = message.Id; context.Audio.Add(audio); var notes = new Notes(); notes.Url = "http://notes.com/" + i; notes.MessageId = message.Id; context.Notes.Add(notes); var video = new Video(); video.YouTubeVideoId = String.Format("Video{0:000000}", i); video.MessageStartTimeSeconds = i; video.MessageId = message.Id; context.Video.Add(video); var bibleReference0 = new BibleReferenceRange { StartBook = i, StartChapter = i, StartVerse = i * 2, EndBook = i, EndChapter = i, EndVerse = i * 2 }; context.BibleReferences.Add(bibleReference0); context.SaveChanges(); message.AudioId = audio.Id; message.NotesId = notes.Id; message.VideoId = video.Id; } } context.SaveChanges(); }