public ActionResult Verses(int id)
{
BibleTopicsViewModel btvm = new BibleTopicsViewModel();
btvm.TopicLetters = repo.GetAllTopicsInitialLetters();
int topicID = id;
string topicName = repo.GetTopicName(id);
ViewBag.TopicName = topicName;
ViewBag.PageName = "Verses for " + topicName;
btvm.VerseWithTopics = new Dictionary<Bible, List<Topic>>();
// Get bible verses for this topic
List<int> bibleIDs = repo.GetAllOrderedVersesByTopicID(topicID);
Bible verseTemp = new Bible();
List<int> topicIDs = new List<int>();
List<Topic> topicsTemp = new List<Topic>();
List<Topic> topicsAlphaTemp = new List<Topic>();
Topic sameTopicName;
foreach (int bibleID in bibleIDs)
{
verseTemp = repo.GetBible(bibleID);
topicIDs = repo.GetTopicIDsPerBibleID(verseTemp.ID);
foreach (int t_ID in topicIDs)
{
sameTopicName = repo.GetTopic(t_ID);
if (sameTopicName.Name == topicName)
continue;
topicsTemp.Add(repo.GetTopic(t_ID));
}
topicsAlphaTemp = topicsTemp.OrderBy(x => x.Name).ToList();
topicsTemp.Clear();
btvm.VerseWithTopics.Add(verseTemp, topicsAlphaTemp);
}
return View(btvm);
}
/// <summary>
/// Deprecated Method for adding a new object to the Bibles EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToBibles(Bible bible)
{
base.AddObject("Bibles", bible);
}
/// <summary>
/// Create a new Bible object.
/// </summary>
/// <param name="id">Initial value of the ID property.</param>
/// <param name="verse">Initial value of the Verse property.</param>
/// <param name="message">Initial value of the Message property.</param>
/// <param name="created">Initial value of the Created property.</param>
/// <param name="isValid">Initial value of the IsValid property.</param>
/// <param name="bookID">Initial value of the BookID property.</param>
public static Bible CreateBible(global::System.Int32 id, global::System.String verse, global::System.String message, global::System.DateTime created, global::System.Boolean isValid, global::System.Int32 bookID)
{
Bible bible = new Bible();
bible.ID = id;
bible.Verse = verse;
bible.Message = message;
bible.Created = created;
bible.IsValid = isValid;
bible.BookID = bookID;
return bible;
}
/// <summary>
/// Add a new verse
/// </summary>
/// <param name="topic">Bible entity</param>
public void AddNewVerse(Bible bible)
{
dbase.Bibles.AddObject(bible);
}