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();
}
