public User GetByEmail(string email)
{
using (var context = new UserBookmarkContext(_connectionString))
{
return(context.Users.FirstOrDefault(u => u.Email == email));
}
}
//Account repo
public List <Bookmark> GetBookmarks()
{
using (var context = new UserBookmarkContext(_connectionString))
{
return(context.Bookmarks.ToList());
}
}
public List <Bookmark> BookmarksForUser(string email)
{
using (var context = new UserBookmarkContext(_connectionString))
{
User user = GetByEmail(email);
return(context.Bookmarks.Where(u => u.UserId == user.Id).ToList());
}
}
public bool EmailAvailable(string email)
{
using (var context = new UserBookmarkContext(_connectionString))
{
bool isUsed = context.Users.Any(u => u.Email == email);
return(isUsed);
}
}
public void DeleteBookmark(Bookmark bookmark)
{
using (var context = new UserBookmarkContext(_connectionString))
{
context.Bookmarks.Remove(bookmark);
context.SaveChanges();
}
}
public void UpdateBookmark(Bookmark bookmark)
{
using (var context = new UserBookmarkContext(_connectionString))
{
context.Bookmarks.Attach(bookmark);
context.Entry(bookmark).State = EntityState.Modified;
context.SaveChanges();
}
}
public void AddUser(User user, string password)
{
string hash = BCrypt.Net.BCrypt.HashPassword(password);
user.PasswordHash = hash;
using (var context = new UserBookmarkContext(_connectionString))
{
context.Users.Add(user);
context.SaveChanges();
}
}
//Bookmark repo
public List <TopBookmark> GetTopBookMarkUrls()
{
using (var context = new UserBookmarkContext(_connectionString))
{
return(context.Bookmarks.GroupBy(b => b.URL)
.OrderByDescending(b => b.Count()).Take(5)
.Select(i => new TopBookmark
{
Url = i.First().URL,
Count = i.Count()
})
.ToList());
}
}