public void UpdateBookmark(string newTitle, int bookmarkId)
{
using (var ctx = new BookmarkContext(_connectionString))
{
ctx.Database.ExecuteSqlInterpolated($"UPDATE Bookmarks SET Title = {newTitle} WHERE Id = {bookmarkId}");
ctx.SaveChanges();
}
}
public void DeleteBookmark(int bookmarkId)
{
using (var ctx = new BookmarkContext(_connectionString))
{
ctx.Database.ExecuteSqlInterpolated($"DELETE FROM Bookmarks WHERE Id = {bookmarkId}");
ctx.SaveChanges();
}
}
public void AddBookmark(Bookmark bookmark)
{
using (var ctx = new BookmarkContext(_connectionString))
{
ctx.Bookmarks.Add(bookmark);
ctx.SaveChanges();
}
}
public void AddUser(User user, string password)
{
user.PasswordHash = BCrypt.Net.BCrypt.HashPassword(password);
using (var ctx = new BookmarkContext(_connectionString))
{
ctx.Users.Add(user);
ctx.SaveChanges();
}
}
