public void LikeDislikeJoke(int jokeId, int userId, bool status)
{
using (var context = new JokesContext(_connectionString))
{
var like = new UserLikedJokes
{
UserId = userId,
JokeId = jokeId,
Liked = status,
Date = DateTime.Now
};
if (DidUserLikeOrDislike(userId, jokeId))
{
context.Database.ExecuteSqlCommand(
"UPDATE UserLikedJokes SET Liked = @status WHERE UserId = @userId AND JokeId = @jokeId",
new SqlParameter("@status", status),
new SqlParameter("@userId", userId),
new SqlParameter("@jokeId", jokeId));
}
else
{
context.UserLikedJokes.Add(like);
}
context.SaveChanges();
}
}
public void AddJoke(Joke joke)
{
using (var context = new JokesContext(_connectionString))
{
context.Jokes.Add(joke);
context.SaveChanges();
}
}
public void AddUser(User user, string password)
{
user.Password = PasswordEncryption.HashPassword(password);
using (var context = new JokesContext(_connectionString))
{
context.Users.Add(user);
context.SaveChanges();
}
}