protected void Page_Load(object sender, EventArgs e) { postid = Convert.ToInt32(Request.QueryString["postid"]); if (postid == 0) v = new Post(); else v=Post.LoadPostbyId(postid); Ncomments = v.GetNComments(1, 20); }
protected void Button1_Click(object sender, EventArgs e) { List<string> categories = new List<string>(); foreach (ListItem item in lstCategories.Items) { if (item.Selected) { categories.Add(item.Text); } } int published; if (drpPublish.SelectedIndex == 0) published = 1; else published = 0; post = new Post(txtTitle.Text.Replace("'", "''"), txtContent.Text.Replace("'", "''"), published, categories, txtNewTags.Text.Replace("'", "''")); if (post.published == 1) posted = true; }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; txtToggleValue.Text = ""; populateCategoryList(); postid = Request.QueryString["postid"].ToString(); //postid = "21"; post = Post.LoadPostbyIdAll(Convert.ToInt32(postid)); txtTitle.Text = post.title; txtContent.Text = post.content; if (post.published == 0) drpPublish.SelectedIndex = 1; else drpPublish.SelectedIndex = 0; //populating multiselect list from db for(int i = 0; i < lstCategories.Items.Count; i++) { if((post.categories.Find(x=>x.categoryName==lstCategories.Items[i].Text)!=null)) lstCategories.Items[i].Selected = true; } int count = 0; foreach(var tag in post.tags) { if(count!=0) txtNewTags.Text += ","; txtNewTags.Text += tag.tag; count++; } if (drpPublish.SelectedItem.Text == "Yes") txtToggle.Text = "0"; else txtToggle.Text = "1"; }
//gettagsofthispost public List<Tag> GetTags(Post post) { SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString); List<Tag> lstTags = new List<Tag>(); string q1 = "select tag from tags where pagepostID =" + post.postId; SqlCommand com1 = new SqlCommand(q1, con1); //List<int> catIDs = new List<int>(); con1.Open(); SqlDataReader rdr = com1.ExecuteReader(); while (rdr.Read()) { lstTags.Add(new Tag(rdr["tag"].ToString(),post.postId)); } con1.Close(); tags = lstTags; return lstTags; }
//getcategoriesofthispost public List<Category> GetCategories(Post post) { SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString); List<Category> lstCategories = new List<Category>(); string q1 = "select categoryId from postCategories where postID =" + post.postId; SqlCommand com1 = new SqlCommand(q1, con1); List<int> catIDs = new List<int>(); con1.Open(); SqlDataReader rdr = com1.ExecuteReader(); while (rdr.Read()) { catIDs.Add(Convert.ToInt32(rdr[0])); } con1.Close(); foreach(var v in catIDs) { q1 = "select * from categories where id=" + v; com1 = new SqlCommand(q1, con1); con1.Open(); rdr = com1.ExecuteReader(); while (rdr.Read()) { lstCategories.Add(new Category(Convert.ToInt32(rdr[0]), rdr[1].ToString(), rdr[2].ToString())); } con1.Close(); } categories = lstCategories; return lstCategories; }
//search word is post content public static List<Post> SearchPostContentbyWord( string query) { Post post; List<Post> posts = new List<Post>(); string q1 = "select * from Posts_View where postContent like '%" + query + "%'"; SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString); SqlCommand com1 = new SqlCommand(q1, con1); SqlDataReader rdr; con1.Open(); rdr = com1.ExecuteReader(); while (rdr.Read()) { string title = rdr["postTitle"].ToString(); string content = rdr["postContent"].ToString(); string Author = rdr["FirstName"].ToString(); DateTime dtc = Convert.ToDateTime(rdr["dateCreated"]); DateTime dtm = Convert.ToDateTime(rdr["dateModified"]); DateTime dtp = Convert.ToDateTime(rdr["datePublished"]); int AuthorID = Convert.ToInt32(rdr["authorId"]); int postID = Convert.ToInt32(rdr["PostId"]); int published = Convert.ToInt32(rdr["Published"]); ; post = new Post(postID, title, content, dtc, dtm, published, dtp, AuthorID, Author); posts.Add(post); } con1.Close(); return posts; }
public static Post LoadPostbyIdAll(int N) { SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString); //N++; string q1 = "select * from Posts_View where postID =" + N; SqlCommand com1 = new SqlCommand(q1, con1); con1.Open(); SqlDataReader rdr = com1.ExecuteReader(); Post post = new Post(); while (rdr.Read()) { string title = rdr["postTitle"].ToString(); string content = rdr["postContent"].ToString(); string Author = rdr["FirstName"].ToString(); DateTime dtc = Convert.ToDateTime(rdr["dateCreated"]); DateTime dtm = Convert.ToDateTime(rdr["dateModified"]); DateTime dtp = Convert.ToDateTime(rdr["datePublished"]); int AuthorID = Convert.ToInt32(rdr["authorId"]); int postID = Convert.ToInt32(rdr["PostId"]); int published = Convert.ToInt32(rdr["Published"]); ; post = new Post(postID, title, content, dtc, dtm, published, dtp, AuthorID, Author); //NPosts.Add(post); } con1.Close(); return post; }
public static List<Post> LoadNextNPosts(int i,int N) { SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString); N = N + i; string q1 = "select * from Posts_View where published=1 and postID between "+i+" and " + N; SqlCommand com1 = new SqlCommand(q1, con1); con1.Open(); SqlDataReader rdr = com1.ExecuteReader(); List<Post> NPosts = new List<Post>(); while (rdr.Read()) { string title = rdr["postTitle"].ToString(); string content = rdr["postContent"].ToString(); DateTime dtc = Convert.ToDateTime(rdr["dateCreated"]); DateTime dtm = Convert.ToDateTime(rdr["dateModified"]); DateTime dtp = Convert.ToDateTime(rdr["datePublished"]); int AuthorID = Convert.ToInt32(rdr["authorId"]); int postID = Convert.ToInt32(rdr["PostId"]); string Author = rdr["FirstName"].ToString(); int published = 1; Post post = new Post(postID, title, content, dtc, dtm, published, dtp, AuthorID,Author); NPosts.Add(post); } con1.Close(); return NPosts; }
//load nposts of a tag public static List<Post> GetNPostsbyTag(int initial, int length, string tag) { SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["globaldb"].ConnectionString); string q1 = "select P.* from Posts_View P, Tags T where P.PostId=T.PagePostId and tag='" + tag+"'"; SqlDataReader rdr; SqlCommand com1 = new SqlCommand(q1, con1); con1.Open(); rdr = com1.ExecuteReader(); Post thread; List<Post> NThreads = new List<Post>(); int n = 1; while (rdr.Read()) { thread = new Post(); thread.postId = Convert.ToInt32(rdr["postId"]); thread.title = rdr["postTitle"].ToString(); thread.content = rdr["postContent"].ToString(); thread.dateCreated = Convert.ToDateTime(rdr["dateCreated"]); thread.dateModified = Convert.ToDateTime(rdr["dateModified"]); thread.datePublished = Convert.ToDateTime(rdr["datePublished"]); thread.published = 1; thread.AuthorId = Convert.ToInt32(rdr["AuthorId"]); thread.Author = rdr["FirstName"].ToString(); if (n >= initial && n <= initial + length - 1)//improve efficiency NThreads.Add(thread); n++; } con1.Close(); return NThreads; }