public IEnumerable <Joke> GetAllJokes()
{
using (var ctx = new JokeContext(_connectionString))
{
return(ctx.Jokes.Include(j => j.Likes).ToList());
}
}
public bool AlreadyLiked(Like like, bool liked)
{
using (var ctx = new JokeContext(_connectionString))
{
return(ctx.Likes.Any(l => l.UserId == like.UserId && l.JokeId == like.JokeId && l.Liked == liked));
}
}
public Like GetLikeInfo(Like like)
{
using (var ctx = new JokeContext(_connectionString))
{
return(ctx.Likes.FirstOrDefault(l => l.UserId == like.UserId && l.JokeId == like.JokeId));
}
}
public User GetUserByEmail(string email)
{
using (var context = new JokeContext(_connectionString))
{
return(context.Users.Include(u => u.Likes).FirstOrDefault(u => u.Email == email));
}
}
private void AddJokeToDB(Joke joke)
{
using (var ctx = new JokeContext(_connectionString))
{
ctx.Jokes.Add(joke);
ctx.SaveChanges();
}
}
public void ChangeToLikeJoke(int jokeId, int userId)
{
using (var context = new JokeContext(_connectionString))
{
context.Database.ExecuteSqlCommand(
"UPDATE Likes SET Liked = 'true' WHERE UserId = @userid AND JokeId = @jokeid",
new SqlParameter("@userid", userId), new SqlParameter("@jokeid", jokeId));
}
}
public void UpdateLike(Like like)
{
using (var ctx = new JokeContext(_connectionString))
{
ctx.Database.ExecuteSqlCommand(
"UPDATE Likes SET Liked = @liked WHERE UserId = @id AND JokeId = @jokeid",
new SqlParameter("@id", like.UserId), new SqlParameter("@jokeid", like.JokeId), new SqlParameter("@liked", like.Liked));
}
}
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);
}
public bool LoginVerify(User user)
{
using (var context = new JokeContext(_connectionString))
{
User u = GetUserByEmail(user.Email);
bool verify = false;
if (u != null)
{
verify = BCrypt.Net.BCrypt.Verify(user.Password, u.Password);
}
return(verify);
}
}
//public bool AlreadyDisliked(Like like)
//{
// using (var ctx = new JokeContext(_connectionString))
// {
// return ctx.Likes.Any(l => l.UserId == like.UserId && l.JokeId == like.JokeId && l.Liked == false);
// }
//}
public bool CanStillLike(Like like)
{
using (var context = new JokeContext(_connectionString))
{
Like li = context.Likes.FirstOrDefault(l => l.UserId == like.UserId && l.JokeId == like.JokeId);
if (li != null)
{
return(li.DateLiked.AddMinutes(5) > DateTime.Now);
}
else
{
return(true);
}
}
}
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();
}
}