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