public QuestionGetSingleResponse PostQuestion(QuestionPostFullRequest question)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
var questionId = connection.QueryFirst <int>(@"EXEC dbo.Question_Post @Title = @Title, @Content = @Content, @UserId = @UserId, @UserName = @UserName, @Created = @Created",
question
);
return(GetQuestion(questionId));
}
}
public async Task <QuestionGetSingleResponse> PostQuestion(QuestionPostFullRequest question)
{
await using var connection = new SqlConnection(_connectionString);
await connection.OpenAsync();
var questionId = await connection.QueryFirstAsync <int>(
@"exec dbo.Question_Post @Title = @Title,
@Content = @Content, @UserId = @UserId, @UserName = @UserName, @Created = @Created", question);
return(await GetQuestion(questionId));
}
public async Task <ActionResult <QuestionGetSingleResponse> > CreatePost(QuestionPostFullRequest questionPost)
{
var result = await _dataRepository.PostQuestionAsync(new QuestionPostFullRequest
{
Title = questionPost.Title,
Content = questionPost.Content,
UserId = User.FindFirst(ClaimTypes.NameIdentifier).Value,
UserName = questionPost.UserName,
Created = DateTime.UtcNow
});
if (result == null)
{
return(NotFound());
}
return(CreatedAtAction(nameof(GetQuestionById),
new { questionId = result.QuestionId }, result));
}
public async Task <QuestionGetSingleResponse> PostQuestion(QuestionPostFullRequest question)
{
System.Console.WriteLine(question.Content);
using (var connection = new SqlConnection(_connectionString))
{
await connection.OpenAsync();
var questionId = connection.QueryFirst <int>(
@"EXEC dbo.Question_Post
@Title = @Title,
@Content = @Content,
@UserId = @UserId,
@UserName = @UserName,
@Created = @Created",
question
);
return(await GetQuestion(questionId));
}
}
