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);
}