private void UpdateTicket(int newVId, string newValue)
{
switch (Type)
{
case TicketConst.Trip:
TicketDAL.UpdateTrip(int.Parse(newValue), Id);
break;
case TicketConst.Passenger:
TicketDAL.UpdatePassenger(PassengerDAL.GetAllPassengers()[newVId].Id_Passenger, Id);
break;
case TicketConst.LandingStation:
TicketDAL.UpdateLS(IntermediateStationDAL.GetAllIntermediateStations()[newVId].Id_IntermediateStation, Id);
break;
case TicketConst.ExitStation:
TicketDAL.UpdateES(IntermediateStationDAL.GetAllIntermediateStations()[newVId].Id_IntermediateStation, Id);
break;
case TicketConst.Price:
TicketDAL.UpdatePrice(int.Parse(newValue), Id);
break;
case TicketConst.CarriageType:
TicketDAL.UpdateType(CarriageTypeDAL.GetAllCarriageTypes()[newVId].Id_CarriageType, Id);
break;
case TicketConst.PlaseNumber:
TicketDAL.UpdatePlaseNumber(int.Parse(newValue), Id);
break;
}
}
private void FillingIntermediateStations()
{
foreach (IntermediateStation i in IntermediateStationDAL.GetAllIntermediateStations())
{
cbNew.Items.Add(StationDAL.GetStationByIntermediateStation(i.Id_IntermediateStation).Name);
}
}
private void IntermediateStationsFilling()
{
foreach (IntermediateStation i in IntermediateStationDAL.GetAllIntermediateStations())
{
cbTicDS.Items.Add(StationDAL.GetStationByIntermediateStation(i.Id_IntermediateStation).Name);
cbTicAS.Items.Add(StationDAL.GetStationByIntermediateStation(i.Id_IntermediateStation).Name);
}
cbTicDS.SelectedIndex = cbTicAS.SelectedIndex = 0;
}
private bool TicketSearchByArrivalStation()
{
if (cbTicAS.SelectedIndex != 0)
{
dgvTickets.DataSource = TicketDAL.GetTicketsByAs(IntermediateStationDAL.GetIntermediateStationByName(cbTicAS.Text).Id_IntermediateStation);
return(true);
}
return(false);
}
private bool TicketSearchByArrivalStationAndPrise()
{
if (cbTicAS.SelectedIndex != 0 && GetPrice() != null)
{
dgvTickets.DataSource = TicketDAL.GetTicketsByAsPrice(IntermediateStationDAL.GetIntermediateStationByName(cbTicAS.Text).Id_IntermediateStation, GetPrice());
return(true);
}
return(false);
}
private void btnISAddStation_Click(object sender, EventArgs e)
{
if (btnISAddStation.Text == "Добавить")
{
AddStation();
}
else
{
dgvIS.DataSource = IntermediateStationDAL.GetIntermediateStationsByTrip(Id_Trip);
}
}
private void InsertTicket()
{
int price = int.Parse(tbPrice.Text);
int FIO = PassengerDAL.GetAllPassengers()[cbFIO.SelectedIndex].Id_Passenger;
int trip = int.Parse(cbNumTrip.Text);
int dSt = IntermediateStationDAL.GetIntermediateStationByName(cbDS.Text).Id_IntermediateStation;
int aSt = IntermediateStationDAL.GetIntermediateStationByName(cbAS.Text).Id_IntermediateStation;
int type = CarriageTypeDAL.GetCarriageTypeByType(cbType.Text).Id_CarriageType;
int plaseNum = int.Parse(nPlase.Value.ToString());
TicketDAL.Insert(price, FIO, trip, dSt, aSt, type, plaseNum);
}
private void AddStation()
{
if (!GetStation())
{
return;
}
int idStation = StationDAL.GetStationByName(cbStation.Text).Id_Station;
string departureDate = dtpIS2.Text;
string departureTime = dtpIS1.Text;
string arrivalDate = dtpIS4.Text;
string arrivalTime = dtpIS3.Text;
IntermediateStationDAL.Insert(idStation, Id_Trip, departureDate, departureTime, arrivalDate, arrivalTime);
MessageBox.Show("Строка добавлена");
dgvIS.DataSource = IntermediateStationDAL.GetIntermediateStationsByTrip(Id_Trip);;
}