public ListOfFilms ReadFilms()
{
List <Film> filmList = new List <Film>();
SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase);
using (connectToDateBase)
{
SqlCommand command = new SqlCommand(
"SELECT FILM_ID, NAME_FILM, LENGTH_FILM, AGE_LIMIT, TICKET_PRICE FROM [FILMS];",
connectToDateBase);
connectToDateBase.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Film film = new Film(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2),
reader.GetInt32(3), reader.GetInt32(4));
filmList.Add(film);
}
}
reader.Close();
}
ListOfFilms films = new ListOfFilms(filmList);
return(films);
}
public fAdminFilms(AuthorisedUser user)
{
InitializeComponent();
if (user.GetType() == typeof(AdminUser))
{
this.user = user;
//класс, считывающий данные из бд и это в List засунуть;
ReadingFromDateBase reading = new ReadingFromDateBase();
filmsList = reading.ReadFilms();
sourceData.DataSource = filmsList.Films;
dataGridViewFilm.DataSource = sourceData;
dataGridViewFilm.Columns[0].Visible = false;
dataGridViewFilm.Columns[1].HeaderText = "Название";
dataGridViewFilm.Columns[2].HeaderText = "Длительность";
dataGridViewFilm.Columns[3].HeaderText = "Ограничение";
dataGridViewFilm.Columns[4].HeaderText = "Цена";
}
else
{
this.user = user;
//класс, считывающий данные из бд и это в List засунуть;
ReadingFromDateBase reading = new ReadingFromDateBase();
filmsList = reading.ReadFilms();
sourceData.DataSource = filmsList.Films;
dataGridViewFilm.DataSource = sourceData;
dataGridViewFilm.Columns[0].Visible = false;
AddButton.Visible = false;
UpdateButton.Visible = false;
DeleteButton.Visible = false;
}
}
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;
}
}
