private void TopNMovies_Click(object sender, EventArgs e) { filename = this.txtFilename.Text; string N = this.topNtxt1.Text; if (!fileExists(filename)) { return; } if (!connectionTest(filename)) { return; } BusinessTier.Business biztier = new BusinessTier.Business(filename); var TopNList = biztier.GetTopMoviesByAvgRating(Convert.ToInt32(N)); SubForm frm = new SubForm(); frm.label_header.Text = "Top Movies by Average Rating"; string line; foreach (var data in TopNList) { var avg = biztier.GetMovieDetail(data.MovieID); line = String.Format("{0}: {1}", data.MovieName, avg.AvgRating); frm.listBox1.Items.Add(line); } frm.ShowDialog(); }
private void EachRate_Click(object sender, EventArgs e) { filename = this.txtFilename.Text; if (!fileExists(filename)) { return; } if (!connectionTest(filename)) { return; } if (this.ListDisplay.SelectedIndex < 0) { MessageBox.Show("Please select a movie..."); return; } BusinessTier.Business biztier = new BusinessTier.Business(filename); int movieID = Convert.ToInt32(this.MovieIdBox.Text); var movieData = biztier.GetMovieDetail(movieID); if (movieData == null) { MessageBox.Show("Invalid movie ID!!"); return; } var movieReview = movieData.Reviews; int[] eachRating = { 0, 0, 0, 0, 0 }; int totalCount = 0; foreach (var data in movieReview) { eachRating[data.Rating - 1]++; } Array.Reverse(eachRating); SubForm frm = new SubForm(); frm.label_header.Text = string.Format("Each Rating for \"{0}\"", movieData.movie.MovieName); frm.listBox1.Items.Add(movieData.movie.MovieName); frm.listBox1.Items.Add(" "); int num = 5; foreach (int count in eachRating) { totalCount += count; frm.listBox1.Items.Add(String.Format("{0}: {1}", num--, Convert.ToString(count))); } frm.listBox1.Items.Add(" "); frm.listBox1.Items.Add(String.Format("Total: {0}", totalCount.ToString())); frm.ShowDialog(); }
private void GetUserReview_Click(object sender, EventArgs e) { filename = this.txtFilename.Text; if (!fileExists(filename)) { return; } if (!connectionTest(filename)) { return; } if (this.ListDisplay2.SelectedIndex < 0) { MessageBox.Show("Please select a user..."); return; } string userId = this.userIdBox.Text; BusinessTier.Business biztier = new BusinessTier.Business(filename); var userDataList = biztier.GetUserDetail(Convert.ToInt32(userId)); if (userDataList == null) { MessageBox.Show("Invalid User ID!!"); return; } string userName; if (userDataList.user.UserName.IndexOf(userDataList.user.UserID.ToString()) != -1) { userName = "******"; } else { userName = userDataList.user.UserName; } SubForm frm = new SubForm(); frm.label_header.Text = String.Format("Reviews by \"{0}\"", userName); string movieName; int rate; string line; foreach (var review in userDataList.Reviews) { movieName = biztier.GetMovie(review.MovieID).MovieName; rate = review.Rating; line = String.Format("{0} : {1}", movieName, rate); frm.listBox1.Items.Add(line); } frm.ShowDialog(); }
private void GetMovieReview_Click(object sender, EventArgs e) { filename = this.txtFilename.Text; if (!fileExists(filename)) { return; } if (!connectionTest(filename)) { return; } if (this.ListDisplay.SelectedIndex < 0) { MessageBox.Show("Please select a movie..."); return; } BusinessTier.Business biztier = new BusinessTier.Business(filename); int movieID = Convert.ToInt32(this.MovieIdBox.Text); var movieData = biztier.GetMovieDetail(movieID); if (movieData == null) { MessageBox.Show("Invalid movie ID!!"); return; } var movieReview = movieData.Reviews; string name = movieData.movie.MovieName; SubForm frm = new SubForm(); frm.label_header.Text = String.Format("Reviews for \"{0}\"", name); frm.listBox1.Items.Add(name); frm.listBox1.Items.Add(" "); string line; string userID; string rate; foreach (var data in movieReview) { userID = data.UserID.ToString(); rate = data.Rating.ToString(); line = string.Format("{0}: {1}", userID, rate); frm.listBox1.Items.Add(line); } frm.listBox1.Items.Add(" "); frm.ShowDialog(); }
private void TopNUsers_Click(object sender, EventArgs e) { filename = this.txtFilename.Text; string N = this.topNtxt1.Text; if (!fileExists(filename)) { return; } if (!connectionTest(filename)) { return; } BusinessTier.Business biztier = new BusinessTier.Business(filename); var TopNList = biztier.GetTopUsersByNumReviews(Convert.ToInt32(N)); SubForm frm = new SubForm(); frm.label_header.Text = "Top Users by Number of Reviews"; string userName; string line; foreach (var data in TopNList) { var count = biztier.GetUserDetail(data.UserID); if (data.UserName.IndexOf(data.UserID.ToString()) != -1) { userName = "******"; } else { userName = data.UserName; } line = String.Format("{0}: {1}", userName, count.NumReviews); frm.listBox1.Items.Add(line); } frm.ShowDialog(); }
private void TopNReview_Click(object sender, EventArgs e) { filename = this.txtFilename.Text; if (!fileExists(filename)) { return; } if (!connectionTest(filename)) { return; } string N = this.topNtxt1.Text; BusinessTier.Business biztier = new BusinessTier.Business(filename); var TopNList = biztier.GetTopMoviesByNumReviews(Convert.ToInt32(N)); SubForm frm = new SubForm(); frm.label_header.Text = "Top Movies by Number of Reviews"; string movieName; string movieCount; string line; foreach (var data in TopNList) { movieName = data.MovieName.ToString(); movieCount = biztier.GetMovieDetail(data.MovieID).NumReviews.ToString(); line = string.Format("{0}: {1}", movieName, movieCount); frm.listBox1.Items.Add(line); } frm.ShowDialog(); }