public void AddQuestion(Question question, List <string> tagTexts) { using var context = new QADbContext(_connectionString); context.Questions.Add(question); context.SaveChanges(); var tags = GetTags(); foreach (string tagText in tagTexts) { var tag = tags.FirstOrDefault(t => t.Name == tagText); if (tag == null) { tag = new Tag { Name = tagText }; context.Tags.Add(tag); } context.QuestionsTags.Add(new QuestionsTags { QuestionId = question.Id, Question = question, Tag = tag, TagId = tag.Id }); } context.SaveChanges(); }
public void AddUser(User user, string password) { user.PasswordHash = BCrypt.Net.BCrypt.HashPassword(password); using var context = new QADbContext(_connectionString); context.Users.Add(user); context.SaveChanges(); }
public void UpdateLikes(int id, User user) { using var context = new QADbContext(_connectionString); var like = new Likes { QuestionId = id, UserId = user.Id }; context.Likes.Add(like); context.SaveChanges(); }
public void AddAnswer(Answer answer) { using var context = new QADbContext(_connectionString); context.Answers.Add(answer); context.SaveChanges(); }