public ListOfPlacesInHalls ReadAllPlacesOfAllHalls()
{
List <PlaceInHall> placesList = new List <PlaceInHall>();
SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase);
using (connectToDateBase)
{
SqlCommand command = new SqlCommand(
"SELECT PLACE_ID, HALL_ID, ROW_PLACES, PLACE FROM [PLACESINHALLS];",
connectToDateBase);
connectToDateBase.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
PlaceInHall place = new PlaceInHall(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3));
placesList.Add(place);
}
}
reader.Close();
}
ListOfPlacesInHalls places = new ListOfPlacesInHalls(placesList);
return(places);
}
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;
}
}
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);
}
}
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);
}
}
