public void PostListChanged(object sender, EventArgs e) { VsrDataContext db = new VsrDataContext(); aspnet_Membership a = new aspnet_Membership(); }
protected bool DoesPostIdExist(Guid post_id) { VsrDataContext db = new VsrDataContext(); var q = from p in db.Posts where p.post_id == post_id select p; return (q.Count() > 0); }
protected void PopulateComments(Guid g) { VsrDataContext db = new VsrDataContext(); var query = from p in db.PostComments where p.posts_id == g orderby p.post_date descending select p; rpComments.DataSource = query; rpComments.DataBind(); }
protected void DisplayPost(Guid g) { VsrDataContext db = new VsrDataContext(); var query = from p in db.Posts where p.enabled == true && p.post_id == g orderby p.posted descending select p; rpPosts.DataSource = query.Take(1); rpPosts.DataBind(); }
void rpPosts_ItemDataBound(object sender, RepeaterItemEventArgs e) { VsrDataContext db = new VsrDataContext(); if ((e.Item.ItemType == ListItemType.Item) || e.Item.ItemType == ListItemType.AlternatingItem) { var query = from p in db.PostComments where p.posts_id == new Guid(((Post)e.Item.DataItem).post_id.ToString()) select p; Repeater nr = (Repeater)e.Item.FindControl("rpComments"); nr.DataSource = query.Take(10); nr.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { VsrDataContext db = new VsrDataContext(); Guid id = Guid.Empty; if (Request.QueryString["post"] != null) { id = new Guid(Request.QueryString["post"].ToString()); } else { // redirect if user tries to access page directly Response.Redirect("Default.aspx"); } // redirect if post id does not exist if (!DoesPostIdExist(id)) Response.Redirect("Default.aspx"); DisplayPost(id); PopulateComments(id); }
protected void btnSubmit_Click(object sender, EventArgs e) { VsrDataContext db = new VsrDataContext(); ContactMessage m = new ContactMessage(); m.message_id = Guid.NewGuid(); m.sender_ip = Request.UserHostAddress; m.name = txtName.Text.ToString(); m.email = txtEmail.Text.ToString(); m.sent = DateTime.Now; m.message = txtMessage.Text.ToString(); db.ContactMessages.InsertOnSubmit(m); db.SubmitChanges(); txtEmail.Text = ""; txtMessage.Text = ""; txtName.Text = ""; mv1.ActiveViewIndex = 1; }
protected void btnCommentSubmit_Click(object sender, EventArgs e) { VsrDataContext db = new VsrDataContext(); Guid postid = Guid.Empty; if (Request.QueryString["post"] == null) { Response.Redirect("Default.aspx"); } else { postid = new Guid(Request.QueryString["post"].ToString()); if(!DoesPostIdExist(postid)) Response.Redirect("Default.aspx"); } if (txtComment.Text.ToString().Length > 3 && txtUsername.Text.ToString().Length > 3) { PostComment p = new PostComment(); p.comment_id = Guid.NewGuid(); p.posts_id = postid; p.post_date = DateTime.Now; p.praise_count = 0; p.criticism_count = 0; p.source_ip = Request.ServerVariables["REMOTE_ADDR"]; p.username = txtUsername.Text.ToString(); p.posttext = txtComment.Text.ToString(); db.PostComments.InsertOnSubmit(p); db.SubmitChanges(); txtComment.Text = ""; txtUsername.Text = ""; PopulateComments(postid); } }
protected void Page_Load(object sender, EventArgs e) { VsrDataContext db = new VsrDataContext(); var query = from p in db.Posts where p.enabled == true orderby p.posted descending select p; rpPosts.DataSource = query.Take(10); rpPosts.DataBind(); //title.Text = query.First().title.ToString(); /* title.Text = db.Posts.First().title.ToString(); post_date.Text = "On "; post_date.Text += db.Posts.First().posted.ToLongDateString(); posttext.Text = db.Posts.First().post_content.ToString(); username.Text = "Posted by " + db.Posts.First().submitter.ToString(); */ }