public static long CreateVerse(VerseDTO verse)
{
Verses verses = new Verses();
verses.BeliefId = verse.BeliefId;
verses.Book = verse.Book;
verses.Chapter = verse.Chapter;
verses.VerseStart = verse.VerseStart;
verses.VerseEnd = verse.VerseEnd;
verses.Verse = verse.ToString();
context.Add <Verses>(verses);
context.SaveChanges();
return(verses.Id);
}
internal string GetVerseText(VerseDTO verse)
{
StringBuilder sb = new StringBuilder();
var conn = GetConnection();
var comm = new SqliteCommand($"SELECT verse, content FROM bible_fts WHERE book = '{Books.BookAbbrevArray[verse.Book]}' AND CAST(chapter AS int) = {verse.Chapter+1} AND CAST(verse AS int) >= {verse.VerseStart+1} and CAST(verse as int) <= {verse.VerseEnd+1}; ", conn);
var reader = comm.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
sb.Append("(" + reader.GetString(0) + ") ");
sb.Append(reader.GetString(1) + "\r\n");
}
}
sb.Append(" - " + verse.ToString());
return(sb.ToString());
}
public static bool UpdateVerse(VerseDTO verse)
{
var dbVerse = context.Verses.Where(x => x.Id == verse.Id).FirstOrDefault();
if (dbVerse == null)
{
return(false);
}
bool updated = false;
if (dbVerse.BeliefId != verse.BeliefId)
{
dbVerse.BeliefId = verse.BeliefId;
updated = true;
}
if (dbVerse.Book != verse.Book)
{
dbVerse.Book = verse.Book;
updated = true;
}
if (dbVerse.Chapter != verse.Chapter)
{
dbVerse.Chapter = verse.Chapter;
updated = true;
}
if (dbVerse.VerseStart != verse.VerseStart)
{
dbVerse.VerseStart = verse.VerseStart;
updated = true;
}
if (dbVerse.VerseEnd != verse.VerseEnd)
{
dbVerse.VerseEnd = verse.VerseEnd;
updated = true;
}
if (updated)
{
context.SaveChanges();
}
return(updated);
}
