public void AddUser(User user, string password) { using var ctx = new QuestionTagsContext(_connectionString); user.HashedPassword = BCrypt.Net.BCrypt.HashPassword(password); ctx.Users.Add(user); ctx.SaveChanges(); }
public void AddQuestion(Question q, List <string> tags) { using var ctx = new QuestionTagsContext(_connectionString); ctx.Questions.Add(q); ctx.SaveChanges(); foreach (string tag in tags) { Tag t = GetTag(tag); int tagId; if (t == null) { tagId = AddTag(tag); } else { tagId = t.Id; } ctx.QuestionsTags.Add(new QuestionTags { QuestionId = q.Id, TagId = tagId }); } }
private int AddTag(string name) { using var ctx = new QuestionTagsContext(_connectionString); var tag = new Tag { Name = name }; ctx.Tags.Add(tag); ctx.SaveChanges(); return(tag.Id); }
public void UpdateLike(int id, User user) { using var ctx = new QuestionTagsContext(_connectionString); var like = new Likes { QuestionId = id, UserId = user.ID }; ctx.Likes.Add(like); ctx.SaveChanges(); }
public void AddAnswer(Answer answer) { using var ctx = new QuestionTagsContext(_connectionString); ctx.Answers.Add(answer); ctx.SaveChanges(); }