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