public fCashiers(AuthorisedUser user)
{
InitializeComponent();
if (user.GetType() == typeof(AdminUser))
{
this.user = user;
//класс, считывающий данные из бд и это в List засунуть;
ReadingFromDateBase reading = new ReadingFromDateBase();
reading.ReadFromDateBase();
cashiersList = new ListOfCashiers(reading.cashierList);
sourceData.DataSource = cashiersList.Cashiers;
dataGridViewCashiers.DataSource = sourceData;
dataGridViewCashiers.Columns[0].Visible = false;
dataGridViewCashiers.Columns[1].HeaderText = "Фамилия";
dataGridViewCashiers.Columns[2].HeaderText = "Имя";
dataGridViewCashiers.Columns[3].HeaderText = "Отчество";
dataGridViewCashiers.Columns[4].Visible = false;
dataGridViewCashiers.Columns[5].HeaderText = "Логин";
dataGridViewCashiers.Columns[6].HeaderText = "Пароль";
}
else
{
//класс, считывающий данные из бд и это в List засунуть;
MessageBox.Show("Запрещено");
this.Close();
}
}
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 fPercents(AuthorisedUser user)
{
InitializeComponent();
if (user.GetType() == typeof(AdminUser))
{
this.user = user;
ReadingFromDateBase reading = new ReadingFromDateBase();
percentList = reading.ReadPercentages();
sourceData.DataSource = percentList.Percents;
dataGridViewPercents.DataSource = sourceData;
dataGridViewPercents.Columns[0].Visible = false;
dataGridViewPercents.Columns[1].HeaderText = "Скидка/Наценка";
dataGridViewPercents.Columns[2].HeaderText = "Описание";
dataGridViewPercents.Columns[3].HeaderText = "Процент";
}
else
{
this.user = user;
ReadingFromDateBase reading = new ReadingFromDateBase();
percentList = reading.ReadPercentages();
sourceData.DataSource = percentList.Percents;
dataGridViewPercents.DataSource = sourceData;
dataGridViewPercents.Columns[0].Visible = false;
dataGridViewPercents.Columns[1].HeaderText = "Скидка/Наценка";
dataGridViewPercents.Columns[2].HeaderText = "Описание";
dataGridViewPercents.Columns[3].HeaderText = "Процент";
AddButton.Visible = false;
UpdateButton.Visible = false;
DeleteButton.Visible = false;
this.Close();
}
}
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 fTickets(AuthorisedUser user)
{
InitializeComponent();
this.user = user;
ReadingFromDateBase reading = new ReadingFromDateBase();
ticketsList = reading.ReadTickets();
percentsList = reading.ReadPercentages();
totalPercentList = reading.ReadTotalPercents();
statusTicketList = reading.ReadStatusTickets();
sessionList = reading.ReadSessions();
LoadDataGridView();
}
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 DeleteButton_Click(object sender, EventArgs e)
{
ClearAllTextBoxesAndGroupBox();
if (indexRow != -1)
{
DeletingFromDateBase deleting = new DeletingFromDateBase();
deleting.DeleteFromDatabase(hallsList.Halls[indexRow]);
deleting.DeleteFromDatabase(hallsList.Halls[indexRow].Places);
hallsList.Halls.RemoveAt(indexRow);
ReadingFromDateBase reading = new ReadingFromDateBase();
placesList = reading.ReadAllPlacesOfAllHalls();
sourceData.ResetBindings(false);
}
}
public Logining(string login, string password)
{
ReadingFromDateBase readBase = new ReadingFromDateBase();
readBase.ReadFromDateBase();
CheckingAuthorization checking = new CheckingAuthorization(readBase, login, password);
status = checking.CheckAuthorization();
LastName = checking.lastName;
SecondName = checking.secondName;
FirstName = checking.firstName;
Login = checking.login;
Password = checking.password;
UserId = checking.userId;
}
public fTickets(AuthorisedUser user, Session session, int row, int placeNumber, double price)
{
InitializeComponent();
this.user = user;
ReadingFromDateBase reading = new ReadingFromDateBase();
ticketsList = reading.ReadTickets();
percentsList = reading.ReadPercentages();
totalPercentList = reading.ReadTotalPercents();
statusTicketList = reading.ReadStatusTickets();
sessionList = reading.ReadSessions();
LoadDataGridView();
SessionInput.Text = session.FilmSession.FilmName;
RowInput.Text = row.ToString();
PlaceNumberInput.Text = placeNumber.ToString();
PriceInput.Text = price.ToString();
TicketInput.Text = (ticketsList.Tickets.Count() + 1).ToString();
}
private void UpdateButton_Click(object sender, EventArgs e)
{
if (indexRow != -1)
{
hallsList.Halls[indexRow].HallName = NameHallInput.Text;
hallsList.Halls[indexRow].PlacesInRow = Convert.ToInt32(PlacesInRowInput.Text);
hallsList.Halls[indexRow].SeatingCapacity = Convert.ToInt32(SeatingCapacityInput.Text);
UpdatingDataBase updating = new UpdatingDataBase();
updating.UpdateInDatabase(hallsList.Halls[indexRow]);
sourceData.ResetBindings(false); //подтверждает изменения
HallPlaces.Controls.Clear();
DeletingFromDateBase deleting = new DeletingFromDateBase();
deleting.DeleteFromDatabase(hallsList.Halls[indexRow].Places);
hallsList.Halls[indexRow].Places.Clear();
ReadingFromDateBase reading = new ReadingFromDateBase();
placesList = reading.ReadAllPlacesOfAllHalls();
FillingPlaces(hallsList.Halls[indexRow]);
LoadSchemeOfHall(hallsList.Halls[indexRow].SeatingCapacity, hallsList.Halls[indexRow].PlacesInRow);
}
}
private void CreatePlaces()
{
ListOfPlacesInHalls placesList;
ReadingFromDateBase reading = new ReadingFromDateBase();
placesList = reading.ReadAllPlacesOfAllHalls();
int placeId = 1;
if (placesList.Places.Count != 0)
{
placeId = placesList.Places.Count + 1;
}
bool notEven = false;
int leftPlaces = SeatingCapacity % PlacesInRow;
int tempPlacesInRow = PlacesInRow;
int rows = 0;
if (leftPlaces != 0)
{
notEven = true;
rows = (SeatingCapacity / PlacesInRow) + 1;
}
else
{
rows = SeatingCapacity / PlacesInRow;
}
for (int i = 1; i <= rows; i++)
{
if (i == rows && notEven)
{
tempPlacesInRow = leftPlaces;
}
for (int j = 1; j <= tempPlacesInRow; j++)
{
PlaceInHall place = new PlaceInHall(placeId, HallId, i, j);
Places.Add(place);
}
}
}
