protected void ShowBlogPostInfo(BLOGDB db)
        {
            bool   valid  = true;
            string blogid = Request.QueryString["blogid"];

            if (String.IsNullOrEmpty(blogid))
            {
                valid = false;
            }

            if (valid)
            {
                BLOGPOST blogpost_record = db.FindBlogPost(Int32.Parse(blogid));

                blogpost_title_head.InnerHtml = blogpost_record.GetBPTitle();
                blogpost_title.InnerHtml      = blogpost_record.GetBPTitle();
                blogpost_body.InnerHtml       = blogpost_record.GetBPBody();
            }
            else
            {
                valid = false;
            }
            if (!valid)
            {
                blog.InnerHtml = "There was an error finding that blog post";
            }
        }
예제 #2
0
        public void UpdateBlogPost(int blogid, BLOGPOST new_post)
        {
            //am i getting here?
            Debug.WriteLine("is this where the problem is?");

            string query = "update blog_post set blogtitle='{0}', blogbody='{1}' where blogid={2} ";

            query = String.Format(query, new_post.GetBPTitle(), new_post.GetBPBody(), blogid);

            Debug.WriteLine("am i getting the information i need?");

            MySqlConnection Connect = new MySqlConnection(ConnectionString);
            MySqlCommand    cmd     = new MySqlCommand(query, Connect);

            try
            {
                Connect.Open();
                cmd.ExecuteNonQuery();
                Debug.WriteLine("Execute query" + query);
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Something went wrong in the UpdateBlog Method!");
                Debug.WriteLine(ex.ToString());
            }
            Connect.Close();
        }
예제 #3
0
        protected void ShowBlogInfo(BLOGDB db)
        {
            bool   valid  = true;
            string blogid = Request.QueryString["blogid"];

            if (String.IsNullOrEmpty(blogid))
            {
                valid = false;
            }

            if (valid)
            {
                Debug.WriteLine("is this it?");
                BLOGPOST blog_record = db.FindBlogPost(Int32.Parse(blogid));
                update_title.InnerHtml = blog_record.GetBPTitle();
                blog_title.Text        = blog_record.GetBPTitle();
                blog_post.Text         = blog_record.GetBPBody();
            }

            if (!valid)
            {
                blog.InnerHtml = "There was an error updating your blog";
            }
        }
예제 #4
0
        public void AddBlogPost(BLOGPOST new_post)
        {
            string query = 'insert into blog_post (blogtitle, blogbody) values ("{0}","{1}")';

            query = String.Format(query, new_post.GetBPTitle(), new_post.GetBPBody());

            MySqlConnection Connect = new MySqlConnection(ConnectionString);
            MySqlCommand    cmd     = new MySqlCommand(query, Connect);

            try
            {
                Connect.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Debug.WriteLine("Something went wrrong in the AddPost Method!");
                Debug.WriteLine(ex.ToString());
            }
            Connect.Close();
        }