public void SaveUserFlightData(int userID, FlightsList flights)
{
for (int i = 0; i < flights.Number; i++)
{
DateTime today = DateTime.Today;
string query = "INSERT INTO dataUserFlight VALUES('" + userID + "','" + today + "','" + flights.Flights[i].FlightID + "','" + flights.Flights[i].Company + "','" + flights.Flights[i].PositionX + "','" + flights.Flights[i].PositionY + "','" + flights.Flights[i].OriginX + "','" + flights.Flights[i].OriginY + "','" + flights.Flights[i].DestinationX + "','" + flights.Flights[i].DestinationY + "','" + flights.Flights[i].Velocity + "')";
SQLiteCommand comm = new SQLiteCommand(query, this.cnx);
comm.ExecuteNonQuery();
}
}
//Copia la lista de vuelos y la devuelve (evita que al cambiar la copia o el origen se sobreescriba la otra)
public FlightsList Copy()
{
FlightsList fl = new FlightsList();
fl.Number = this.Number;
int i;
for (i = 0; i < number; i++)
{
fl.Flights[i] = this.Flights[i].CopyFlightList();
}
return(fl);
}
//Muestra el trafico aereo que hay en el sector
public int GetTraffic(FlightsList flightsList)
{
int insideSectorCount = 0;
float positionMarginSectorX = (float)this.PositionX + this.Width;
float positionMarginSectorY = (float)this.PositionY + this.Height;
for (int i = 0; i < flightsList.Number; i++)
{
Flight Flight = flightsList.Flights[i];
if ((this.PositionX <= Flight.PositionX) && (Flight.PositionX <= positionMarginSectorX) && (this.PositionY <= Flight.PositionY) && (Flight.PositionY <= positionMarginSectorY))
{
insideSectorCount++;
}
}
return(insideSectorCount);
}
public void SetUserData(int userID, FlightsList flights)
{
db.Start();
db.SaveUserFlightData(userID, flights);
db.End();
}