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