private void topRatedMoviesToolStripMenuItem_Click(object sender, EventArgs e)
{
MoviesListForm movieListForm = new MoviesListForm();
movieListForm.gelenSqlString = "SELECT m.*,AVG(cm.point) as moviePoint FROM Movies m, CommentsOfMovie cm WHERE (m.m_no=cm.m_no) GROUP BY m.m_no,m.name,m.about,m.release_date,m.budget,m.mtime,m.trailer, m.cover, m.m_language ORDER BY moviePoint DESC";
movieListForm.gelenSqlCountString = "SELECT COUNT(*) FROM Movies m WHERE EXISTS(SELECT cm.m_no FROM CommentsOfMovie cm WHERE m.m_no=cm.m_no)";
movieListForm.gelenU_No = user.getU_No();
movieListForm.Text += " [Top Rated]";
movieListForm.ShowDialog();
}
private void comingSoonToolStripMenuItem_Click(object sender, EventArgs e)
{
MoviesListForm moviesListForm = new MoviesListForm();
moviesListForm.gelenU_No = user.getU_No();
moviesListForm.gelenSqlString = "SELECT * FROM Movies WHERE release_date > '" + today + "'";
moviesListForm.gelenSqlCountString = "SELECT COUNT(*) FROM Movies WHERE release_date > '" + today + "'";
moviesListForm.Text += " [Coming Soon]";
moviesListForm.ShowDialog();
}
private void allToolStripMenuItem_Click(object sender, EventArgs e)
{
MoviesListForm moviesListForm = new MoviesListForm();
moviesListForm.gelenU_No = user.getU_No();
moviesListForm.gelenSqlString = "SELECT * FROM Movies ORDER BY name";
moviesListForm.gelenSqlCountString = "SELECT COUNT(*) FROM Movies";
moviesListForm.Text += " [A-Z]";
moviesListForm.ShowDialog();
}
