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 static List <Ticket> GetTicketsListFromDataReader(SqlDataReader reader)
{
List <Ticket> result = new List <Ticket>();
while (reader.Read())
{
Ticket t = new Ticket()
{
Id_Ticket = reader.GetInt32(0),
Passenger = PassengerDAL.GetPassengerById(reader.GetInt32(2)).Surname.Trim(' ') + ' ' + PassengerDAL.GetPassengerById(reader.GetInt32(2)).Name[0] + '.' + PassengerDAL.GetPassengerById(reader.GetInt32(2)).Patronymic[0] + '.',
Id_id_Trip = reader.GetInt32(3),
LandingStation = StationDAL.GetStationByIntermediateStation(reader.GetInt32(4)).Name,
ExitStation = StationDAL.GetStationByIntermediateStation(reader.GetInt32(5)).Name,
CarriageType = CarriageTypeDAL.GetCarriageTypeById(reader.GetInt32(6)).Type,
PlaseNumber = reader.GetInt32(7),
Price = reader.GetInt32(1),
};
result.Add(t);
}
return(result);
}
