public static void NewPassengers()
{
using (var ctx = new WWWingsContext())
{
Passenger p1 = new Passenger()
{
GivenName = "Igor", Surname = "Rsjt", Weight = 9
};
ctx.Add(p1);
Passenger p2 = new Passenger()
{
GivenName = "Toto", Surname = "Keller", Weight = 10
};
ctx.Add(p2);
Passenger p3 = new Passenger()
{
GivenName = "Anne", Surname = "Hanggg", Weight = 8
};
ctx.Add(p3);
Passenger p4 = new Passenger()
{
GivenName = "Sonia", Surname = "Chu", Weight = 6
};
ctx.Add(p4);
ctx.SaveChanges();
}
}
private static void NewPilots()
{
using (var ctx = new WWWingsContext())
{
Pilot p1 = new Pilot {
Surname = "Bono", GivenName = "Jean", Salary = 23000
};
ctx.PilotSet.Add(p1);
Pilot p2 = new Pilot {
Surname = "Tilde", GivenName = "Pierre", Salary = 4800
};
ctx.PilotSet.Add(p2);
ctx.SaveChanges();
}
}
private static void NewFlights()
{
using (var ctx = new WWWingsContext())
{
// on passe par le context pour accéder à la base de données
ctx.FlightSet.Add(new Flight {
Departure = "GVA", Destination = "LAX", Seats = 50, BasePrice = 200, PilotId = 1
});
ctx.FlightSet.Add(new Flight {
Departure = "GVA", Destination = "LAX", Seats = 20, BasePrice = 150, PilotId = 1
});
ctx.FlightSet.Add(new Flight {
Departure = "GVA", Destination = "Lausanne", Seats = 2, BasePrice = 50, PilotId = 2
});
// on persiste le changement dans la base de données
ctx.SaveChanges();
}
}
public static void NewBooking()
{
using (var ctx = new WWWingsContext())
{
ctx.BookingSet.Add(new Booking {
FlightNo = 1, PassengerID = 1, PricePaid = 50
});
ctx.BookingSet.Add(new Booking {
FlightNo = 1, PassengerID = 2, PricePaid = 40
});
ctx.BookingSet.Add(new Booking {
FlightNo = 2, PassengerID = 3, PricePaid = 50
});
ctx.BookingSet.Add(new Booking {
FlightNo = 2, PassengerID = 4, PricePaid = 90
});
ctx.SaveChanges();
}
}
