private void uxButtonAddMovie_Click(object sender, EventArgs e) { Inrepo = new SqlIndividualAwardsWonRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=UserId;" + "Password=Password;"); person = new SqlPersonRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=UserId;" + "Password=Password;"); //person.GetPerson() personrepo = new SqlMoviePersonsRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=UserId;" + "Password=Password;"); personrepo.RetrieveMoviePerson(); if (this.listBox1.SelectedItem != null && !Form1.items.Contains(this.listBox1.SelectedItem.ToString())) { Form1.items.Add(this.listBox1.SelectedItem.ToString()); } if (this.listBox2.SelectedItem != null && !Form1.items.Contains(this.listBox2.SelectedItem.ToString())) { Form1.items.Add(this.listBox2.SelectedItem.ToString()); } this.Dispose(); }
private void uxSearchProduction_Click(object sender, EventArgs e) { personrepo = new SqlMoviePersonsRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=UserId;" + "Password=Password;"); person = new SqlPersonRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=UserId;" + "Password=Password;"); movieAwardsWon = new SqlMovieAwardsWonRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=UserId;" + "Password=Password;"); movieCategory = new SqlMovieRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=UserId;" + "Password=Password;"); Inrepo = new SqlIndividualAwardsWonRepository("Data Source=mssql.cs.ksu.edu;" + "Initial Catalog=phyo;" + "User id=UserId;" + "Password=Password;"); List <Movie> won = new List <Movie>(); if (this.listBox2.SelectedItem.Equals("Best Picture")) { foreach (MovieAwardsWon i in movieAwardsWon.RetrieveMovieAwardsWon()) { if (i.Category.Equals("Best Picture")) { Movie a = movieCategory.FetchMovie(i.MovieId); won.Add(a); } } dataGridView1.DataSource = won; } List <Person> won1 = new List <Person>(); if (this.listBox2.SelectedItem.Equals("Director")) { foreach (IndividualAwardsWon i in Inrepo.RetrieveIndividualAwardsWon()) { MoviePerson a = personrepo.FetchMoviePerson(i.MoviePersonId); if (a.Role.Equals("Director")) { Person b = person.FetchPerson(a.PersonId); won1.Add(b); } } dataGridView1.DataSource = won1; } if (this.listBox2.SelectedItem.Equals("Adapted Screenplay")) { foreach (MovieAwardsWon i in movieAwardsWon.RetrieveMovieAwardsWon()) { if (i.Category.Equals("Adapted Screenplay")) { Movie a = movieCategory.FetchMovie(i.MovieId); won.Add(a); } } dataGridView1.DataSource = won; } }