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 UserLikedJokes GetLike(int id, string email) { using (var context = new JokeContext(_connection)) { var userId = context.Users .FirstOrDefault(u => u.Email == email).Id; var jokeId = context.Jokes.FirstOrDefault(j => j.JokeId == id).Id; UserLikedJokes liked = context.UserLikedJokes .FirstOrDefault(ul => ul.JokeId == jokeId && ul.UserId == userId); return(liked); } }