private static List <Trip> GetTripsListFromDataReader(SqlDataReader reader)
{
List <Trip> result = new List <Trip>();
while (reader.Read())
{
Driver dr = DriverDAL.GetDriverById(reader.GetInt32(2));
string fio = dr.Surname + " " + dr.Name[0] + "." + " " + dr.Patronymic[0] + ".";
Trip t = new Trip()
{
Id_Trip = reader.GetInt32(0),
Id_Id_Table = reader.GetInt32(1),
DStation = TrainTableDAL.GetTrainTableById(reader.GetInt32(1)).DepartureStation,
AStation = TrainTableDAL.GetTrainTableById(reader.GetInt32(1)).ArrivalStation,
Id_id_driver = reader.GetInt32(2),
Driver = fio,
Id_id_train = reader.GetInt32(3),
TrainNum = TrainDAL.GetTrainById(reader.GetInt32(3)).TrainNumber,
RealDepartureDate = reader.GetDateTime(4).ToShortDateString(),
RealDepartureTime = reader.GetValue(5).ToString(),
RealArrivalDate = reader.GetDateTime(6).ToShortDateString(),
RealArrivalTime = reader.GetValue(7).ToString(),
};
result.Add(t);
}
return(result);
}
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 UpdateDriver(string newValue)
{
switch (Type)
{
case DriverConst.Surname:
DriverDAL.UpdateSurname(newValue, Id);
break;
case DriverConst.Name:
DriverDAL.UpdateName(newValue, Id);
break;
case DriverConst.Patronymic:
DriverDAL.UpdatePatronymic(newValue, Id);
break;
case DriverConst.PhoneNumber:
DriverDAL.UpdatePhoneNumber(newValue, Id);
break;
}
}
private void DelDrivers(int id)
{
DriverDAL.Delete(id);
dgvRT.DataSource = DriverDAL.GetAllDrivers();
}
