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; }
//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; }