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();
}
