public void SubmitComment(BlogPostComment m_Comment) { DBHome.SubmitComment(m_Comment); /*MailMessage m_Message = new MailMessage("*****@*****.**", "*****@*****.**"); m_Message.Subject = "New Blog Post for Approval"; m_Message.Body = @"Go approve the comment"; SmtpClient client = new SmtpClient("localhost"); client.UseDefaultCredentials = true; client.Send(m_Message);*/ }
public static void SubmitComment(BlogPostComment m_Comment) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "INSERT INTO CMS_BlogPostComments(comment, name, blogId, pageWorkFlowState) VALUES(@comment, @name, @blogId, 2)"; SqlCommand insertComment = new SqlCommand(queryString, conn); insertComment.Parameters.AddWithValue("comment", m_Comment.Comment); insertComment.Parameters.AddWithValue("name", m_Comment.Name); insertComment.Parameters.AddWithValue("blogId", m_Comment.BlogId); insertComment.ExecuteNonQuery(); conn.Close(); }
public ActionResult SubmitComment(BlogPostComment m_Comment) { HomeRepository.SubmitComment(m_Comment); return RedirectToAction("BlogPost", "Home", new { id = m_Comment.Id }); }
public static List<BlogPostComment> GetComments(int BlogId) { SqlConnection conn = DB.DbConnect(); conn.Open(); string queryString = "SELECT * FROM CMS_BlogPostComments WHERE blogId = @blogId AND pageWorkFlowState != 4 ORDER BY id DESC"; SqlCommand getComments = new SqlCommand(queryString, conn); getComments.Parameters.AddWithValue("blogId", BlogId); SqlDataReader commentReader = getComments.ExecuteReader(); List<BlogPostComment> m_Comments = new List<BlogPostComment>(); while (commentReader.Read()) { BlogPostComment m_Comment = new BlogPostComment(); m_Comment.Id = commentReader.GetInt32(0); m_Comment.BlogId = commentReader.GetInt32(1); m_Comment.Comment = commentReader.GetString(2); m_Comment.Name = commentReader.GetString(3); m_Comment.PageWorkFlowState = commentReader.GetInt32(4); m_Comments.Add(m_Comment); } return m_Comments; }