public UserLikedJoke GetUserLikedJoke(int userId, int jokeId)
{
using (var ctx = new JokesContext(_connectionString))
{
return(ctx.UserLikedJokes.FirstOrDefault(ulj => ulj.UserId == userId && ulj.JokeId == jokeId));
}
}
public List <Joke> GetAllJokes()
{
using (var ctx = new JokesContext(_connectionString))
{
return(ctx.Jokes.ToList());
}
}
public Joke GetByNumber(int number)
{
using (var ctx = new JokesContext(_connectionString))
{
return(ctx.Jokes.FirstOrDefault(j => j.Number == number));
}
}
public bool NewJoke(int number)
{
using (var ctx = new JokesContext(_connectionString))
{
return(ctx.Jokes.All(j => j.Number != number));
}
}
public User GetByEmail(string email)
{
using (var ctx = new JokesContext(_connectionString))
{
return(ctx.Users.FirstOrDefault(u => u.Email == email));
}
}
public void DeleteUserLikedJoke(int userId, int jokeId)
{
using (var ctx = new JokesContext(_connectionString))
{
ctx.Database.ExecuteSqlInterpolated($"DELETE FROM UserLikedJokes WHERE UserId = {userId} AND JokeId = {jokeId}");
ctx.SaveChanges();
}
}
public int GetLikesDislikesCount(int jokeId, bool liked)
{
using (var ctx = new JokesContext(_connectionString))
{
return(ctx.Jokes.FromSqlInterpolated
($"SELECT * FROM UserLikedJokes WHERE JokeId = {jokeId} and Liked = {liked}").Count());
}
}
public void LikeDislikeJoke(UserLikedJoke ulj)
{
using (var ctx = new JokesContext(_connectionString))
{
ctx.UserLikedJokes.Add(ulj);
ctx.SaveChanges();
}
}
public void AddUser(User user, string password)
{
user.PasswordHash = BCrypt.Net.BCrypt.HashPassword(password);
using (var ctx = new JokesContext(_connectionString))
{
ctx.Users.Add(user);
ctx.SaveChanges();
}
}
public void AddJoke(JokeResult jr)
{
using (var ctx = new JokesContext(_connectionString))
{
ctx.Jokes.Add(new Joke
{
Number = jr.Number,
Setup = jr.Setup,
Punchline = jr.Punchline
});
ctx.SaveChanges();
}
}
