private static BlogPost[] Fetch(int blogId, int blogPostId, bool? approved) { List<BlogPost> lBlogPosts = new List<BlogPost>(); using (SqlConnection conn = Config.DB.Open()) { SqlDataReader reader = (SqlDataReader) SqlHelper.GetDB().ExecuteReader( "FetchBlogPosts", blogId, blogPostId, approved); while (reader.Read()) { BlogPost blogPost = new BlogPost(); blogPost.id = (int) reader["Id"]; blogPost.blogId = (int) reader["BlogId"]; blogPost.title = (string) reader["Title"]; blogPost.content = (string) reader["Content"]; blogPost.datePosted = (DateTime) reader["DatePosted"]; blogPost.reads = (int) reader["Reads"]; blogPost.approved = (bool) reader["Approved"]; lBlogPosts.Add(blogPost); } } return lBlogPosts.ToArray(); }
public static BlogPost Create(int blogId, string title, string content) { BlogPost blogPost = new BlogPost(); blogPost.id = -1; blogPost.blogId = blogId; blogPost.title = title; blogPost.content = content; blogPost.datePosted = DateTime.Now; blogPost.reads = 0; return blogPost; }