/// <summary>
/// Get new flight status
/// </summary>
/// <returns>FlightStatus</returns>
private static FlightStatus GetNewStatus()
{
FlightStatus status = FlightStatus.Unknown;
CheckEnum(out status, "flight status");
return(status);
}
public static FlightStatus GetFlight(string number, string date)
{
number = number.Trim().Replace(" ", "").Replace("-", "");
string airLineCode = number.Substring(0, 2).ToUpper();
string flightNumber = number.Substring(2);
string year = date.Split('.')[2];
string month = date.Split('.')[1];
string day = date.Split('.')[0];
string appID = ConfigurationManager.AppSettings["appId"];
string appKey = ConfigurationManager.AppSettings["appKey"];
string json = "";
var url = $"https://api.flightstats.com/flex/flightstatus/historical/rest/v3/json/flight/status/{airLineCode}/{flightNumber}/dep/{year}/{month}/{day}?appId={appID}&appKey={appKey}";
var response = client.GetAsync(url).Result;
if (response.IsSuccessStatusCode)
{
var responseContent = response.Content;
json = responseContent.ReadAsStringAsync().Result;
}
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
FlightStatus flight = JsonConvert.DeserializeObject <FlightStatus>(json);
return(flight);
}
public ViewResult Edit(int flightStatusId)
{
FlightStatus flightStatus = _flightStatusRepository.FlightStatuses
.FirstOrDefault(g => g.FlightStatusId == flightStatusId);
return(View(flightStatus));
}
private void DictionaryFilling()
{
SQLConnectionOpen();
string str = "SELECT * FROM FlightStatus";
using (SqlCommand cmd = new SqlCommand(str, con))
{
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
FlightStatus flSt = new FlightStatus
{
id = (int)reader["ID"],
statusName = (string)reader["STATUS_NAME"],
};
// flightStatusDict.Add(flSt.id,flSt);
}
}
}
}
SQLConnectionClose();
}
public SDrone(DroneData data, Drone drone)
{
count = DroneData.Count;
uid = data.UID;
totalDeliveryCount = data.DeliveryCount;
totalBatterySwaps = data.batterySwaps;
totalHubHandovers = data.hubsAssigned;
collisionOn = data.collisionOn;
isWaiting = data.isWaiting;
inHub = data.inHub;
movement = data.movement;
status = data.state;
totalDelay = data.totalDelay;
totalAudibleDuration = data.audibleDuration;
totalPackageWeight = data.packageWeight;
totalDistanceTravelled = data.distanceTravelled;
totalEnergy = data.totalEnergy;
targetAltitude = data.targetAltitude;
waypointsQueue = new List <SVector3>();
completedJobs = new List <uint>(data.completedJobs.Keys);
maxSpeed = data.MaxSpeed;
position = drone.transform.position;
previousWaypoint = data.previousWaypoint;
waypoint = data.currentWaypoint;
job = data.job;
hub = data.hub;
battery = data.battery;
charge = drone.GetBattery().Charge;
foreach (var point in data.waypoints)
{
waypointsQueue.Add(point);
}
}
/// <summary>
/// Recieve all information from user about flight for adding or editing
/// </summary>
/// <returns>flight</returns>
private static Flight AskForFlight()
{
string temp = string.Empty, flightNumber;
Terminals terminal = Terminals.A;
Airlines airline = Airlines.Airunes;
DateTime departDate = DateTime.Now, arrivDate = DateTime.Now;
Cities arrival = Cities.Berlin, departure = Cities.Berlin;
Gates gate = Gates.G1;
FlightStatus status = FlightStatus.Unknown;
Console.WriteLine("Enter the flight number");
flightNumber = Console.ReadLine().Trim();
CheckEnum(out airline, "airline");
CheckDate(out departDate, "departure");
CheckDate(out arrivDate, "arrival");
CheckEnum(out departure, "departure port");
CheckEnum(out arrival, "arrival port");
CheckEnum(out terminal, "terminal");
CheckEnum(out gate, "gate");
CheckEnum(out status, "flight status");
return(new Flight(airline, flightNumber, departDate, arrivDate, departure, arrival, terminal, gate, status));
}
public bool UpdateStatus(string flightNumber, FlightStatus status)
{
var flight = this.GetFlight(flightNumber); //_context.Flights.FirstOrDefault(f => f.FlightNumber == flightNumber));
// Return false if flight not found
if (flight == null)
{
//TODO Add Logger and log exception
return(false);
}
flight.FlightStatus = FlightStatus.Cancelled;
// check the flught was cancelled succesfully
try
{
_context.SaveChanges();
}
catch (Exception e)
{
//TODO Add Logger and log exception
return(false);
}
return(true);
}
public void AddItem()
{
byte choiceFlight = 0;
Flight newflight;
try
{
Console.WriteLine("Enter a kind of flight:1 - arrival; 2 - departure");
choiceFlight = byte.Parse(Console.ReadLine());
}
catch (OverflowException ex)
{
Console.WriteLine(ex.Message);
}
if ((choiceFlight <= 0) || (choiceFlight >= 3))
{
Console.WriteLine("You entered a wrong choice!!!");
}
DateTime timeofFlight = InputUtil.TimeEnter();
Console.WriteLine("Flight number:");
int ourflightnumber = int.Parse(Console.ReadLine());
Console.WriteLine("City:");
string ourflightcity = Console.ReadLine();
Console.WriteLine("Terminal:");
string ourflightterminal = Console.ReadLine();
KindOfFlight ourflightkind = (KindOfFlight)choiceFlight;
FlightStatus ourflightstatus = ChoiceFlightstatus();
newflight = new Flight(timeofFlight, ourflightnumber, ourflightcity,
ourflightterminal, ourflightkind, ourflightstatus, new List <Ticket>(), true);
AddToArray(ourflightkind, newflight);
}
public void Add(Flight flight, FlightStatus status)
{
NpgsqlConnection conn = null;
try
{
conn = DbConnectionPool.Instance.GetConnection();
string procedure = "sp_add_flight_history";
NpgsqlCommand command = new NpgsqlCommand(procedure, conn);
command.Parameters.AddRange(new NpgsqlParameter[]
{
new NpgsqlParameter("_original_id", flight.Id),
new NpgsqlParameter("_airline_company_id", flight.AirlineCompany.Id),
new NpgsqlParameter("_airline_company_name", flight.AirlineCompany.Name),
new NpgsqlParameter("_origin_country_id", flight.OriginCountryId),
new NpgsqlParameter("_destination_country_id", flight.DestinationCountryId),
new NpgsqlParameter("_departure_time", flight.DepartureTime),
new NpgsqlParameter("_landing_time", flight.LandingTime),
new NpgsqlParameter("_remaining_tickets", flight.RemainingTickets),
new NpgsqlParameter("_flight_status", (int)status)
});
command.CommandType = System.Data.CommandType.StoredProcedure;
var id = command.ExecuteScalar();
}
finally
{
DbConnectionPool.Instance.ReturnConnection(conn);
}
}
public void AskFlightMereTime()
{
FlightCalculator calculator = new FlightCalculator();
// Positions at the flight plan.
DateTime launchTime = new DateTime(2020, 5, 24, 20, 4, 30);
InitialLocation launch = new InitialLocation(100, 100, launchTime);
FlightStatus middle = new FlightStatus(120, 200, 300);
FlightStatus end = new FlightStatus(140, 250, 200);
// Generate the flight plan based on those positions.
FlightPlan flightPlan = new FlightPlan(256, "TestCompany", launch, new FlightStatus[2] {
middle, end
});
DateTime mereTime = launchTime.AddSeconds(150);
// The test asks for a point at mere time.
var res = calculator.CreateFlightFromPlan(flightPlan, mereTime, false);
// Check that expected values are retrieved.
Assert.AreEqual(110, res.Longitude);
Assert.AreEqual(150, res.Latitude);
}
internal static string GetRangeStateText(RangeState rangeState, FlightStatus corridorState)
{
string state = "DISARM";
string description = string.Empty;
switch (rangeState)
{
case RangeState.Nominal:
state = "NOMINAL";
break;
case RangeState.Armed:
state = "ARM";
break;
case RangeState.Destroyed:
state = "DESTROYED";
break;
case RangeState.Safe:
state = "SAFE";
break;
}
description = FlightCorridorBase.GetFlightStatusText(corridorState);
return(string.Format("{0}: {1}", state, description));
}
/// <summary>
/// Resume a paused flight
/// </summary>
public void resumeFlight()
{
switch (droneStatus)
{
case FlightStatus.ON_GROUND_STANDBY:
case FlightStatus.IN_AIR_STANDBY:
if (updateDestination(true, false, false))
{
droneStatusPrev = droneStatus;
droneStatus = FlightStatus.FLYING;
}
else
{
Debug.Log("Invalid drone command request, all waypoints completed");
}
break;
case FlightStatus.PAUSED_IN_AIR:
droneStatus = droneStatusPrev;
droneStatusPrev = FlightStatus.PAUSED_IN_AIR;
break;
case FlightStatus.FLYING:
case FlightStatus.FLYING_HOME:
case FlightStatus.LANDING:
case FlightStatus.NULL:
Debug.Log("Invalid drone command request");
break;
}
}
//----------------------------------------
#region Behaviours, behaviours, behaviours
void ExecuteBehaviour(FlightStatus behaviour)
{
switch (behaviour)
{
case FlightStatus.patrolling:
if (flightStatusIsChanging)
{
flightStatusIsChanging = false;
}
else
{
Patrol();
}
break;
case FlightStatus.intercepting:
if (flightStatusIsChanging)
{
flightStatusIsChanging = false;
}
else
{
Intercept();
}
break;
case FlightStatus.sentry:
if (flightStatusIsChanging)
{
flightStatusIsChanging = false;
}
else
{
Sentry();
}
break;
case FlightStatus.engaging:
if (flightStatusIsChanging)
{
flightStatusIsChanging = false;
}
else
{
Engage();
}
break;
case FlightStatus.retreating:
if (flightStatusIsChanging)
{
flightStatusIsChanging = false;
}
else
{
Flee();
}
break;
}
}
public void Fly()
{
rb.useGravity = false;
flightStatus = FlightStatus.Launching;
wing.SetActive(true);
}
public async Task <OperationStatus> SetStatus(FlightStatus status, int?flightId, bool cancelByDriver = false)
{
if (flightId == null)
{
throw new ArgumentNullException(nameof(flightId));
}
var flight = await _database.FlightRepository.FindAsync(flightId);
if (flight == null)
{
return(new OperationStatus("Flight doesn't exist", HttpStatusCode.NotFound, false));
}
flight.FlightStatusLookupId = status;
if (cancelByDriver)
{
flight.AutoId = null;
flight.DriverId = null;
}
await _database.FlightRepository.UpdateAsync(flight);
return(new OperationStatus("Flight's status was updated", true));
}
// Simply clears waypoints and stops the vessel for predefined loiter time
void Sentry()
{
// Simple control for exiting and entering Loiter
if (!loiterOngoing)
{
loiterOngoing = true;
statusText.text = "loitering";
loiterStart = Time.timeSinceLevelLoad;
ClearWaypoints();
}
if (Time.timeSinceLevelLoad - loiterTime > loiterStart)
{
flightStatus = FlightStatus.patrolling;
// TODO request order instead
wpList = RouteAndManeuverPlanner.PlanPatrol(gameObject.transform.position);
wpIndex = wpList.Count - 1;
desiredSpeed = patrolSpeedMax;
generalThrust = patrolThrust;
loiterOngoing = false;
statusText.text = "";
return;
}
Stop();
}
/// <summary>
/// Land the drone at the current point.
/// </summary>
public void landDrone()
{
switch (droneStatus)
{
case FlightStatus.IN_AIR_STANDBY:
case FlightStatus.FLYING_HOME:
updateDestination(false, false, true);
droneStatusPrev = droneStatus;
droneStatus = FlightStatus.LANDING;
break;
case FlightStatus.FLYING:
case FlightStatus.PAUSED_IN_AIR:
nextWaypointID--;
updateDestination(false, false, true);
droneStatusPrev = droneStatus;
droneStatus = FlightStatus.LANDING;
break;
case FlightStatus.ON_GROUND_STANDBY:
case FlightStatus.LANDING:
case FlightStatus.NULL:
Debug.Log("Invalid drone command request");
break;
}
}
public virtual FlightStatus CheckStatus(FlightStateData flightState)
{
FlightStatus result = FlightStatus.Nominal;
if (!SystemSettings.enableRangeSafety)
{
result = FlightStatus.Disarmed;
Status = result;
return(result);
}
if (flightState == null || FlightGlobals.ActiveVessel.situation == Vessel.Situations.PRELAUNCH)
{
result = FlightStatus.Prelaunch;
Status = result;
return(result);
}
result |= CheckVehicleMass(flightState);
result |= CheckVehicleVelocity(flightState);
result |= CheckVehicleDistanceFromPad(flightState);
if ((result & FlightStatus.NominalPadExclusion) != FlightStatus.NominalPadExclusion)
{
// only check bearing once we leave the exlcusion radius to avoid spurious short distance variatons
result |= CheckCorridor(flightState);
}
Status = result;
return(result);
}
private void EnterArmedState(FlightStatus triggerStatus)
{
FlightLogger.eventLog.Add(string.Format("[{0}]: Range safety entered ARM state: {1}", KSPUtil.PrintTimeCompact((int)Math.Floor(FlightGlobals.ActiveVessel.missionTime), false), FlightCorridorBase.GetFlightStatusText(triggerStatus)));
State = RangeState.Armed;
if (rangeSafetyInstance.settings.terminateThrustOnArm)
{
actionQueue.Enqueue(RangeActions.TerminateThrust);
}
if (rangeSafetyInstance.settings.destroySolids)
{
actionQueue.Enqueue(RangeActions.DestroySolids);
}
if (rangeSafetyInstance.settings.coastToApogeeBeforeAbort)
{
actionQueue.Enqueue(RangeActions.CoastToApogee);
}
if (rangeSafetyInstance.settings.abortOnArm)
{
actionQueue.Enqueue(RangeActions.ExecuteAbort);
}
if (rangeSafetyInstance.settings.delay3secAfterAbort)
{
actionQueue.Enqueue(RangeActions.WaitForAbortToClear);
}
if (rangeSafetyInstance.settings.destroyLaunchVehicle)
{
actionQueue.Enqueue(RangeActions.TerminateFlight);
}
}
public void UpdateTrip(TripUpdateDto trip)
{
using (IReservationRepository reservationRepository = new ReservationRepository(ConnectionName))
{
Reservation reservation = reservationRepository.FindBy(r => r.ConfirmationCode == trip.ReservationConfirmationCode).FirstOrDefault();
Trip originalTrip = null;
if (reservation == null)
{
throw new FaultException("The confirmation code of the reservation is invalid");
}
switch (trip.FlightDirection)
{
case FlightDirections.Departing:
originalTrip = reservation.DepartureFlight;
break;
case FlightDirections.Returning:
originalTrip = reservation.ReturnFlight;
break;
}
if (originalTrip == null)
{
throw new FaultException("The requested trip was not found");
}
FlightStatus originalStatus = originalTrip.Status;
FlightStatus newStatus = trip.TripToUpdate.Status;
reservationRepository.UpdateTrip(
originalTrip,
new Trip()
{
TripId = originalTrip.TripId,
ThumbnailImage = originalTrip.ThumbnailImage,
FlightInfo = originalTrip.FlightInfo,
FlightScheduleID = originalTrip.FlightScheduleID,
Status = trip.TripToUpdate.Status,
Class = trip.TripToUpdate.Class
});
using (TransactionScope scope = new TransactionScope())
{
// TODO: 2 - Call the Frequent Flyer service to add the miles if the traveler has checked-in
if (originalStatus != newStatus && newStatus == FlightStatus.CheckedIn)
{
IFrequentFlyerService proxy = _frequentFlyerChannnelFactory.CreateChannel();
int earnedMiles = originalTrip.FlightInfo.Flight.FrequentFlyerMiles;
proxy.AddFrequentFlyerMiles(reservation.TravelerId, earnedMiles);
}
// TODO: 3 - Wrap the save and the service call in a transaction scope
reservationRepository.Save();
scope.Complete();
}
}
}
public static string GetColorClassByFlightStatus(this IHtmlHelper html, FlightStatus flightStatus)
{
return(flightStatus switch
{
FlightStatus.Landed => "table-success",
FlightStatus.Delayed => "table-warning",
_ => string.Empty
});
public async Task <List <Flight> > GetFlightsByStatusAsync(FlightStatus status)
{
return(await context.Flights.Include(f => f.AirportFlights)
.ThenInclude(af => af.Airport)
.Include(f => f.AppUser)
.Where(f => f.Status.Equals(status))
.AsNoTracking()
.ToListAsync());
}
public Flight(string FlightNumber, StationData Destination, StationData From, Plane FlightPlane, double Price, FlightStatus Status = FlightStatus.ExpectedAt)
{
this.FlightNumber = FlightNumber;
this.Destination = Destination;
this.From = From;
this.FlightPlane = FlightPlane;
this.Status = Status;
this.Price = Price;
}
public FlightInfo(DateTime dateTime, int flyNumber, string cityPort, int terminal,FlightStatus FlightStatus, int gate)
{
this.dateTime = dateTime;
this.flyNumber = flyNumber;
this.cityPort = cityPort;
this.terminal = terminal;
this.FlightStatus = FlightStatus;
this.gate = gate;
}
/// <summary>
/// Used to change status if status is not already set
/// </summary>
/// <returns>true if status was changed</returns>
private bool ChangeStatusIfNewer(FlightStatus flightStatus)
{
if (Status != flightStatus)
{
Status = flightStatus;
return(true);
}
return(false);
}
public ActionResult Edit(FlightStatus flightStatus)
{
if (ModelState.IsValid)
{
_flightStatusRepository.SaveFlightStatus(flightStatus);
return(RedirectToAction("Index"));
}
return(View(flightStatus));
}
public List <Flight> GetDepartures()
{
List <Flight> list = new List <Flight>();
//query
string query = @"select f.id, f.airlineId, a.name as airlineName, date, f.departureCityId, dc.name as departureCity, f.departureTime,
f.arrivalCityId, ac.name as arrivalCity, f.arrivalTime, f.status
from flights as f
join airlines as a on f.airlineId = a.id
join cities as dc on f.departureCityId = dc.id
join cities as ac on f.arrivalCityId = ac.id
where f.departureCityId = @ID
order by f.departureTime";
//command
SqlCommand command = new SqlCommand(query);
//parameters
command.Parameters.AddWithValue("@ID", _id);
//execute query
DataTable table = SqlServerConnection.ExecuteQuery(command);
//check if data is found
foreach (DataRow row in table.Rows)
{
//read columns
int id = (int)row["id"];
string airlineId = (string)row["airlineId"];
string airlineName = (string)row["airlineName"];
DateTime date = (DateTime)row["date"];
string departureCityId = (string)row["departureCityId"];
string departureCityName = (string)row["departureCity"];
DateTime departureTime = Convert.ToDateTime(row["departureTime"].ToString());
string arrivalCityId = (string)row["arrivalCityId"];
string arrivalCityName = (string)row["arrivalCity"];
DateTime arrivalTime = Convert.ToDateTime(row["arrivalTime"].ToString());
FlightStatus status = (FlightStatus)row["status"];
//Console.WriteLine("status: " + status);
Airline airline = new Airline(airlineId, airlineName);
//Console.WriteLine(airlineName);
City departureCity = new City(departureCityId, departureCityName);
City arrivalCity = new City(arrivalCityId, arrivalCityName);
Flight f = new Flight();
f.Airline = airline;
f.ArrivalCity = arrivalCity;
f.ArrivalTime = arrivalTime;
f.Date = date;
f.DepartureCity = departureCity;
f.DepartureTime = departureTime;
f.Id = id;
f.Status = status;
list.Add(f);
}
return(list);
}
public Flight(long airlineID, long originID, long destinationID, DateTime departTime, DateTime landingTime, int remainingTickets, FlightStatus status)
{
AirlineCompanyID = airlineID;
OriginCountryCode = originID;
DestinationCountryCode = destinationID;
DepartureTime = departTime;
LandingTime = landingTime;
RemainingTickets = remainingTickets;
FlightStatus = status;
}
public void SetFlightStatus(FlightStatus flightStatus)
{
if (string.IsNullOrEmpty(flightStatus.ToString()))
{
throw new BeComfyDomainException($"{nameof(flightStatus)} cannot be null");
}
FlightStatus = flightStatus;
SetUpdateDate();
}
//For explicit fields initalization
public Flight(string flightID, DateTime time, string cityName, string airCompany, char terminal, string gateID, FlightStatus flightStatus) : this()
{
this.flightID = flightID;
this.time = time;
this.cityName = cityName;
this.airCompany = airCompany;
this.terminal = terminal;
this.gateID = gateID;
this.flightStatus = flightStatus;
}
public Task Update(FlightStatus flightInfo)
{
if (connections.TryGetValue(this.Context.ConnectionId, out var connectionInfo))
{
connectionInfo.FlightStatus = flightInfo;
return(Clients.All.SendAsync("Update", this.Context.ConnectionId, flightInfo));
}
return(Task.CompletedTask);
}
public Flight(Airline airline, Airport airport)
{
Airline = airline;
Airport = airport;
FlightStatus = new FlightStatus();
}
private static FlightStatus GetRandomArrivalStatus()
{
var status = new FlightStatus();
status.StatusTime = DateTime.Now;
status.Status.StatusTextNorwegian =
Random.Next(0, 100) > 50 ? "Landet" : "Ny tid";
return status;
}
private static FlightStatus GetRandomDepartureStatus()
{
var status = new FlightStatus();
status.StatusTime = DateTime.Now;
status.Status.StatusTextNorwegian =
Random.Next(0, 100) > 50 ? "Boarding" : "Gå til gate";
return status;
}
