public IEnumerable <Joke> GetJokes()
{
using (var context = new JokesContext(_conn))
{
return(context.Jokes.Include(j => j.UserLikedJokes).ToList());
}
}
public User GetUserByEmail(string email)
{
using (var context = new JokesContext(_conn))
{
return(context.Users.FirstOrDefault(u => u.Email == email));
}
}
public bool DidUserDislike(int userId, int jokeId)
{
using (var context = new JokesContext(_conn))
{
return(context.UserLikedJokes.Any(l => l.UserId == userId &&
l.JokeId == jokeId &&
l.Liked == false));
}
}
public void UpdateLike(int userId, int jokeId, bool like)
{
using (var context = new JokesContext(_conn))
{
context.Database.ExecuteSqlCommand(
"UPDATE UserLikedJokes SET Liked=@liked WHERE JokeId=@jokeId AND UserId=@userId",
new SqlParameter("@liked", like),
new SqlParameter("@jokeId", jokeId),
new SqlParameter("@userId", userId));
}
}
public Joke GenerateRandomJoke()
{
using (var context = new JokesContext(_conn))
{
var client = new HttpClient();
string url = "https://official-joke-api.appspot.com/jokes/programming/random";
string json = client.GetStringAsync(url).Result;
var result = JsonConvert.DeserializeObject <IEnumerable <Joke> >(json).First();
context.Jokes.Add(result);
context.SaveChanges();
return(result);
}
}
public void AddUser(User u)
{
using (var context = new JokesContext(_conn))
{
var user = new User
{
Name = u.Name,
Email = u.Email,
Password = HashPassword(u.Password)
};
context.Users.Add(user);
context.SaveChanges();
}
}
public int GetDislikesByJokeId(int id)
{
using (var context = new JokesContext(_conn))
{
var dislikes = context.Jokes.Include(j => j.UserLikedJokes).FirstOrDefault(j => j.Id == id).UserLikedJokes.Where(ulj => ulj.Liked == false);
if (dislikes == null)
{
return(0);
}
else
{
return(dislikes.Count());
}
}
}
public bool CanStillLike(UserLikedJokes ulj)
{
using (var context = new JokesContext(_conn))
{
var like = context.UserLikedJokes.FirstOrDefault(l => l.UserId == ulj.UserId &&
l.JokeId == ulj.JokeId);
if (like != null)
{
return(like.Time.AddMinutes(5) > DateTime.Now);
}
else
{
return(true);
}
}
}
public void DislikeJoke(int userId, int jokeId)
{
using (var context = new JokesContext(_conn))
{
if (context.UserLikedJokes.Any(l => l.UserId == userId && l.JokeId == jokeId))
{
UpdateLike(userId, jokeId, false);
}
else
{
context.UserLikedJokes.Add(new UserLikedJokes
{
UserId = userId,
JokeId = jokeId,
//Liked = false,
Time = DateTime.Now
});
//UpdateLike(userId, jokeId, false);
context.SaveChanges();
UpdateLike(userId, jokeId, false);
}
}
}