コード例 #1
0
        public BlogPost GetABlogPost(int PostID)
        {
            SqlConnection conn = new SqlConnection(Database.HadozDB());
            SqlCommand command = new SqlCommand("Blog_GetABlogPost", conn);

            command.CommandType = CommandType.StoredProcedure;
            command.Parameters.Add("@PostID", SqlDbType.Int).Value = PostID;

            BlogPost bp = null;
            SqlDataReader reader = null;

            try
            {
                conn.Open();
                reader = command.ExecuteReader();

                while (reader.Read())
                {
                    bp = new BlogPost(reader.GetInt32(reader.GetOrdinal("PostID")),
                                      reader.GetString(reader.GetOrdinal("Title")),
                                      reader.GetString(reader.GetOrdinal("Body")),
                                      reader.GetString(reader.GetOrdinal("Excerpt")),
                                      reader.GetDateTime(reader.GetOrdinal("CreateDate")).ToLongDateString(),
                                      reader.GetDateTime(reader.GetOrdinal("UpdateDate")).ToLongDateString(),
                                      reader.GetInt32(reader.GetOrdinal("Status")),
                                      reader.GetInt32(reader.GetOrdinal("AuthorID")));
                }

                reader.Close();
            }
            catch (Exception e)
            {

            }
            finally
            {
                if (conn != null && conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
            }
           
            return bp;
        }
コード例 #2
0
        //CRUD
        public List<BlogPost> GetAllBlogPosts()
        {
            SqlConnection conn = new SqlConnection(Database.HadozDB());
            SqlCommand command = new SqlCommand("Blog_GetAllBlogPosts", conn);

            command.CommandType = CommandType.StoredProcedure;
            //command.Parameters.Add("@Email", SqlDbType.VarChar, 256).Value = "email";

            BlogPost bp;
            List<BlogPost> blogPosts = new List<BlogPost>();
            SqlDataReader reader = null;

            try {
                conn.Open();
                reader = command.ExecuteReader();

                while (reader.Read())
	            {
                    bp = new BlogPost(reader.GetInt32(reader.GetOrdinal("PostID")),
                                      reader.GetString(reader.GetOrdinal("Title")),
                                      reader.GetString(reader.GetOrdinal("Body")),
                                      reader.GetString(reader.GetOrdinal("Excerpt")),
                                      reader.GetDateTime(reader.GetOrdinal("CreateDate")).ToLongDateString(),
                                      reader.GetDateTime(reader.GetOrdinal("UpdateDate")).ToLongDateString(),
                                      reader.GetInt32(reader.GetOrdinal("Status")),
                                      reader.GetInt32(reader.GetOrdinal("AuthorID")));
                    blogPosts.Add(bp);
	            }

                reader.Close();
            }
            catch(Exception e){

            }
            finally {
                if (conn != null && conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
            }

            return blogPosts;
        }