public List<BibleBookChapterVerse> GetVerses(string BookName, int chapter)
{
List<BibleBookChapterVerse> result = new List<BibleBookChapterVerse>();
BibleDB.americanDataTable dt = new BibleDB.americanDataTable();
americanTableAdapter tb = new americanTableAdapter();
tb.FillByBookChapter(dt, BookName, chapter);
result = dt.Select(i => new BibleBookChapterVerse()
{
BookName = (string)i["title"],
Chapter = (int)i["chapter"],
Verse = (int)i["verse"],
Text = (string)i["text"]
}).ToList();
return result;
}
public BibleBookChapterVerse GetVerse(string BookName, int chapter, int verse)
{
BibleBookChapterVerse result = new BibleBookChapterVerse();
BibleDB.americanDataTable dt = new BibleDB.americanDataTable();
americanTableAdapter tb = new americanTableAdapter();
tb.FillByBookChapterVerse(dt, BookName, chapter, verse);
result = dt.Select(i => new BibleBookChapterVerse()
{
BookName = (string)i["title"],
Chapter = (int)i["chapter"],
Verse = (int)i["verse"],
Text = (string)i["text"]
}).FirstOrDefault();
return result;
}
public List <BibleBookChapterVerse> GetVerses(string BookName, int chapter)
{
List <BibleBookChapterVerse> result = new List <BibleBookChapterVerse>();
BibleDB.americanDataTable dt = new BibleDB.americanDataTable();
americanTableAdapter tb = new americanTableAdapter();
tb.FillByBookChapter(dt, BookName, chapter);
result = dt.Select(i => new BibleBookChapterVerse()
{
BookName = (string)i["title"],
Chapter = (int)i["chapter"],
Verse = (int)i["verse"],
Text = (string)i["text"]
}).ToList();
return(result);
}
public BibleBookChapterVerse GetVerse(string BookName, int chapter, int verse)
{
BibleBookChapterVerse result = new BibleBookChapterVerse();
BibleDB.americanDataTable dt = new BibleDB.americanDataTable();
americanTableAdapter tb = new americanTableAdapter();
tb.FillByBookChapterVerse(dt, BookName, chapter, verse);
result = dt.Select(i => new BibleBookChapterVerse()
{
BookName = (string)i["title"],
Chapter = (int)i["chapter"],
Verse = (int)i["verse"],
Text = (string)i["text"]
}).FirstOrDefault();
return(result);
}