public List <Bookmark> GetBookmarks(int userId)
{
using (var ctx = new BookmarkContext(_connectionString))
{
return(ctx.Bookmarks.Where(b => b.UserId == userId).ToList());
}
}
public User GetByEmail(string email)
{
using (var ctx = new BookmarkContext(_connectionString))
{
return(ctx.Users.FirstOrDefault(u => u.Email == email));
}
}
public void DeleteBookmark(int bookmarkId)
{
using (var ctx = new BookmarkContext(_connectionString))
{
ctx.Database.ExecuteSqlInterpolated($"DELETE FROM Bookmarks WHERE Id = {bookmarkId}");
ctx.SaveChanges();
}
}
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 AddBookmark(Bookmark bookmark)
{
using (var ctx = new BookmarkContext(_connectionString))
{
ctx.Bookmarks.Add(bookmark);
ctx.SaveChanges();
}
}
public List <TopBookmark> GetTopFive()
{
var query = "SELECT TOP 5 Url, Count(*) AS 'Count' FROM Bookmarks GROUP BY Url ORDER BY COUNT(*) DESC";
using (var ctx = new BookmarkContext(_connectionString))
{
return(ctx.TopBookmarks.FromSqlRaw(query).ToList());
}
}
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();
}
}