Example #1
0
 private void AddJokeToDB(Joke joke)
 {
     using (var ctx = new JokeContext(_connectionString))
     {
         ctx.Jokes.Add(joke);
         ctx.SaveChanges();
     }
 }
Example #2
0
 public int AddUser(User user)
 {
     using (var context = new JokeContext(_connectionString))
     {
         user.Password = BCrypt.Net.BCrypt.HashPassword(user.Password);
         context.Users.Add(user);
         context.SaveChanges();
     }
     return(user.Id);
 }
Example #3
0
        public void LikeDislikeJoke(Like like)
        {
            using (var ctx = new JokeContext(_connectionString))
            {
                if (!ctx.Likes.Any(l => l.JokeId == like.JokeId && l.UserId == like.UserId))
                {
                    ctx.Likes.Add(new Like
                    {
                        UserId    = like.UserId,
                        JokeId    = like.JokeId,
                        DateLiked = DateTime.Now,
                        Liked     = like.Liked
                    });
                }

                UpdateLike(like);
                ctx.SaveChanges();
            }
        }