public static ForumEstCommentbyUser getoneForumCommentbyID(string forumcommentID) { ForumEstCommentbyUser fu = new ForumEstCommentbyUser(); try { SqlCommand command = new SqlCommand("Select * from ForumEstCommentbyUser where forumcommentID=@forumcommentID"); command.Parameters.AddWithValue("@forumcommentID", forumcommentID); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { fu.forumcommentID = reader["forumcommentID"].ToString(); ForumEstablishments onef = ForumEstablishmentsDB.getForumEstbyID(reader["forumID"].ToString()); fu.forumID = onef; fu.comments = reader["comments"].ToString(); AUser u = AUserDB.getUserbyID(reader["commentby"].ToString()); fu.commentby = u; fu.date = Convert.ToDateTime(reader["date"]); fu.status = reader["status"].ToString(); } reader.Close(); } finally { connection.Close(); } return(fu); }
public static List <ForumEstCommentbyUser> getalloneForumAllComment() { List <ForumEstCommentbyUser> fulists = new List <ForumEstCommentbyUser>(); try { SqlCommand command = new SqlCommand("Select * from ForumEstCommentbyUser"); command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ForumEstCommentbyUser fu = new ForumEstCommentbyUser(); fu.forumcommentID = reader["forumcommentID"].ToString(); ForumEstablishments onef = ForumEstablishmentsDB.getForumEstbyID(reader["forumID"].ToString()); fu.forumID = onef; fu.comments = reader["comments"].ToString(); AUser u = AUserDB.getUserbyID(reader["commentby"].ToString()); fu.commentby = u; fu.date = Convert.ToDateTime(reader["date"]); fu.status = reader["status"].ToString(); fulists.Add(fu); } reader.Close(); } finally { connection.Close(); } return(fulists); }
//add new forum to database public static int insertForumCommentUser(ForumEstCommentbyUser u) { int num = -1; try { SqlCommand command = new SqlCommand("insert into ForumEstCommentbyUser values(@forumID, @comments, @commentby,@date,@status)"); command.Parameters.AddWithValue("@forumID", u.forumID.forumID); command.Parameters.AddWithValue("@comments", u.comments); command.Parameters.AddWithValue("@commentby", u.commentby.userId); command.Parameters.AddWithValue("@date", u.date); command.Parameters.AddWithValue("@status", u.status); command.Connection = connection; connection.Open(); if (command.ExecuteNonQuery() > 0) { num = 1; } } finally { connection.Close(); } return(num); }
protected void btnSumbit_Click(object sender, EventArgs e) { if (tbxComment.Text == "") { lbloutput.Text = "The Comment field cannot be blank."; return; } else { lbloutput.Text = ""; if (Session["hyper1"].ToString() == "1") { ForumUser fu = ForumUserDB.getForumUserbyID(Session["hyper"].ToString()); Users u = UsersDB.getUserbyEmail(Session["email"].ToString()); ForumUserCommentbyUser fuc = new ForumUserCommentbyUser(fu, tbxComment.Text, u, System.DateTime.Now, "allow"); int num = ForumUserCommentbyUserDB.insertForumCommentUser(fuc); if (num != 1) { lbloutput.Text = "Fail to comment!"; return; } else { Response.Redirect("ForumComments.aspx", true); } } else { ForumEstablishment fe = ForumEstablishmentDB.getForumEstbyID(Session["hyper1"].ToString()); Users u = UsersDB.getUserbyEmail(Session["email"].ToString()); ForumEstCommentbyUser fec = new ForumEstCommentbyUser(fe, tbxComment.Text, u, System.DateTime.Now, "allow"); int num = ForumEstCommentbyUserDB.insertForumCommentUser(fec); if (num != 1) { lbloutput.Text = "Fail to comment!"; return; } else { Response.Redirect("ForumComments.aspx", true); } } } }
public static int updateComment(ForumEstCommentbyUser u) { int result; try { SqlCommand command = new SqlCommand("Update ForumEstCommentbyUser set status=@status where forumcommentID=@forumcommentID"); command.Parameters.AddWithValue("@forumcommentID", u.forumcommentID); command.Parameters.AddWithValue("@status", u.status); command.Connection = connection; connection.Open(); result = command.ExecuteNonQuery(); } finally { connection.Close(); } return(result); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { string id = GridView1.SelectedRow.Cells[0].Text; int enumber = 0, unumber = 0; if (ddlFBChoose.SelectedIndex == 1) { List <ForumUserCommentbyEst> uelist = ForumUserCommentbyEstDB.getAlloneForumAllComment(); List <ForumUserCommentbyUser> uulist = ForumUserCommentbyUserDB.getalloneForumAllComment(); foreach (ForumUserCommentbyEst ue in uelist) { if (ue.forumcommentID == id) { ufound = true; unumber = 1; break; } else { efound = false; } } if (efound == false) { foreach (ForumUserCommentbyUser uu in uulist) { if (uu.forumcommentID == id) { efound = true; unumber = 2; break; } else { efound = false; } } } if (unumber == 1) { ForumUserCommentbyEst uecomment = ForumUserCommentbyEstDB.getoneForumCommentbyID(id); if (uecomment.status == "allow") { uecomment.status = "ban"; } else { uecomment.status = "allow"; } ForumUserCommentbyEstDB.updateComment(uecomment); } else { ForumUserCommentbyUser uucomment = ForumUserCommentbyUserDB.getoneForumCommentbyID(id); if (uucomment.status == "allow") { uucomment.status = "ban"; } else { uucomment.status = "allow"; } ForumUserCommentbyUserDB.updateComment(uucomment); } } else { List <ForumEstCommentbyEst> eelist = ForumEstCommentbyEstDB.getalloneForumAllComment(); List <ForumEstCommentbyUser> eulist = ForumEstCommentbyUserDB.getalloneForumAllComment(); foreach (ForumEstCommentbyEst ee in eelist) { if (ee.forumcommentID == id) { efound = true; enumber = 1; break; } else { efound = false; } } if (efound == false) { foreach (ForumEstCommentbyUser eu in eulist) { if (eu.forumcommentID == id) { efound = true; enumber = 2; break; } else { efound = false; } } } if (enumber == 1) { ForumEstCommentbyEst eecomment = ForumEstCommentbyEstDB.getoneForumCommentbyID(id); if (eecomment.status == "allow") { eecomment.status = "ban"; } else { eecomment.status = "allow"; } ForumEstCommentbyEstDB.updateComment(eecomment); } else { ForumEstCommentbyUser eucomment = ForumEstCommentbyUserDB.getoneForumCommentbyID(id); if (eucomment.status == "allow") { eucomment.status = "ban"; } else { eucomment.status = "allow"; } ForumEstCommentbyUserDB.updateComment(eucomment); } } //delete the individual comment on each forum if (Session["u"] != null) { List <tempcomment> tclist = new List <tempcomment>(); List <ForumUserCommentbyEst> fuce = ForumUserCommentbyEstDB.getoneForumAllCommentbyID(Session["forumID"].ToString()); List <ForumUserCommentbyUser> fucu = ForumUserCommentbyUserDB.getoneForumAllCommentbyID(Session["forumID"].ToString()); foreach (ForumUserCommentbyEst f in fuce) { tempcomment tc = new tempcomment(); tc.comentID = f.forumcommentID; tc.comment = f.comments; tc.commentby = f.commentby.Name.ToString(); tc.time = f.date; tc.status = f.status; tc.timeshow = datesub(f.date); tclist.Add(tc); } foreach (ForumUserCommentbyUser g in fucu) { tempcomment tc = new tempcomment(); tc.comentID = g.forumcommentID; tc.comment = g.comments; tc.commentby = g.commentby.username.ToString(); tc.time = g.date; tc.status = g.status; tc.timeshow = datesub(g.date); tclist.Add(tc); } if (tclist.Count == 0) { lblNotFound.Visible = true; } else { tclist = tclist.OrderBy(x => x.time).ToList(); tclist.Reverse(); lblNotFound.Visible = false; GridView1.DataSource = tclist; GridView1.DataBind(); } } else { List <ForumEstCommentbyUser> fecu = ForumEstCommentbyUserDB.getoneForumAllCommentbyID(Session["forumID"].ToString()); List <ForumEstCommentbyEst> fece = ForumEstCommentbyEstDB.getoneForumAllCommentbyID(Session["forumID"].ToString()); foreach (ForumEstCommentbyUser f in fecu) { tempcomment tc = new tempcomment(); tc.comentID = f.forumcommentID; tc.comment = f.comments; tc.commentby = f.commentby.name.ToString(); tc.time = f.date; tc.status = f.status; tc.timeshow = datesub(f.date); tclist.Add(tc); } foreach (ForumEstCommentbyEst g in fece) { tempcomment tc = new tempcomment(); tc.comentID = g.forumcommentID; tc.comment = g.comments; tc.commentby = g.commentby.Name.ToString(); tc.time = g.date; tc.status = g.status; tc.timeshow = datesub(g.date); tclist.Add(tc); } if (tclist.Count == 0) { lblNotFound.Visible = true; } else { tclist = tclist.OrderBy(x => x.time).ToList(); tclist.Reverse(); lblNotFound.Visible = false; GridView1.DataSource = tclist; GridView1.DataBind(); } } }