public void AddFlightRoute(string src, string dest)
{
using (var context = new Model1Container())
{
var ariportRoute = new Flight_Route() { SourceCode = src, DestinationCode = dest };
context.AddToFlight_Route(ariportRoute);
context.SaveChanges();
}
}
public void BookTicket(int customerId, ReservationTicket ticket)
{
using (var context = new Model1Container())
{
if (ticket.MealId == 0)
{
ticket.MealId = 1;
}
var cusomter = context.Passengers.Where(p => p.Id == customerId).Single();
var ticket_table = new Ticket
{
IsCancelled = false,
MealId = ticket.MealId,
PricePaid = ticket.PricePaid,
SeatId = ticket.SeatId,
TicketedTime = DateTime.Now,
PassengerId = customerId
};
ticket_table.Meal_Preference = new Meal_Preference { Id = ticket.MealId, MealType = "Veg" };
cusomter.Tickets.Add(ticket_table);
var seat = context.Fligt_Leg_Seat_Assignment.Where(p => p.Id == ticket.SeatId).Single();
seat.IsAvailable = false;
var flightLeg = context.Flight_Leg.Where(p => p.Id == ticket.FlightLegId).Single();
flightLeg.AvailableSeats = flightLeg.AvailableSeats - 1;
context.SaveChanges();
}
}
public List<Customer> SaveCustomers(List<Customer> customers)
{
using (var context = new Model1Container())
{
foreach (var customer in customers)
{
context.Passengers.AddObject(new Passenger
{
FirstName = customer.FirstName,
LastName = customer.LastName,
DateofBirth = customer.DateOfBirth,
email = customer.Email,
address = customer.Address,
phone = customer.Phone
});
}
context.SaveChanges();
foreach (var item in context.Passengers)
{
var customer = customers.SingleOrDefault(p => p.FirstName.Equals(item.FirstName) && p.LastName.Equals(item.LastName) && p.DateOfBirth.Date == item.DateofBirth.Date);
if (customer != null)
{
customer.Id = item.Id;
}
}
}
return customers;
}
public int SearchRoute(string srcAirportCode, string destAirportCode)
{
int routeCode = -1;
using (var context = new Model1Container())
{
var flightRoute = context.Flight_Route.Where(p => p.SourceCode.Equals(srcAirportCode, StringComparison.OrdinalIgnoreCase) && p.DestinationCode.Equals(destAirportCode, StringComparison.OrdinalIgnoreCase)).SingleOrDefault();
if (flightRoute != null)
{
routeCode = flightRoute.Id;
}
}
return routeCode;
}
public List<FlightSeat> GetFlightSeats(int flightLegId)
{
List<FlightSeat> flightSeats = null;
using (var context = new Model1Container())
{
var flight_seats = context.Fligt_Leg_Seat_Assignment.Where(p => p.Flight_Leg_Id == flightLegId);
if (flight_seats != null)
{
flightSeats = new List<FlightSeat>();
foreach (var seat in flight_seats)
{
var flightSeat = new FlightSeat()
{
Id = seat.Id,
FlightLegId = flightLegId,
IsAvailable = seat.IsAvailable,
IsCurrentSelection = false,
SeatingClass = seat.SeatingClass,
SeatingType = seat.SeatType,
SeatNumber = seat.SeatNumber
};
flightSeats.Add(flightSeat);
}
}
}
return flightSeats;
}
public List<Meal> GetMealPreferences()
{
List<Meal> meals = new List<Meal>();
using (var context = new Model1Container())
{
var meal_pref = from p in context.Meal_Preference select p;
foreach (var item in meal_pref)
{
meals.Add(new Meal { Id = item.Id, MealType = item.MealType });
}
}
return meals;
}
public List<Customer> GetFlightPassengers(FlightLeg flightLeg)
{
List<Customer> customers = new List<Customer>();
using (var context = new Model1Container())
{
List<Passenger> passengers = new List<Passenger>();
List<Ticket> tickets = new List<Ticket>();
var flightSeats = from p in context.Fligt_Leg_Seat_Assignment where
( p.Flight_Leg_Id == flightLeg.Id && !p.IsAvailable) select p.Id;
foreach (var seatId in flightSeats)
{
var ticket = context.Tickets.Where(p => p.SeatId == seatId).SingleOrDefault();
if (ticket != null)
{
tickets.Add(ticket);
}
}
foreach (var ticket in tickets)
{
var passenger = context.Passengers.Where(p => p.Id == ticket.PassengerId).SingleOrDefault();
if (passenger != null)
{
passengers.Add(passenger);
}
}
foreach (var passenger in passengers)
{
customers.Add(new Customer
{ FirstName = passenger.FirstName,
LastName = passenger.LastName,
Id = passenger.Id,
Email = passenger.email,
Phone = passenger.phone,
Address = passenger.address,
DateOfBirth = passenger.DateofBirth
});
}
}
return customers;
}
public List<FlightRoute> GetFlightRoutes()
{
List<FlightRoute> flightRoutes = new List<FlightRoute>();
using (var context = new Model1Container())
{
var dbFlightRoutes = context.Flight_Route.Where(p => p.Id != null);
foreach (var item in dbFlightRoutes)
{
FlightRoute flightRoute = new FlightRoute() { Id = item.Id, DestinationCode = item.DestinationCode, SourceCode = item.SourceCode };
flightRoutes.Add(flightRoute);
}
}
return flightRoutes;
}
public List<FlightLeg> GetFlightLegs(int flightRouteId)
{
List<FlightLeg> flightLegs = null;
using (var context = new Model1Container())
{
var flight_legs = context.Flight_Leg.Where(p => p.Flight_Route_Id == flightRouteId);
if (flight_legs != null)
{
flightLegs = new List<FlightLeg>();
foreach (var leg in flight_legs)
{
var flightLeg = new FlightLeg()
{
FlightNumber = leg.FlightNumber,
TravelDate = leg.Date,
ScheduledArrivalTime = leg.ScheduledArrivalTime,
ScheduledDepartureTime = leg.ScheduledDepartureTime,
Id = leg.Id,
Fare = leg.Fare,
AvailableSeats = leg.AvailableSeats
};
flightLegs.Add(flightLeg);
}
}
}
return flightLegs;
}
public List<FlightLeg> GetFlightLegs()
{
List<FlightLeg> flightlegs = new List<FlightLeg>();
using (var dataContext = new Model1Container())
{
var legs = from p in dataContext.Flight_Leg select p;
foreach (var leg in legs)
{
FlightLeg flightLeg = new FlightLeg
{
FlightNumber = leg.FlightNumber,
TravelDate = leg.Date,
ScheduledArrivalTime = leg.ScheduledArrivalTime,
ScheduledDepartureTime = leg.ScheduledDepartureTime,
Id = leg.Id,
Fare = leg.Fare,
AvailableSeats = leg.AvailableSeats,
FlightRouteId = leg.Flight_Route_Id
};
flightlegs.Add(flightLeg);
}
}
return flightlegs;
}
public List<AirportInfo> GetAirports()
{
List<AirportInfo> airports = new List<AirportInfo>();
using (var dataContext = new Model1Container())
{
var dbAirports = dataContext.Airports.Where(p => p.Code != null);
foreach (var item in dbAirports)
{
airports.Add(new AirportInfo { Id = item.Id, Name = item.Name, Code = item.Code, City = item.City, State = item.State });
}
}
return airports;
}
public void AddFlightLeg(FlightLeg flightLeg)
{
var newFlightLeg = new Flight_Leg();
using (var dataContext = new Model1Container())
{
newFlightLeg.AvailableSeats = flightLeg.SelectedPlane.NoOfSeats;
newFlightLeg.Date = flightLeg.TravelDate;
newFlightLeg.Fare = 300;
newFlightLeg.IsCancelled = false;
newFlightLeg.IsRescheduled = false;
newFlightLeg.Flight_Route_Id = flightLeg.SelectedRoute.Id;
newFlightLeg.FlightNumber = (short)flightLeg.FlightNumber;
newFlightLeg.ScheduledDepartureTime = flightLeg.ScheduledDepartureTime;
newFlightLeg.ScheduledArrivalTime = flightLeg.ScheduledArrivalTime;
dataContext.Flight_Leg.AddObject(newFlightLeg);
//dataContext.AddToFlight_Leg(newFlightLeg);
dataContext.SaveChanges();
for (int row = 0; row < flightLeg.SelectedPlane.TotalRows; row++)
{
for (int col = 0; col < flightLeg.SelectedPlane.TotalColumns; col++)
{
string seatNumber = "";
if (col == 0)
{
seatNumber = string.Format("{0}{1}", row+1, "A");
}
if (col == 1)
{
seatNumber = string.Format("{0}{1}", row + 1, "B");
}
if (col == 2)
{
seatNumber = string.Format("{0}{1}", row + 1, "C");
}
if (col == 3)
{
seatNumber = string.Format("{0}{1}", row + 1, "D");
}
if (col == 4)
{
seatNumber = string.Format("{0}{1}", row + 1, "E");
}
if (col == 5)
{
seatNumber = string.Format("{0}{1}", row + 1, "F");
}
dataContext.AddToFligt_Leg_Seat_Assignment(new Fligt_Leg_Seat_Assignment { SeatingClass = "Economy", Flight_Leg_FlightNumber=newFlightLeg.FlightNumber, SeatNumber = seatNumber, Flight_Leg_Id = newFlightLeg.Id, IsAvailable = true, SeatType = "Normal" });
//dataContext.AddToFligt_Leg_Seat_Assignment(new Fligt_Leg_Seat_Assignment { SeatingClass = "Economy", Flight_Leg_Id = newFlightLeg.Id, SeatNumber = seatNumber, IsAvailable = true, SeatType = "Normal" });
}
}
dataContext.SaveChanges();
}
}
public List<Airplane> GetAirplanes()
{
List<Airplane> airPlanes = new List<Airplane>();
using (var context = new Model1Container())
{
var dbAirplanes= context.Airplane_Info.Where(p => p.PlaneId != null);
foreach (var item in dbAirplanes)
{
Airplane airplane = new Airplane() { PlaneId = item.PlaneId,
NoOfSeats = item.NoOfSeats,
LeftColumns = Convert.ToInt32(item.NoOfLeftCol),
TotalColumns = Convert.ToInt32(item.NoOfColumns),
AirplaneNumber = item.PlaneId.ToString(),
Model = item.Model,
TotalRows = Convert.ToInt32(item.NoOfRows) };
airPlanes.Add(airplane);
}
}
return airPlanes;
}
