private void cmbTheatreList_SelectedIndexChanged(object sender, EventArgs e) { if (cmbTheatreList.SelectedIndex > -1) { MovieTheatre theatre = (MovieTheatre)cmbTheatreList.SelectedItem; lblTheatreNumber.Text = theatre.MovieTheatreID.ToString(); lblTheatreName.Text = theatre.MovieTheatreName; lblCapacity.Text = theatre.SeatingCapacity.ToString(); } ClearForm.DisposePanels(this); if (cmbTheatreList.SelectedIndex == 0) { CreateTheatre.TheatreA(this); } else if (cmbTheatreList.SelectedIndex == 1) { ; CreateTheatre.TheatreB(this); } if (cmbTheatreList.SelectedIndex == 2) { CreateTheatre.TheatreC(this); } }
public static List <MovieTheatre> GetTheatreList() { List <MovieTheatre> theatreList = new List <MovieTheatre>(); SqlConnection sqlConnection = new SqlConnection(ConfigurationManager .ConnectionStrings["MasterCinemaConnection"].ConnectionString); SqlCommand selectCommand = new SqlCommand("SELECT ID, Name, SeatingCapacity FROM MovieTheater"); selectCommand.Connection = sqlConnection; try { if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } SqlDataReader dataReader = selectCommand.ExecuteReader(); MovieTheatre theatre; while (dataReader.Read()) { theatre = new MovieTheatre(); theatre.MovieTheatreID = (int)dataReader["ID"]; theatre.MovieTheatreName = (string)dataReader["Name"]; theatre.SeatingCapacity = (byte)dataReader["SeatingCapacity"]; theatreList.Add(theatre); } } catch (Exception) { throw; } finally { sqlConnection.Close(); } return(theatreList); }