public void AddQuestion(Question q, List <string> tags) { using var context = new QADbContext(_connectionString); context.Questions.Add(q); context.SaveChanges(); foreach (string name in tags) { Tag t = GetTag(name); int tagId; if (t == null) { tagId = AddTag(name); } else { tagId = t.Id; } context.QuestionsTags.Add(new QuestionsTags() { QuestionId = q.Id, TagId = tagId }); } context.SaveChanges(); }
public void AddUser(User u, string password) { u.PasswordHash = BCrypt.Net.BCrypt.HashPassword(password); using var context = new QADbContext(_connectionString); context.Users.Add(u); context.SaveChanges(); }
public void AddLike(int questionId, int userId) { using var context = new QADbContext(_connectionString); context.Likes.Add(new Likes { QuestionId = questionId, UserId = userId }); context.SaveChanges(); }
private int AddTag(string name) { using var context = new QADbContext(_connectionString); Tag t = new Tag() { Name = name }; context.Tags.Add(t); context.SaveChanges(); return(t.Id); }
public void AddAnswer(Answer a) { using var context = new QADbContext(_connectionString); context.Answers.Add(a); context.SaveChanges(); }