public ActionResult Index() { CommentsPortal commentsPortal = new CommentsPortal(); Comments comments = new Comments(); comments.getAllDetails = commentsPortal.selectAll(); return(View(comments)); }
public ActionResult Create(FormCollection collection) { Comments comments = new Comments { name = collection["name"], date = DateTime.Now, body = collection["body"] }; string query = "insert into comments values(@name,@date,@body)"; using (SqlConnection conn = new SqlConnection(cs)) { SqlCommand sqlCommand = new SqlCommand(query, conn); sqlCommand.Parameters.AddWithValue("@name", comments.name); sqlCommand.Parameters.AddWithValue("@date", comments.date); sqlCommand.Parameters.AddWithValue("@body", comments.body); conn.Open(); sqlCommand.ExecuteNonQuery(); } CommentsPortal commentsPortal = new CommentsPortal(); comments.getAllDetails = commentsPortal.selectAll(); return(View("Index", comments)); }