public IActionResult AllAnswerComment(int allCommentAnswerID, int allCommentQuestionId) { var user = HttpContext.User; var claim = user.Claims.First(c => c.Type == ClaimTypes.Email); var email = claim.Value; User searchedUser = _loader.GetUserList($"Select * FROM users WHERE email = '{email}'")[0]; IAnswer answer = _loader.GetAnswerList($"Select * from answer WHERE question_id = {Convert.ToString(allCommentQuestionId)} and answer_id = {Convert.ToString(allCommentAnswerID)}")[0]; LoggedUserIdentytyandModel model = new LoggedUserIdentytyandModel(searchedUser, answer); return(View("AllAnswerComments", model)); }
public IActionResult AllQuestionComment(int QuestionCommentID) { var user = HttpContext.User; var claim = user.Claims.First(c => c.Type == ClaimTypes.Email); var email = claim.Value; User searchedUser = _loader.GetUserList($"Select * FROM users WHERE email = '{email}'")[0]; QuestionModel questionModel = _loader.GetDataList($"Select * from question WHERE question_id = {Convert.ToString(QuestionCommentID)}")[0]; LoggedUserIdentytyandModel model = new LoggedUserIdentytyandModel(searchedUser, questionModel); return(View("AllComments", model)); }
public IActionResult QuestionDetails(int id) { var user = HttpContext.User; var claim = user.Claims.First(c => c.Type == ClaimTypes.Email); var email = claim.Value; User searchedUser = _loader.GetUserList($"Select * FROM users WHERE email = '{email}'")[0]; QuestionModel questionModel = _loader.GetDataList($"SELECT * FROM question WHERE question_id = {id};")[0]; questionModel.ViewNumber++; LoggedUserIdentytyandModel model = new LoggedUserIdentytyandModel(searchedUser, questionModel); return(View(model)); }
public IActionResult PostTheAnswerComment(int NewCommentedAnswerID, int necessaryQuestionID, [FromForm(Name = "username")] string username, [FromForm(Name = "comment")] string comment) { var user = HttpContext.User; var claim = user.Claims.First(c => c.Type == ClaimTypes.Email); var email = claim.Value; User searchedUser = _loader.GetUserList($"Select * FROM users WHERE email = '{email}'")[0]; _loader.InsertAnswerComment(NewCommentedAnswerID, comment, searchedUser.UserName, searchedUser.UserId); IAnswer answer = _loader.GetAnswerList($"SELECT * FROM answer WHERE question_id = {Convert.ToString(necessaryQuestionID)} and answer_id = {Convert.ToString(NewCommentedAnswerID)} ")[0]; LoggedUserIdentytyandModel model = new LoggedUserIdentytyandModel(searchedUser, answer); return(View("AllAnswerComments", model)); }