public void Reload() { DBEnvironment.SetActors(); actors = DBEnvironment.GetActors(); ActorList.DataSource = actors; this.Refresh(); }
public AddMovieForm(ManagerForm manager, Movie selectedMovie) { parent = manager; InitializeComponent(); DBEnvironment.SetActors(); actors = DBEnvironment.GetActors(); movieActors = new BindingList <Actor>(); deletedActors = new BindingList <Actor>(); movie = selectedMovie; ActorList.DataSource = actors; MovieActorList.DataSource = movieActors; ActorList.AutoGenerateColumns = true; MovieActorList.Columns["Id"].Visible = false; MovieActorList.Columns["Sex"].Visible = false; MovieActorList.Columns["DateOfBirth"].Visible = false; MovieActorList.Columns["Age"].Visible = false; MovieActorList.Columns["Rating"].Visible = false; if (selectedMovie == null) { return; } movieActors = DBEnvironment.GetActors(selectedMovie); MovieActorList.DataSource = movieActors; fillForm(); }
public SearchMovieForm(CustomerForm manager) { parent = manager; InitializeComponent(); DBEnvironment.SetActors(); actors = DBEnvironment.GetActors(); movieActors = new BindingList <Actor>(); deletedActors = new BindingList <Actor>(); ActorList.DataSource = actors; MovieActorList.DataSource = movieActors; ActorList.AutoGenerateColumns = true; MovieActorList.Columns["Id"].Visible = false; MovieActorList.Columns["Sex"].Visible = false; MovieActorList.Columns["DateOfBirth"].Visible = false; MovieActorList.Columns["Age"].Visible = false; MovieActorList.Columns["Rating"].Visible = false; }
public static BindingList <Actor> GetStarred(Movie movie) { int mid = movie.Id; BindingList <Actor> actors = new BindingList <Actor>(); BindingList <Actor> allActors = DBEnvironment.GetActors(); String query = "SELECT aid FROM starred WHERE mid = " + mid; SqlDataAdapter adapter = new SqlDataAdapter(query, con); DataTable table = new DataTable(); adapter.Fill(table); foreach (DataRow actorID in table.Rows) { int aid = int.Parse(actorID["aid"].ToString()); Actor movieActor = DBEnvironment.RetreiveActorByID(aid); Debug.WriteLine("ACTOR " + movieActor.Name.FirstName + " " + movieActor.Name.LastName); actors.Add(movieActor); } return(actors); }