private void GetSetCountry()
{
using (var db = new Session3Entities())
{
var q = db.Countries.Select(x => x.Name).ToList();
cbPassport.DataSource = q;
}
}
private void GetSetCabin()
{
using (var db = new Session3Entities())
{
var q = db.CabinTypes.Select(x => x.Name).ToList();
cbCabin.DataSource = q;
}
}
private void GetSetAirports()
{
using (var db = new Session3Entities())
{
var q = db.Airports.Select(x => x.IATACode).ToList();
cbFrom.DataSource = q;
cbTo.BindingContext = new BindingContext();
cbTo.DataSource = q;
cbTo.SelectedIndex = 1;
}
cbTo.SelectedIndexChanged += checkFromTo;
cbFrom.SelectedIndexChanged += checkFromTo;
}
// Get all the flight details (migth be slow)
private List <FlightDetails> GetFlightDetails()
{
using (var db = new Session3Entities())
{
List <FlightDetails> q = new List <FlightDetails>();
q = db.Schedules.Select(x => new FlightDetails()
{
From = x.Route.Airport.IATACode,
To = x.Route.Airport1.IATACode,
Date = x.Date,
Time = x.Time,
FlightNumber = x.FlightNumber,
CabinPrice = (int)x.EconomyPrice,
NumberOfStops = 0
}).ToList();
return(q);
}
}
private void btnIssue_Click(object sender, EventArgs e)
{
try
{
using (var db = new Session3Entities())
{
string bookingReference = MakeBookingReference(6);
foreach (var p in booking.passengers)
{
int lastTicketID = db.Tickets.OrderByDescending(x => x.ID).FirstOrDefault().ID;
string[] outboundNumbers = booking.outboundFlight.FlightNumber.Split('-');
foreach (var item in outboundNumbers)
{
int sOutboundID = db.Schedules.FirstOrDefault(x => x.FlightNumber == item.Trim()).ID;
db.Tickets.Add(new Ticket
{
ID = lastTicketID + 1,
UserID = 1,
ScheduleID = sOutboundID,
CabinTypeID = db.CabinTypes.FirstOrDefault(x => x.Name == booking.cabinType).ID,
Firstname = p.FirstName,
Lastname = p.LastName,
PassportNumber = p.PassportNumber,
PassportCountryID = db.Countries.FirstOrDefault(x => x.Name == p.PassportCountry).ID,
BookingReference = bookingReference,
Confirmed = true,
Phone = p.Phone.Replace(" ", "")
});
db.SaveChanges();
}
if (booking.returnFlight != null)
{
string[] returnNumbers = booking.returnFlight.FlightNumber.Split('-');
foreach (var item in returnNumbers)
{
int sReturnID = db.Schedules.FirstOrDefault(x => x.FlightNumber == item.Trim()).ID;
db.Tickets.Add(new Ticket
{
ID = lastTicketID + 1,
UserID = 1,
ScheduleID = sReturnID,
CabinTypeID = db.CabinTypes.FirstOrDefault(x => x.Name == booking.cabinType).ID,
Firstname = p.FirstName,
Lastname = p.LastName,
PassportNumber = p.PassportNumber,
PassportCountryID = db.Countries.FirstOrDefault(x => x.Name == p.PassportCountry).ID,
BookingReference = bookingReference,
Confirmed = true,
Phone = p.Phone.Replace(" ", "")
});
db.SaveChanges();
}
}
}
}
MessageBox.Show("Success!");
}
catch (DbEntityValidationException ex)
{
var error = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
var fullError = string.Join("\n", error);
var exception = $"Error: {fullError}";
MessageBox.Show(exception);
}
}
