public void UpdateBookmark(Bookmark b) { using var context = new BookmarksDbContext(_connectionString); context.Bookmarks.Attach(b); context.Entry(b).State = EntityState.Modified; context.SaveChanges(); }
public void AddUser(User user, string password) { string hash = BCrypt.Net.BCrypt.HashPassword(password); using var ctx = new BookmarksDbContext(_connectionString); user.PasswordHash = hash; ctx.Users.Add(user); ctx.SaveChanges(); }
public List <PopularUrls> GetTop5Urls() { using var context = new BookmarksDbContext(_connectionString); return(context.Bookmarks.GroupBy(b => b.Url) .OrderByDescending(g => g.Count()).Take(5) .Select(g => new PopularUrls { Url = g.Key, Count = g.Count() }).ToList()); }
public void AddBookmark(Bookmark b) { using var context = new BookmarksDbContext(_connectionString); if (!context.Bookmarks.Where(bm => bm.UserId == b.UserId).Any(bm => bm.Url == b.Url)) { context.Bookmarks.Add(b); context.SaveChanges(); } }
public User GetByEmail(string email) { using var ctx = new BookmarksDbContext(_connectionString); return(ctx.Users.FirstOrDefault(u => u.Email == email)); }
public void DeleteBookmark(int id) { using var context = new BookmarksDbContext(_connectionString); context.Database.ExecuteSqlInterpolated($"DELETE FROM Bookmarks WHERE id={id}"); context.SaveChanges(); }
public List <Bookmark> GetUserBookmarks(int id) { using var context = new BookmarksDbContext(_connectionString); return(context.Bookmarks.Where(b => b.UserId == id).ToList()); }