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(); } }