/*
* select sum(f.price)
* from flights f, company c
* where f.companyName = c.name and c.name = "Lufthansa"
*/
public double Query6()
{
return
(FlightTable.Join(
CompanyTable, t => t.Item1.CompanyName == t.Item2.Name && t.Item2.Name == "Lufthansa").Reduce(
0.0, (s, t) => s += t.Item1.Price));
}
/*
* select *
* from flights f, airport a
* where f.destinationAirport = a.name && f.destinationCity = a.city
* */
public IEnumerable <Tuple <Flight, Airport> > Query4()
{
return
(FlightTable.Join
(AirportTable, t => t.Item1.DestinationAirport == t.Item2.Name &&
t.Item1.DestinationCity == t.Item2.City));
}
public async Task <BundleModel> GetBundleItems(int bundleId)
{
FlightModel flight;
BundleModel bundle = await BundleTable.GetBundleById(_dbConnection, bundleId);
var flights_id = await BundleTable.GetBundleFlights(_dbConnection, bundleId);
foreach (int flight_id in flights_id)
{
var k = await FlightTable.GetFlightById(_dbConnection, flight_id);
if (k is null)
{
throw new Exception();
}
else
{
flight = k;
}
bundle.Flights.Append(flight);
}
if (bundle is null)
{
throw new Exception();
}
else
{
return(bundle);
}
}
/*
* select f.code, f.company, a.size
* from flights f, airport a
* where f.destinationAirport = a.name && f.destinationCity = a.city && f.company = Lufthansa
* */
public IEnumerable <Tuple <string, string, AirportSize> > Query5()
{
return
(FlightTable.Join(
AirportTable, t => t.Item1.DestinationAirport == t.Item2.Name &&
t.Item1.DestinationCity == t.Item2.City &&
t.Item1.CompanyName == "Lufthansa").Map(
t => new Tuple <string, string, AirportSize>(t.Item1.Code, t.Item1.CompanyName, t.Item2.Size)));
}
// POST api/<controller>
public HttpResponseMessage Post(FlightTable f1)
{
try
{
db.FlightTables.Add(f1);
db.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.Created));
}
catch
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
/*
* select code, destinationAirport
* from flight
* where company = 'Lufthansa'
*/
public IEnumerable <Tuple <string, string> > Query3()
{
return
(FlightTable.Reduce
(new List <Flight>(), (l, flight) =>
{
if (flight.CompanyName == "Lufthansa")
{
l.Add(flight);
}
return l;
}).Map
(flight => new Tuple <string, string>(flight.Code, flight.DestinationAirport)));
}
// PUT api/<controller>/5
public HttpResponseMessage Put(string id, FlightTable f1)
{
try
{
if (id == f1.FlightNo)
{
db.Entry(f1).State = System.Data.Entity.EntityState.Modified;
return(new HttpResponseMessage(HttpStatusCode.OK));
}
else
{
return(new HttpResponseMessage(HttpStatusCode.NotFound));
}
}
catch (Exception ex)
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
// DELETE api/<controller>/5
public HttpResponseMessage Delete(string id)
{
try
{
FlightTable f = db.FlightTables.Find(id);
if (f != null)
{
db.FlightTables.Remove(f);
db.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.OK));
}
else
{
return(new HttpResponseMessage(HttpStatusCode.NotFound));
}
}
catch (Exception ex)
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
public Task <int> CreateAsync([FromBody] FlightDTO flight) => FlightTable.CreateFlight(_dbConnection, flight.DepartureAirportId, flight.ArrivalAirportId, flight.TotalSeatCount);
public Task <bool> DeleteById(int flightId) => FlightTable.DeleteFlightById(_dbConnection, flightId);
public async Task <IActionResult> GetAsync(int flightId)
{
var res = await FlightTable.GetFlightById(_dbConnection, flightId);
return(res == null?NotFound() : (IActionResult)Ok(res));
}
public Task <IEnumerable <FlightModel> > GetAll() => FlightTable.GetAllFlights(_dbConnection);
/*
* select code, company, destinationAirport
* from flight
*/
public IEnumerable <Tuple <string, string, string> > Query2()
{
return(FlightTable.Map(flight => new Tuple <string, string, string>(flight.Code, flight.CompanyName, flight.DestinationAirport)));
}
/*
* select *
* from flight
*/
public IEnumerable <Flight> Query1()
{
return(FlightTable.Map(x => x));
}
