public static void Remove_FavoriteItem(FavDataSQL starred)
{
using (var db = new SQLite.SQLiteConnection(SQLDBPath))
{
SQLiteCommand cmd = db.CreateCommand(string.Format("DELETE from FavDataSQL WHERE FavID = {0}", starred.FavID));
List <FavDataSQL> result = cmd.ExecuteQuery <FavDataSQL>();
}
}
public static void Insert_FavoriteItem(FavDataSQL fav)
{
if (SQLDBPath == null)
{
throw new Exception("SQL is not init yet, please call 'LoadSQLTableData()'.");
}
using (SQLiteConnection db = new SQLiteConnection(SQLDBPath))
{
SQLiteCommand cmd = db.CreateCommand(string.Format("SELECT * from FavDataSQL WHERE FavID='{0}' LIMIT 1", fav.FavID));
List <FavDataSQL> result = cmd.ExecuteQuery <FavDataSQL>();
if (result.Count == 0)
{
db.RunInTransaction(() =>
{
db.Insert(fav);
});
}
}
}
