//To View all employees details public List <Blogs> GetAllBlogs() { try { List <Blogs> lstblog = new List <Blogs>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spGetBlogs", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Blogs blog = new Blogs(); blog.id = Convert.ToInt32(rdr["BlogPostID"]); blog.title = rdr["BlogPostTitle"].ToString(); blog.body = rdr["BlogPostBody"].ToString(); blog.date = rdr["BlogPostDate"].ToString(); blog.username = rdr["BlogUserName"].ToString(); lstblog.Add(blog); } con.Close(); } return(lstblog); } catch { throw; } }
public Blogs GetBlogByPostID(int PostID) { try { Blogs blog = new Blogs(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spGetBlogsByBlogPostID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BlogPostID", PostID); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { blog.id = Convert.ToInt32(rdr["BlogPostID"]); blog.title = rdr["BlogPostTitle"].ToString(); blog.body = rdr["BlogPostBody"].ToString(); blog.date = rdr["BlogPostDate"].ToString(); blog.username = rdr["BlogUserName"].ToString(); } con.Close(); } return(blog); } catch { throw; } }