public async Task <bool> UpdateQuestionFeedback(int userId, int questionId, QuestionFeedbackType feedback) { var answer = await _db.AnswerEntities.FirstOrDefaultAsync(x => x.UserId == userId && x.QuestionId == questionId); if (answer == null) { answer = new AnswerEntity { UserId = userId, QuestionId = questionId, FeedbackType = feedback, IsDeleted = false, AnswerType = AnswerType.NoAnswer, AnsweredDate = DateTime.UtcNow, IsFavorite = false, IsSaved = false }; _db.AnswerEntities.Add(answer); return(await _db.SaveChangesAsync() > 0); } answer.FeedbackType = feedback; return(await _db.SaveChangesAsync() > 0); }
public async Task <bool> UpdateCommentFeedback(int userId, int commentId, QuestionFeedbackType feedback) { return(await _db.Database.ExecuteSqlCommandAsync($"updateCommentFeedback {userId}, {commentId}, {feedback}") > 0); }