private void AddDrivers() { if (String.IsNullOrEmpty(tbRTSurname.Text)) { MessageBox.Show("Введите фамилию!"); return; } if (String.IsNullOrEmpty(tbRTName.Text)) { MessageBox.Show("Введите имя!"); return; } if (String.IsNullOrEmpty(tbRTPatronymic.Text)) { MessageBox.Show("Введите отчество!"); return; } if (String.IsNullOrEmpty(tbRTPassport.Text)) { MessageBox.Show("Введите номер телефона!"); return; } string surname = tbRTSurname.Text; string name = tbRTName.Text; string patronymic = tbRTPatronymic.Text; string phoneNumber = tbRTPassport.Text; DriverDAL.Insert(surname, name, patronymic, phoneNumber); dgvRT.DataSource = DriverDAL.GetAllDrivers(); ClearText(); }
private void FillingDriver() { foreach (Driver dr in DriverDAL.GetAllDrivers()) { cbDriver.Items.Add(dr.Surname + " " + dr.Name[0] + "." + " " + dr.Patronymic[0] + "."); } }
private void DriversFilling() { foreach (Driver dr in DriverDAL.GetAllDrivers()) { cbTripsDriver.Items.Add(dr.Surname + " " + dr.Name[0] + "." + " " + dr.Patronymic[0] + "."); } cbTripsDriver.SelectedIndex = 0; }
private void VisibleDrivers() { dgvRT.Columns[3].DataPropertyName = "PhoneNumber"; dgvRT.Columns[3].Name = "PhoneNumber"; dgvRT.Columns[3].HeaderText = "Телефон"; lbRTPassport.Text = "Телефон"; dgvRT.DataSource = DriverDAL.GetAllDrivers(); }
/*private void AddSoftCount(int idAddedTrip) * { * int cnt = int.Parse(numericUpDown1.Value.ToString()); * foreach (CarriageType t in CarriageTypeDAL.GetAllCarriageTypes()) * { * if (t.Type.Trim() == CarriageTypeConst.Soft) Trip_CarriageDAL.Insert(t.Id_CarriageType, idAddedTrip, cnt); * } * } * * private void AddCoupeCount(int idAddedTrip) * { * int cnt = int.Parse(numericUpDown2.Value.ToString()); * foreach (CarriageType t in CarriageTypeDAL.GetAllCarriageTypes()) * { * if (t.Type.Trim() == CarriageTypeConst.Coupe)Trip_CarriageDAL.Insert(t.Id_CarriageType, idAddedTrip, cnt); * } * } * * private void AddLuxCount(int idAddedTrip) * { * int cnt = int.Parse(numericUpDown3.Value.ToString()); * foreach (CarriageType t in CarriageTypeDAL.GetAllCarriageTypes()) * { * if (t.Type.Trim() == CarriageTypeConst.Lux)Trip_CarriageDAL.Insert(t.Id_CarriageType, idAddedTrip, cnt); * } * } * * private void AddSittingCount(int idAddedTrip) * { * int cnt = int.Parse(numericUpDown4.Value.ToString()); * foreach (CarriageType t in CarriageTypeDAL.GetAllCarriageTypes()) * { * if (t.Type.Trim() == CarriageTypeConst.Sitting)Trip_CarriageDAL.Insert(t.Id_CarriageType, idAddedTrip, cnt); * } * } * * private void AddReserverSeatCount(int idAddedTrip) * { * int cnt = int.Parse(numericUpDown5.Value.ToString()); * foreach (CarriageType t in CarriageTypeDAL.GetAllCarriageTypes()) * { * if (t.Type.Trim() == CarriageTypeConst.ReserverSeat)Trip_CarriageDAL.Insert(t.Id_CarriageType, idAddedTrip, cnt); * } * } * * private void AddCarriageCount() * { * int id = TripDAL.GetAllTrips()[TripDAL.GetAllTrips().Count - 1].Id_Trip; * AddCoupeCount(id); * AddLuxCount(id); * AddReserverSeatCount(id); * AddSittingCount(id); * AddSoftCount(id); * }*/ private void InsertTrip() { int driver = DriverDAL.GetAllDrivers()[cbDriver.SelectedIndex].Id_Driver; int train = TrainDAL.GetAllTrains()[cbTrain.SelectedIndex].Id_Train; string departureDate = dtpDate1.Text; string departureTime = dtpTime1.Text; string arrivalDate = dtpDate2.Text; string arrivalTime = dtpTime2.Text; TripDAL.Insert(Id_Table, driver, train, departureDate, departureTime, arrivalDate, arrivalTime); }
private void updateDriver() { string type = dgvRT.SelectedCells[0].OwningColumn.Name; string value = dgvRT.SelectedCells[0].Value.ToString(); Type typeTable = dgvRT.SelectedCells[0].OwningRow.DataBoundItem.GetType(); int id = (dgvRT.SelectedCells[0].OwningRow.DataBoundItem as Driver).Id_Driver; fmChangeValueRT f = new fmChangeValueRT(type, value, id, typeTable); f.Text = dgvRT.SelectedCells[0].OwningColumn.HeaderText; if (f.ShowDialog() == DialogResult.OK) { MessageBox.Show("Значение изменено"); dgvRT.DataSource = DriverDAL.GetAllDrivers(); } }
private void SearchByDriverAndTrain() { int idDriver = cbTripsDriver.SelectedIndex != 0 ? DriverDAL.GetAllDrivers()[cbTripsDriver.SelectedIndex].Id_Driver: 0; int idTrain = cbTripsTrain.SelectedIndex != 0? idTrain = TrainDAL.GetAllTrains()[cbTripsTrain.SelectedIndex].Id_Train : 0; if (cbTripsDriver.SelectedIndex != 0 && cbTripsTrain.SelectedIndex != 0) { dgvTrips.DataSource = TripDAL.GetTripsByDriverAndTrain(idDriver, idTrain); } if (cbTripsTrain.SelectedIndex != 0) { dgvTrips.DataSource = TripDAL.GetTripsByTrain(idTrain); } if (cbTripsDriver.SelectedIndex != 0) { dgvTrips.DataSource = TripDAL.GetTripsByDriver(idDriver); } }
private void DelDrivers(int id) { DriverDAL.Delete(id); dgvRT.DataSource = DriverDAL.GetAllDrivers(); }