public fHalls(AuthorisedUser user) { InitializeComponent(); if (user.GetType() == typeof(AdminUser)) { this.user = user; ReadingFromDateBase reading = new ReadingFromDateBase(); hallsList = reading.ReadHalls(); placesList = reading.ReadAllPlacesOfAllHalls(); sourceData.DataSource = hallsList.Halls; dataGridViewHalls.DataSource = sourceData; dataGridViewHalls.Columns[0].Visible = false; dataGridViewHalls.Columns[1].HeaderText = "Название"; dataGridViewHalls.Columns[2].HeaderText = "Кол-во мест"; dataGridViewHalls.Columns[3].HeaderText = "Кол-во мест в ряду"; } else { this.user = user; ReadingFromDateBase reading = new ReadingFromDateBase(); hallsList = reading.ReadHalls(); placesList = reading.ReadAllPlacesOfAllHalls(); sourceData.DataSource = hallsList.Halls; dataGridViewHalls.DataSource = sourceData; dataGridViewHalls.Columns[0].Visible = false; dataGridViewHalls.Columns[1].HeaderText = "Название"; dataGridViewHalls.Columns[2].HeaderText = "Кол-во мест"; dataGridViewHalls.Columns[3].HeaderText = "Кол-во мест в ряду"; AddButton.Visible = false; UpdateButton.Visible = false; DeleteButton.Visible = false; } }
public ListOfHalls ReadHalls() { List <Hall> hallsList = new List <Hall>(); SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase); using (connectToDateBase) { SqlCommand command = new SqlCommand( "SELECT HALL_ID, NAME_HALL, SEATING_CAPACITY, PLACES_IN_ROW FROM [HALLS];", connectToDateBase); connectToDateBase.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Hall hall = new Hall(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetInt32(3)); hallsList.Add(hall); } } reader.Close(); } ListOfHalls halls = new ListOfHalls(hallsList); return(halls); }
public fSessions(AuthorisedUser user) { this.user = user; InitializeComponent(); if (user.GetType() == typeof(AdminUser)) { ReadingFromDateBase reading = new ReadingFromDateBase(); sessionsList = reading.ReadSessions(); foreach (var i in sessionsList.Sessions) { filmIds.Add(i.FilmSession.FilmId); hallIds.Add(i.HallSession.HallId); } LoadDataGridView(); filmList = reading.ReadFilms(); hallList = reading.ReadHalls(); FilmComboBox.DataSource = filmList.Films; FilmComboBox.DisplayMember = "FilmName"; FilmComboBox.ValueMember = "FilmId"; HallComboBox.DataSource = hallList.Halls; HallComboBox.DisplayMember = "HallName"; HallComboBox.ValueMember = "HallId"; } else { this.user = user; ReadingFromDateBase reading = new ReadingFromDateBase(); sessionsList = reading.ReadSessions(); foreach (var i in sessionsList.Sessions) { filmIds.Add(i.FilmSession.FilmId); hallIds.Add(i.HallSession.HallId); } for (int i = 0; i < sourceData.Count; i++) { dataGridViewSessions[2, i].Value = filmIds[i]; } LoadDataGridView(); filmList = reading.ReadFilms(); hallList = reading.ReadHalls(); FilmComboBox.DataSource = filmList.Films; FilmComboBox.DisplayMember = "FilmName"; FilmComboBox.ValueMember = "FilmId"; HallComboBox.DataSource = hallList.Halls; HallComboBox.DisplayMember = "HallName"; HallComboBox.ValueMember = "HallId"; AddButton.Visible = false; UpdateButton.Visible = false; DeleteButton.Visible = false; } }
private void SSHbtn_Click(object sender, EventArgs e) { Form frm = new ListOfHalls(); frm.Show(); }