public static ForumUserCommentbyEst getoneForumCommentbyID(string forumcommentID)
{
ForumUserCommentbyEst fu = new ForumUserCommentbyEst();
try
{
SqlCommand command = new SqlCommand("Select * from ForumUserCommentbyEst 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();
AForumUser onef = AForumUserDB.getForumUserbyID(reader["forumID"].ToString());
fu.forumID = onef;
fu.comments = reader["comments"].ToString();
Establishment u = EstablishmentDB.getEstablishmentByID(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 <ForumUserCommentbyEst> getAlloneForumAllComment()
{
List <ForumUserCommentbyEst> fulists = new List <ForumUserCommentbyEst>();
try
{
SqlCommand command = new SqlCommand("Select * from ForumUserCommentbyEst");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ForumUserCommentbyEst fu = new ForumUserCommentbyEst();
fu.forumcommentID = reader["forumcommentID"].ToString();
AForumUser onef = AForumUserDB.getForumUserbyID(reader["forumID"].ToString());
fu.forumID = onef;
fu.comments = reader["comments"].ToString();
Establishment u = EstablishmentDB.getEstablishmentByID(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(ForumUserCommentbyEst u)
{
int num = -1;
try
{
SqlCommand command = new SqlCommand("insert into ForumUserCommentbyUser 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.ID);
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());
Establishment es = (Establishment)Session["establishment"];
ForumUserCommentbyEst fue = new ForumUserCommentbyEst(fu, tbxComment.Text, es, System.DateTime.Now, "allow");
int num = ForumUserCommentbyEstDB.insertForumCommentUser(fue);
if (num != 1)
{
lbloutput.Text = "Fail to comment!";
return;
}
else
{
Response.Redirect("ForumCommentE.aspx", true);
}
}
else
{
ForumEstablishment fe = ForumEstablishmentDB.getForumEstbyID(Session["hyper1"].ToString());
Establishment es = (Establishment)Session["establishment"];
ForumEstCommentbyEst fee = new ForumEstCommentbyEst(fe, tbxComment.Text, es, System.DateTime.Now, "allow");
int num = ForumEstCommentbyEstDB.insertForumCommentEst(fee);
if (num != 1)
{
lbloutput.Text = "Fail to comment!";
return;
}
else
{
Response.Redirect("ForumCommentE.aspx", true);
}
}
}
}
public static int updateComment(ForumUserCommentbyEst u)
{
int result;
try
{
SqlCommand command = new SqlCommand("Update ForumUserCommentbyEst 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();
}
}
}
