public bool saveAnswer(int question, Answer answer) { var dbAnswer = new DBAnswer { Answer = answer.Text, }; DBQnA dbQnA = _context.DBQnAs.Find(question); if (dbQnA == null) { return(false); } try { _context.Answers.Add(dbAnswer); dbAnswer.QnA = dbQnA; _context.SaveChanges(); answer.Id = dbAnswer.Id; } catch (Exception ex) { return(false); } return(true); }
public bool delete(int id) { try { DBQnA foundQnA = _context.DBQnAs.Find(id); _context.DBQnAs.Remove(foundQnA); _context.SaveChanges(); } catch (Exception feil) { return(false); } return(true); }
public bool save(QnA qna) { var dbQnA = new DBQnA { Question = qna.Text }; try { _context.DBQnAs.Add(dbQnA); _context.SaveChanges(); qna.Id = dbQnA.Id; } catch (Exception ex) { return(false); } return(true); }
public QnA get(int id) { DBQnA dnQnA = _context.DBQnAs.FirstOrDefault(q => q.Id == id); var qna = new QnA { Id = dnQnA.Id, Text = dnQnA.Question, Upvotes = dnQnA.Upvotes, Downvotes = dnQnA.Downvotes, Answers = _context.Answers.Where(a => a.QnA.Id == dnQnA.Id).Select(a => new Answer { Id = a.Id, Text = a.Answer, Upvotes = a.Upvotes }).ToList() }; return(qna); }
public bool downvoteQuestion(int id) { DBQnA foundQnA = _context.DBQnAs.Find(id); if (foundQnA == null) { return(false); } foundQnA.Downvotes++; try { _context.SaveChanges(); } catch (Exception feil) { return(false); } return(true); }