public IEnumerable <FlightGroup> FlightsGroup([FromHeader] RFlight request)
{
if ((request.Back > 0 || request.Fwd > 0) && request.Date == null)
{
return(from flight in _context.FlightList
where flight.Est_blocktime.Value > DateTime.UtcNow.AddHours(-request.Back) && flight.Est_blocktime < DateTime.UtcNow.AddHours(request.Fwd)
group flight by flight.Aircraft_reg into FGroup
orderby FGroup.Key ascending
select new FlightGroup {
GroupID = FGroup.Key, Flights = FGroup.OrderBy(f => f.Est_blocktime).ToList()
});
}
else if (request.Date != null && (request.Back == 0 && request.Fwd == 0))
{
return(from flight in _context.FlightList
where flight.Est_blocktime > request.Date && flight.Est_blocktime < request.Date.Value.AddDays(1)
group flight by flight.Aircraft_reg into FGroup
orderby FGroup.Key ascending
select new FlightGroup {
GroupID = FGroup.Key, Flights = FGroup.OrderBy(f => f.Est_blocktime).ToList()
});
}
else
{
return(from flight in _context.FlightList
where flight.Est_blocktime > DateTime.UtcNow.AddDays(-2)
group flight by flight.Aircraft_reg into FGroup
orderby FGroup.Key ascending
select new FlightGroup {
GroupID = FGroup.Key, Flights = FGroup.OrderBy(f => f.Est_blocktime).ToList()
});
}
}
public string TestPost([FromBody] RFlight Request)
{
string test = "";
Request.Uid.ForEach((int a) => { test += a.ToString(); });
return(test);
}
public IEnumerable <Flight> QFlights([FromBody] RFlight Request)
{
var QFlightsList = new List <Flight>();
Request.Uid.ForEach((int uid) => {
var flight = _context.FlightList.SingleOrDefault(m => m.Uid == uid);
Console.WriteLine(uid);
if (flight != null)
{
QFlightsList.Add(flight);
}
});
return(QFlightsList);
}
public IEnumerable <Flight> GetFlightbyStation([FromHeader] RFlight request)
{
if ((request.Back > 0 || request.Fwd > 0) && request.DepartureIata != null)
{
return(from flight in _context.FlightList
where (flight.Apt_dep.Iata == request.DepartureIata || flight.Apt_arr_actual.Iata == request.DepartureIata) &&
(flight.Est_blocktime > DateTime.UtcNow.AddHours(-request.Back) && flight.Est_blocktime < DateTime.UtcNow.AddHours(request.Fwd))
orderby flight.Est_blocktime
select flight);
}
else
{
return(from flight in _context.FlightList
where (flight.Apt_dep.Iata == request.DepartureIata || flight.Apt_arr_actual.Iata == request.DepartureIata) && flight.Est_blocktime > DateTime.UtcNow.AddDays(-1)
orderby flight.Est_blocktime
select flight);
}
}
public IEnumerable <Flight> GetFlight([FromHeader] RFlight request)
{
if ((request.Back > 0 || request.Fwd > 0) && request.Date == null)
{
return(from flight in _context.FlightList
where flight.Est_blocktime.Value > DateTime.UtcNow.AddHours(-request.Back) && flight.Est_blocktime < DateTime.UtcNow.AddHours(request.Fwd)
orderby flight.Est_blocktime.Value ascending
select flight);
}
else if (request.Date != null && (request.Back == 0 && request.Fwd == 0))
{
return(from flight in _context.FlightList
where flight.Est_blocktime > request.Date && flight.Est_blocktime < request.Date.Value.AddDays(1)
orderby flight.Est_blocktime.Value ascending
select flight);
}
else
{
return(_context.FlightList.Where(f => f.Est_blocktime > DateTime.UtcNow.AddDays(-2)).OrderBy(f => f.Est_blocktime));
}
}
