public void EditPost()
{
IForumPostDto forumPostDto = DataHandlerFactory.DataHandlerFactory.GetForumPostDto();
forumPostDto.PostID = PostID;
forumPostDto.PostMessage = PostMessage;
db.EditForumPost(forumPostDto);
}
public void CreatePost(IForumPost forumPost)
{
IForumPostDto forumPostDto = DataHandlerFactory.DataHandlerFactory.GetForumPostDto();
forumPostDto.ThreadID = forumPost.ThreadID;
forumPostDto.AccountID = forumPost.AccountID;
forumPostDto.PostMessage = forumPost.PostMessage;
forumPostDto.PostDateCreated = forumPost.PostDateCreated;
db.CreatePost(forumPostDto);
}
public void EditForumPost(IForumPostDto forumPostDto)
{
string command = "UPDATE post SET PostMessage='{0}' WHERE PostID={1};";
using (MySqlConnection conn = Connection.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(string.Format(command, forumPostDto.PostMessage,
forumPostDto.PostID), conn);
cmd.ExecuteNonQuery();
}
}
public IForumPost GetForumPost(int postID)
{
IForumPostDto forumPostDto = db.GetForumPost(postID);
IForumPost forumPost = new ForumPost(DataHandlerFactory.DataHandlerFactory.GetForumPostContext())
{
PostID = forumPostDto.PostID,
ThreadID = forumPostDto.ThreadID,
AccountID = forumPostDto.AccountID,
PostMessage = forumPostDto.PostMessage,
PostDateCreated = forumPostDto.PostDateCreated,
};
return(forumPost);
}
public void CreatePost(IForumPostDto forumPostDto)
{
string command = "INSERT INTO `post` (`ThreadID`, `AccountID`, `PostMessage`, `PostDateCreated`) VALUES ({0}, {1}, '{2}', '{3}');";
using (MySqlConnection conn = Connection.GetConnection())
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(string.Format(command, forumPostDto.ThreadID,
forumPostDto.AccountID,
forumPostDto.PostMessage,
DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")), conn);
cmd.ExecuteNonQuery();
}
}
