public void AddQuestion(Question question, List <string> tagList) { using (var context = new QuestionTagContext(_connectionString)) { context.Questions.Add(question); context.SaveChanges(); foreach (string tag in tagList) { Tag t = GetTagByName(tag); int tagId; if (t == null) { tagId = AddTagAndReturnId(tag); } else { tagId = t.Id; } context.QuestionsTags.Add(new QuestionsTags { QuestionId = question.Id, TagId = tagId }); } context.SaveChanges(); } }
public void AddAnswer(Answer answer) { using (var context = new QuestionTagContext(_connectionString)) { context.Answers.Add(answer); context.SaveChanges(); } }
public void LikeQuestion(LikesQuestions lq) { using (var context = new QuestionTagContext(_connectionString)) { context.LikesQuestions.Add(new LikesQuestions { QuestionId = lq.QuestionId, UserId = lq.UserId }); context.SaveChanges(); } }
private int AddTagAndReturnId(string name) { using (var context = new QuestionTagContext(_connectionString)) { var tag = new Tag { Name = name }; context.Tags.Add(tag); context.SaveChanges(); return(tag.Id); } }
public void AddUser(string email, string password) { string hash = BCrypt.Net.BCrypt.HashPassword(password); User user = new User { Email = email, PasswordHash = hash }; using (var context = new QuestionTagContext(_connectionString)) { context.Users.Add(user); context.SaveChanges(); } }