public void AddEntriesToFlightEmployees(List <Employee> Employees, int FlightId)
{
for (int i = 0; i < Employees.Count(); i++)
{
FlightEmployee NewFlightEmployee = new FlightEmployee
{
FlightId = FlightId,
EmployeeId = Employees[i].Id
};
_context.Add(NewFlightEmployee);
_context.SaveChanges();
}
}
public static async Task <string> addFlightToDatabase(WebhookRequest request, FlightsAPIContext _apiContext, FlightContext _dbContext)
{
// Extracts the parameters of the request
var requestParameters = request.QueryResult.Parameters;
string fromCity = requestParameters.Fields["from-city"].StringValue;
string toCity = requestParameters.Fields["to-city"].StringValue;
DateTime departure = DateTimeOffset.Parse(requestParameters.Fields["date-time"].StringValue).UtcDateTime.Date;
var flight = await _apiContext.GetFlight(fromCity, toCity, departure);
if (flight.Quotes.Any())
{
FlightModel flightItem = new FlightModel
{
FromCity = flight.Places.Where(p => p.PlaceId == flight.Quotes[0].OutboundLeg.OriginId).First().Name,
ToCity = flight.Places.Where(p => p.PlaceId == flight.Quotes[0].OutboundLeg.DestinationId).First().Name,
DepartureDate = flight.Quotes[0].OutboundLeg.DepartureDate.Date,
Price = flight.Quotes[0].MinPrice,
};
_dbContext.Add(flightItem);
await _dbContext.SaveChangesAsync();
textToReturn = "Done!";
}
else
{
textToReturn = "Could not add a flight";
}
return(textToReturn);
}
// POST
public void Add(Plane newPlane)
{
// define function for generating a random identifier
const string LetterPool = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
const string NumberPool = "1234567890";
Random random = new Random();
string RandomString(int Length)
{
string part1 = new string(Enumerable.Repeat(NumberPool, Length / 2)
.Select(s => s[random.Next(s.Length)]).ToArray());
string part2 = new string(Enumerable.Repeat(LetterPool, Length / 2)
.Select(s => s[random.Next(s.Length)]).ToArray());
return(part1 + part2);
}
bool NoMatch = true;
// Fetch all identifiers
var Identifiers = _context.Planes.Select(plane => plane.Identifier).ToList();
while (NoMatch)
{
// If random identifier doesnt exist in database, bind it and persist newPlane
string RandomIndentifier = RandomString(6);
if (!Identifiers.Contains(RandomIndentifier))
{
newPlane.Identifier = RandomIndentifier;
NoMatch = false;
}
}
_context.Add(newPlane);
_context.SaveChanges();
}
// POST
public void Add(Employee NewEmployee)
{
// define function for generating a random number
const string chars = "0123456789";
Random random = new Random();
string RandomString(int length)
{
return(new string(Enumerable.Repeat(chars, length)
.Select(s => s[random.Next(s.Length)]).ToArray()));
}
bool noMatch = true;
// Fetch all emplyee numbers
var employeeNumbers = _context.Employees.Select(employee => employee.EmployeeNumber).ToList();
while (noMatch)
{
// If random number doesnt exist in database, bind it and persist newEmployee
string randomNumber = RandomString(5);
if (!employeeNumbers.Contains(randomNumber))
{
NewEmployee.EmployeeNumber = randomNumber;
noMatch = false;
}
}
_context.Add(NewEmployee);
_context.SaveChanges();
}
public void CreateFlight(Flight flight)
{
using (FlightContext dbContext = new FlightContext())
{
dbContext.Add <Flight>(flight);
dbContext.SaveChanges();
}
}
public async Task <IActionResult> Create([Bind("ID,From,To,Stops,Price,departing,arrival,seatsAvailable")] AirRoutes airRoutes)
{
if (ModelState.IsValid)
{
_context.Add(airRoutes);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(airRoutes));
}
public async Task <IActionResult> Create([Bind("ID,FlightID,Origin,Destination,Date,DepartureTime,ArrivalTime,DistanceTravelled")] Flight flight)
{
if (ModelState.IsValid)
{
_context.Add(flight);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(flight));
}
public async Task <IActionResult> Create([Bind("FlightId,AircraftType,FromLocation,ToLocation,DepartureTime,ArrivalTime")] Flight flight)
{
if (ModelState.IsValid)
{
_context.Add(flight);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(flight));
}
public async Task <IActionResult> Create([Bind("FlightTicketID,FlightNumber,FlightDestination")] FlightTicket flightTicket)
{
if (ModelState.IsValid)
{
_context.Add(flightTicket);
_logger.LogInformation("Added flight");
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(flightTicket));
}
public async Task <IActionResult> Create([Bind("RouteID,FromCityID,ToCityID,BasicFare,AveDuration")] Route route)
{
if (ModelState.IsValid)
{
_context.Add(route);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["FromCityID"] = new SelectList(_context.Cities, "CityID", "Name", route.FromCityID);
ViewData["ToCityID"] = new SelectList(_context.Cities, "CityID", "Name", route.ToCityID);
return(View(route));
}
public async Task <IActionResult> Create([Bind("CityID,Name,AirportName,PostCode,StateOrTerritory,State")] City city)
{
city.State = city.StateOrTerritory.ToString();
if (ModelState.IsValid)
{
_context.Add(city);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(city));
}
public async Task <IActionResult> Create([Bind("Id,Name,Email,FlightTicketID")] Reservation reservation)
{
if (ModelState.IsValid)
{
_context.Add(reservation);
_logger.LogInformation("added booking");
await _context.SaveChangesAsync();
var ticket = (from f in _context.Reservations
where f.Id == reservation.Id
select f).First();
return(RedirectToAction("Edit", "Reservations", ticket));
}
ViewData["FlightTicketID"] = new SelectList(_context.FlightTickets, "FlightTicketID", "FlightTicketID", reservation.FlightTicketID);
return(View(reservation));
}
public async Task <IActionResult> Create(int FromCityID, int ToCityID)
{
var flightSchedule = new Flight_Schedule {
};
if (await TryUpdateModelAsync <Flight_Schedule>(flightSchedule,
"",
c => c.Flight_ScheduleID, c => c.RouteID, c => c.DepartDateTime, c => c.ArriveDateTime, c => c.AirCraftID, c => c.Economy, c => c.Business, c => c.PremEconomy, c => c.First))
{
//if the route in this schedule does not exist, then reject to create
if (!await _context.Routes.AnyAsync(r => r.FromCity.CityID == FromCityID && r.ToCity.CityID == ToCityID)) //get rid of the route that does not exist
{
ViewBag.ErrorNoRoute = "No such route exists!";
ViewData["FromCityID"] = new SelectList(_context.Cities, "CityID", "Name");
ViewData["ToCityID"] = new SelectList(_context.Cities, "CityID", "Name");
return(View(flightSchedule));
}
int RouteID = await _context.Routes.Where(r => r.FromCity.CityID == FromCityID && r.ToCity.CityID == ToCityID).Select(r => r.RouteID).FirstAsync(); //get the ID of route between2 cities
flightSchedule.Route = await _context.Routes.Where(r => r.RouteID == RouteID).FirstAsync(); //set the route in the new Flight_Schedule
try
{
_context.Add(flightSchedule);
await _context.SaveChangesAsync();
}
catch (DbUpdateException /* ex */)
{
//Log the error (uncomment ex variable name and write a log.)
ModelState.AddModelError("", "Unable to save changes. " +
"Try again, and if the problem persists, " +
"see your system administrator.");
}
return(RedirectToAction(nameof(Index)));
}
ViewData["FromCityID"] = new SelectList(_context.Cities, "CityID", "Name");
ViewData["ToCityID"] = new SelectList(_context.Cities, "CityID", "Name");
return(View(flightSchedule));
}
public int InitialBooking(List <int> tripList, string cabin, int passangers, DateTime bookingDateTime)
{
using (var transaction = new TransactionScope())
{
try
{
int suspendedID;
if (_context.BookingTransactions.Any())
{
suspendedID = _context.BookingTransactions.OrderByDescending(b => b.SuspendedID).Select(b => b.SuspendedID).FirstOrDefault() + 1;
}
else
{
IncrementCounter incrementCounter = new IncrementCounter();
suspendedID = incrementCounter.NextValue(); //生成一个自动递增的数
}
//var bookingDateTime = DateTime.Now;
foreach (int tripNo in tripList)
{
Flight_Schedule flight_Schedule = _context.Flight_Schedules.Where(x => x.Flight_ScheduleID == tripNo).FirstOrDefault();
for (int i = 0; i < passangers; i++)
{
//generate a specific booking transaction(BookingTransaction) for every passanger
//每一个passanger都单独生成一比业务记录(BookingTransaction)
BookingTransaction bookingTransaction = new BookingTransaction {
BookingDateTime = bookingDateTime, DepartDateTime = flight_Schedule.DepartDateTime, Flight_ScheduleID = flight_Schedule.Flight_ScheduleID, PersonalID = "", SuspendedID = suspendedID, CabinType = (CabinType)Enum.Parse(typeof(CabinType), cabin), Suspended = true
};
_context.Add(bookingTransaction);
}
//_context.SaveChanges();
}
//change the booked seats number according the cabin and the nuumber of passengers
switch (cabin)
{
case "Economy":
foreach (var t in tripList)
{
_context.Flight_Schedules.Where(f => f.Flight_ScheduleID == t).ToList().ForEach(f => f.Economy = f.Economy - passangers);
}
break;
case "Business":
foreach (var t in tripList)
{
_context.Flight_Schedules.Where(f => f.Flight_ScheduleID == t).ToList().ForEach(f => f.Business = f.Business - passangers);
}
break;
case "PremEconomy":
foreach (var t in tripList)
{
_context.Flight_Schedules.Where(f => f.Flight_ScheduleID == t).ToList().ForEach(f => f.PremEconomy = f.PremEconomy - passangers);
}
break;
case "First":
foreach (var t in tripList)
{
_context.Flight_Schedules.Where(f => f.Flight_ScheduleID == t).ToList().ForEach(f => f.First = f.First - passangers);
}
break;
}
//_context.SaveChanges();
transaction.Complete();
return(suspendedID);
}
catch (Exception ex)
{
return(0);
}
}
}
