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);
}
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);
}
//add new forum to database
public static int insertForum(AForumUser u)
{
int num = -1;
try
{
SqlCommand command = new SqlCommand("insert into ForumUser values(@title, @message, @date,@status,@UserID)");
command.Parameters.AddWithValue("@title", u.title);
command.Parameters.AddWithValue("@message", u.message);
command.Parameters.AddWithValue("@date", u.date);
command.Parameters.AddWithValue("@status", u.status);
command.Parameters.AddWithValue("@UserID", u.userID.userId);
command.Connection = connection;
connection.Open();
if (command.ExecuteNonQuery() > 0)
{
num = 1;
}
}
finally
{
connection.Close();
}
return(num);
}
public static AForumUser getForumUserbyID(string id)
{
AForumUser fu = new AForumUser();
try
{
SqlCommand command = new SqlCommand("Select * from ForumUser where forumID=@forumID");
command.Parameters.AddWithValue("@forumID", id);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
fu.ForumID = reader["forumID"].ToString();
fu.title = reader["title"].ToString();
fu.message = reader["message"].ToString();
fu.date = Convert.ToDateTime(reader["date"]);
fu.status = reader["status"].ToString();
AUser u = AUserDB.getUserbyID(reader["UserID"].ToString());
fu.userID = u;
}
reader.Close();
}
finally
{
connection.Close();
}
return(fu);
}
public static List <AForumUser> getAllForumUser()
{
List <AForumUser> forumlists = new List <AForumUser>();
try
{
SqlCommand command = new SqlCommand("Select * from ForumUser");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
AForumUser fu = new AForumUser();
fu.ForumID = reader["forumID"].ToString();
fu.title = reader["title"].ToString();
fu.message = reader["message"].ToString();
fu.date = Convert.ToDateTime(reader["date"]);
fu.status = reader["status"].ToString();
AUser u = AUserDB.getUserbyID(reader["UserID"].ToString());
fu.userID = u;
forumlists.Add(fu);
}
reader.Close();
}
finally
{
connection.Close();
}
return(forumlists);
}
public ForumUserCommentbyUser(AForumUser forumID, string comments, AUser commentby, DateTime date, string status)
{
this.forumID = forumID;
this.comments = comments;
this.commentby = commentby;
this.date = date;
this.status = status;
}
protected void gvUser_SelectedIndexChanged1(object sender, EventArgs e)
{
List <tempcomment> tclist = new List <tempcomment>();
Panel1.Visible = true;
allflist = AForumUserDB.getAllForumUser();
AForumUser fu = allflist[gvUser.PageSize * gvUser.PageIndex + gvUser.SelectedIndex];
Session["forumID"] = fu.forumID;
gvUser.SelectedIndex = -1;
lbltitle.Text = fu.Title;
lblmessage.Text = fu.message;
lblUser.Text = fu.userID.username;
lblDate.Text = string.Format("{0:dd/MM/yyyy}", fu.date);
List <ForumUserCommentbyEst> fuce = ForumUserCommentbyEstDB.getoneForumAllCommentbyID(fu.forumID);
List <ForumUserCommentbyUser> fucu = ForumUserCommentbyUserDB.getoneForumAllCommentbyID(fu.forumID);
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();
}
}
protected void gvUser_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
allflist = AForumUserDB.getAllForumUser();
AForumUser af = allflist[gvUser.PageSize * gvUser.PageIndex + e.RowIndex];
if (af.status == "allow")
{
af.status = "ban";
}
else
{
af.status = "allow";
}
AForumUserDB.updateUserForum(af);
allflist = AForumUserDB.getAllForumUser();
gvUser.DataSource = allflist;
gvUser.DataBind();
}
public static int updateUserForum(AForumUser u)
{
int result;
try
{
SqlCommand command = new SqlCommand("Update ForumUser set status=@status where title=@title");
command.Parameters.AddWithValue("@title", u.title);
command.Parameters.AddWithValue("@status", u.status);
command.Connection = connection;
connection.Open();
result = command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
return(result);
}
