public async Task <IActionResult> CreatePost(ForumPostDto forumPostDto)
{
var forumPost = _mapper.Map <ForumPostDto, ForumPost>(forumPostDto);
ClaimsPrincipal cp = _httpContextAccessor.HttpContext.User;
var user = await _userManager.FindByEmailAsync(cp.RetrieveEmailFromClaims());
forumPost.ApplicationUserId = user.Id;
await _unitOfWork.ForumPosts.Add(forumPost);
await _unitOfWork.Save();
return(Ok());
}
public IForumPostDto GetForumPost(int postID)
{
string command = "SELECT * FROM post WHERE PostID={0};";
IForumPostDto model = new ForumPostDto();
using (MySqlConnection conn = Connection.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(string.Format(command, postID.ToString()), conn);
using MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
model = new ForumPostDto()
{
PostID = Convert.ToInt32(reader["PostID"]),
PostMessage = reader["PostMessage"].ToString(),
ThreadID = Convert.ToInt32(reader["ThreadID"])
};
}
}
return(model);
}
