private static int AddChapter(XDocument xml, int book_id)
{
using(var db = new Entities())
{
chapter chapter = new chapter();
chapter.book_id = book_id;
chapter.number = Int32.Parse(xml.Descendants("chapter").First().Attribute("id").Value);
db.chapter.Add(chapter);
db.SaveChanges();
return chapter.id;
}
}
private void FillSectionTable(Entities db)
{
db.section.Add(new section() { id = OLD_TEST, name = "Vana Testament" });
db.section.Add(new section() { id = NEW_TEST, name = "Uus Testament" });
db.section.Add(new section() { id = APOCRYPHA, name = "Apokrüüfid" });
db.SaveChanges();
}
private static void AddVerses(XDocument xml, int chapter_id)
{
using(var db = new Entities())
{
IEnumerable<XElement> verses = xml.Descendants("verse");
foreach (XElement v in verses)
{
db.verse.Add(new verse()
{
chapter_id = chapter_id,
number = Int32.Parse(v.Attribute("id").Value),
heading = v.Attribute("heading").Value.Replace("<br />", "; ").Replace("„", "\"").Replace("”", "\""),
content = StringTools.StripTagsCharArray(NormalizeWhiteSpace(v.Value.Replace("<br />", " ").Replace("„", "\"").Replace("”", "\"")))
});
}
db.SaveChanges();
}
}
private static int AddBook(int section_id, XDocument xml)
{
using(var db = new Entities())
{
book book = new book();
book.name = xml.Descendants("book").First().Attribute("title").Value;
book.name_short = xml.Descendants("book").First().Attribute("abbrev").Value;
book.section_id = section_id;
db.book.Add(book);
db.SaveChanges();
return book.id;
}
}