public void UpdateLike(int id, bool liked, string email)
{
using (var context = new JokeContext(_connection))
{
var userLike = new UserLikedJokes
{
UserId = context.Users
.FirstOrDefault(u => u.Email == email).Id,
JokeId = context.Jokes
.FirstOrDefault(j => j.JokeId == id).Id,
Liked = liked,
Date = DateTime.Parse(DateTime.Now.ToShortDateString())
};
if (context.UserLikedJokes.
Any(ul => ul.UserId == userLike.UserId && ul.JokeId == userLike.JokeId))
{
context.UserLikedJokes.Attach(userLike);
context.Entry(userLike).State = EntityState.Modified;
}
else
{
context.UserLikedJokes.Add(userLike);
}
context.SaveChanges();
}
}
public void AddUser(User user, string password)
{
string hashedpassword = BCrypt.Net.BCrypt.HashPassword(password);
using (var context = new JokeContext(_connection))
{
user.HashedPassword = hashedpassword;
context.Users.Add(user);
context.SaveChanges();
}
}
public void AddJokes(List <Joke> jokes)
{
using (var context = new JokeContext(_connection))
{
var alljokes = context.Jokes.ToList();
foreach (Joke j in jokes)
{
if (!alljokes.Any(jk => jk.JokeId == j.JokeId))
{
context.Jokes.Add(j);
}
}
context.SaveChanges();
}
}
