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