Example #1
0
 private void btnDelTableRow_Click(object sender, EventArgs e)
 {
     if (btnDelTableRow.Text == "Изменить")
     {
         ChangeTableCell();
     }
     else
     {
         TrainTableDAL.Delete((dgvTable.SelectedCells[0].OwningRow.DataBoundItem as TrainTable).Id_Table);
         dgvTable.DataSource = TrainTableDAL.GetAllTrainTables();
         MessageBox.Show("Строка удалена");
     }
 }
Example #2
0
 private void DataGridVeiwFilling()
 {
     dgvRT.AutoGenerateColumns      = false;
     dgvRT.DataSource               = PassengerDAL.GetAllPassengers();
     dgvTable.AutoGenerateColumns   = false;
     dgvTable.DataSource            = TrainTableDAL.GetAllTrainTables();
     dgvCT.AutoGenerateColumns      = false;
     dgvCT.DataSource               = CanceledTripDAL.GetAllCancelledTrips();
     dgvTrips.AutoGenerateColumns   = false;
     dgvTrips.DataSource            = TripDAL.GetAllTrips();
     dgvTickets.AutoGenerateColumns = false;
     dgvTickets.DataSource          = TicketDAL.GetAllTickets();
 }
Example #3
0
        private void ChangeTableCell()
        {
            string        type  = dgvTable.SelectedCells[0].OwningColumn.Name;
            string        value = dgvTable.SelectedCells[0].Value.ToString();
            int           id    = (dgvTable.SelectedCells[0].OwningRow.DataBoundItem as TrainTable).Id_Table;
            fmChangeTable f     = new fmChangeTable(type, value, id);

            f.Text = dgvTable.SelectedCells[0].OwningColumn.HeaderText;
            if (f.ShowDialog() == DialogResult.OK)
            {
                MessageBox.Show("Значение изменено");
                dgvTable.DataSource = TrainTableDAL.GetAllTrainTables();
            }
        }
Example #4
0
        private void SearchTableByStations()
        {
            int IdDepartureStation = cbTableDS.SelectedIndex != 0  ? StationDAL.GetStationByName(cbTableDS.Text).Id_Station : 0;
            int IdArrivalStation   = cbTableAS.SelectedIndex != 0 ? StationDAL.GetStationByName(cbTableAS.Text).Id_Station : 0;

            if (cbTableDS.SelectedIndex != 0 && cbTableAS.SelectedIndex != 0)
            {
                dgvTable.DataSource = TrainTableDAL.GetTrainTablesByStation(IdDepartureStation, IdArrivalStation);
                return;
            }
            if (cbTableAS.SelectedIndex != 0)
            {
                dgvTable.DataSource = TrainTableDAL.GetTrainTablesByAStation(IdArrivalStation);
                return;
            }
            if (cbTableDS.SelectedIndex != 0)
            {
                dgvTable.DataSource = TrainTableDAL.GetTrainTablesByDStation(IdDepartureStation);
                return;
            }
            dgvTable.DataSource = TrainTableDAL.GetAllTrainTables();
        }