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();
*/
}
