static public bool InsertUnderlining(string BibleName, int Chapter, int Verse, string color)
{
Underlining Data = new Underlining();
Data.BibleName = BibleName;
Data.Chapter = Chapter;
Data.Verse = Verse;
Data.Color = color;
string DBPath = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.MyDocuments), "WBA.db");
var db = new SQLiteConnection(DBPath);
db.CreateTable <Underlining>();
var list = db.Query <Underlining>("select * from UnderliningRcord where BibleName = ? and Chapter = ? and Verse = ?", BibleName, Chapter, Verse);
if (list.Count == 0)
{
db.Insert(Data);
}
else
{
if (list?[0] != null)
{
list[0].Color = color;
db.Update(list[0]);
}
}
return(true);
}
static public bool DeleteUnderlining(string BibleName, int Chapter, int Verse, string color)
{
Underlining Data = new Underlining();
Data.BibleName = BibleName;
Data.Chapter = Chapter;
Data.Verse = Verse;
Data.Color = color;
string DBPath = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.MyDocuments), "WBA.db");
var db = new SQLiteConnection(DBPath);
db.CreateTable <Underlining>();
var list = db.Query <Underlining>("delete from UnderliningRcord where BibleName = ? and Chapter = ? and Verse = ?", BibleName, Chapter, Verse);
return(true);
}