private void bornTodayToolStripMenuItem_Click(object sender, EventArgs e)
{
HumanListForm humanListForm = new HumanListForm();
humanListForm.gelenSqlString = "SELECT * FROM Human WHERE b_date='" + today + "' ORDER BY name";
humanListForm.gelenSqlCountString = "SELECT COUNT(*) FROM Human WHERE b_date='" + today + "'";
humanListForm.gelenU_No = user.getU_No();
humanListForm.ShowDialog();
}
private void allCelebritiesToolStripMenuItem_Click(object sender, EventArgs e)
{
HumanListForm humanListForm = new HumanListForm();
humanListForm.gelenSqlString = "SELECT * FROM Human ORDER BY name";
humanListForm.gelenSqlCountString = "SELECT COUNT(*) FROM Human ";
humanListForm.gelenU_No = user.getU_No();
humanListForm.Text += " [A-Z]";
humanListForm.ShowDialog();
}
private void mostPopularToolStripMenuItem_Click(object sender, EventArgs e)
{
HumanListForm humanListForm = new HumanListForm();
humanListForm.gelenSqlString = "SELECT h.*,AVG(ch.point) as humanPoint FROM Human h, CommentsOfHuman ch WHERE (h.h_no=ch.h_no) GROUP BY h.h_no,h.name,h.l_name,h.b_date,h.city,h.country,h.biography, h.height, h.photo, h.sex, h.actorFlag, h.authorFlag, h.directorFlag ORDER BY humanPoint DESC";
humanListForm.gelenSqlCountString = "SELECT COUNT(*) FROM Human h WHERE EXISTS(SELECT ch.h_no FROM CommentsOfHuman ch WHERE h.h_no=ch.h_no)";
humanListForm.gelenU_No = user.getU_No();
humanListForm.Text += " [Most Populer]";
humanListForm.ShowDialog();
}
