protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Assignment1Entities db = new Assignment1Entities(); User user = db.Users.FirstOrDefault(u => u.Email == (HttpContext.Current.User.Identity.Name)); txtAuthor.Text = user.FirstName + ' ' + user.LastName; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Assignment1Entities db = new Assignment1Entities(); posts.DataSource = db.Posts.ToList(); posts.DataBind(); } }
protected void delete_OnClick(object sender, EventArgs e) { Assignment1Entities db = new Assignment1Entities(); int id = Int32.Parse(((Button)sender).CommandArgument); db.BadWords.Remove(db.BadWords.Where(b => b.BadWordId == id).First()); db.SaveChanges(); badwords.DataSource = db.BadWords.ToList(); badwords.DataBind(); }
protected void delete_OnClick(object sender, EventArgs e) { Assignment1Entities db = new Assignment1Entities(); int id = Int32.Parse(((Button)sender).CommandArgument); db.Comments.RemoveRange(db.Comments.Where(c => c.Posts_PostId == id).ToList()); db.SaveChanges(); db.Posts.Remove(db.Posts.Where(p => p.PostId == id).First()); db.SaveChanges(); posts.DataSource = db.Posts.ToList(); posts.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id; Int32.TryParse(Request.QueryString["id"], out id); Assignment1Entities db = new Assignment1Entities(); Post post = db.Posts.FirstOrDefault(p => p.PostId == id); txtAuthor.Text = post.Author; txtTitle.Text = post.Title; txtDescription.Text = post.Description; txtHTML.Text = post.HtmlText; checkBox.Checked = post.IsAvailable; } }
protected void AddBadWord(object sender, EventArgs e) { try { Assignment1Entities db = new Assignment1Entities(); BadWord word = new BadWord(); word.Users_UserId = db.Users.FirstOrDefault(u => u.Email == (HttpContext.Current.User.Identity.Name)).UserId; word.Text = txtBad.Text; word.CreatedDate = DateTime.Now; db.BadWords.Add(word); db.SaveChanges(); Response.Redirect("/Admin/BadWords.aspx"); } catch { ClientScript.RegisterStartupScript(GetType(), "alert", "alert('An Error as occurred, please try again later.');", true); } }
protected void CreatePost(object sender, EventArgs e) { try { Assignment1Entities db = new Assignment1Entities(); Post post = new Post { Users_UserId = db.Users.FirstOrDefault(u => u.Email == (HttpContext.Current.User.Identity.Name)).UserId, Title = txtTitle.Text, Author = txtAuthor.Text, Description = txtDescription.Text, HtmlText = txtHTML.Text, IsAvailable = checkBox.Checked, CreatedDate = DateTime.Now }; db.Posts.Add(post); db.SaveChanges(); Response.Redirect("/Admin/AdminHome.aspx"); } catch { ClientScript.RegisterStartupScript(GetType(), "alert", "alert('An Error as occurred, please try again later.');", true); } }
protected void EditPost(object sender, EventArgs e) { try { int id; Int32.TryParse(Request.QueryString["id"], out id); Assignment1Entities db = new Assignment1Entities(); Post post = db.Posts.FirstOrDefault(p => p.PostId == id); post.Title = txtTitle.Text; post.Author = txtAuthor.Text; post.Description = txtDescription.Text; post.HtmlText = txtHTML.Text; post.IsAvailable = checkBox.Checked; db.SaveChanges(); Response.Redirect("/Admin/AdminHome.aspx"); } catch { ClientScript.RegisterStartupScript(GetType(), "alert", "alert('An Error as occurred, please try again later.');", true); } }