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