public static TripModel ChangeFlightData(TripModel oldFlightData)
{
if (ChangedFlight != null)
{
foreach (var p in oldFlightData.PassengersList)
{
Pass_in_trip pass_In_Trip = new Pass_in_trip {
trip_no = oldFlightData.TripNumber, place = p.SeatNumber, date = DateTime.Parse(oldFlightData.Date), ID_psg = p.Id
};
DAL.EditDB.DeletePassengerFromFlight(pass_In_Trip);
}
foreach (var p in ChangedFlight.PassengersList)
{
Pass_in_trip pass_In_Trip = new Pass_in_trip {
trip_no = ChangedFlight.TripNumber, place = p.SeatNumber, date = DateTime.Parse(ChangedFlight.Date), ID_psg = p.Id
};
DAL.EditDB.AddNewPassengerToFlight(ChangedFlight.TripNumber, DateTime.Parse(ChangedFlight.Date), p.Id, p.SeatNumber);
}
return(ChangedFlight);
}
else
{
return(null);
}
}
public static TripModel SaveNewFlight(TripModel newFlight)
{
foreach (var p in newFlight.PassengersList)
{
Pass_in_trip pass_In_Trip = new Pass_in_trip {
trip_no = newFlight.TripNumber, place = p.SeatNumber, date = DateTime.Parse(newFlight.Date), ID_psg = p.Id
};
DAL.EditDB.AddNewPassInFlight(pass_In_Trip);
}
return(newFlight);
}
private static Pass_in_trip ConvertToPassInTripType(PassengersInFlightModel pass, TripModel trip)
{
Pass_in_trip pass_In_Trip = new Pass_in_trip
{
trip_no = trip.TripNumber,
date = DateTime.Parse(trip.Date),
ID_psg = pass.Id,
place = pass.SeatNumber
};
return(pass_In_Trip);
}
public static void DeletePassenger(PassengersInFlightModel pass, TripModel trip)
{
Pass_in_trip passToDelete = ConvertToPassInTripType(pass, trip);
DAL.EditDB.DeletePassengerFromFlight(passToDelete);
}
