public static void InsertBookmark(bookmarkext item)
{
try
{
var connection = new SQLiteConnection(Conn);
connection.Open();
string sql = string.Format("insert into bookmark (title, juz,surah,ayah) values ('{0}',{1},{2},{3})", item.title, item.juz, item.surah, item.ayah);
SQLiteCommand command = new SQLiteCommand(sql, connection);
command.ExecuteNonQuery();
connection.Close();
}
catch
{
throw;
}
}
public static void DeleteBookmark(bookmarkext item)
{
try
{
var connection = new SQLiteConnection(Conn);
connection.Open();
string sql = string.Format("delete from bookmark where idx = {0}", item.idx);
SQLiteCommand command = new SQLiteCommand(sql, connection);
command.ExecuteNonQuery();
connection.Close();
}
catch
{
throw;
}
}
