Exemplo n.º 1
0
        private void GetInfosForTick()
        {
            string          sqlTimeToEndFlight = "select date_assigned, TIME_TO_SEC(DATE_ADD(date_assigned, INTERVAL 30 MINUTE))-TIME_TO_SEC(NOW()) FROM pilotassignments WHERE pilot=@UserID and NOW() <=  DATE_ADD(date_assigned, INTERVAL 30 MINUTE) LIMIT 1";
            MySqlConnection conn = new MySqlConnection(Login.ConnectionString);

            try
            {
                conn.Open();

                MySqlCommand sqlCmd = new MySqlCommand(sqlTimeToEndFlight, conn);
                sqlCmd.Parameters.AddWithValue("@UserID", a.UserID);

                MySqlDataReader sqlCmdRes = sqlCmd.ExecuteReader();
                if (sqlCmdRes.HasRows)
                {
                    while (sqlCmdRes.Read())
                    {
                        s    = Convert.ToInt32(sqlCmdRes[1]);
                        sBar = 1800 - Convert.ToInt32(sqlCmdRes[1]);
                    }
                }
                FlightTimeEndTick.Start();
            }
            catch (Exception crap)
            {
                throw new ApplicationException("Failed to load exam @UserInfoDash()", crap);
            }
            finally
            {
                conn.Close();
            }
        }
Exemplo n.º 2
0
 public void AlertFlight()
 {
     if (FlightID != 0)
     {
         lblFlightAlert.Text    = String.Format("Alert!! You have one flight with callsign {0}, from {1} to {2} with {3}", FlightCallsign, UserDeparture, UserArrival, UserAircraft);
         lblFlightAlert.Visible = true;
         GetInfosForTick();
         label1.Visible            = true;
         pBarFlightTimeEnd.Visible = true;
         GetInfosForTick();
     }
     else
     {
         lblFlightAlert.Visible    = false;
         label1.Visible            = false;
         pBarFlightTimeEnd.Visible = false;
         FlightTimeEndTick.Stop();
     }
 }
Exemplo n.º 3
0
        private void FlightTimeEndTick_Tick(object sender, EventArgs e)
        {
            GetInfosForTick();

            s = s - 1;

            sBar = sBar + 1;

            if (s == 0)
            {
                FlightTimeEndTick.Stop();

                //END of Time
            }

            string ss    = Convert.ToString(s);
            int    ssBar = (sBar * 100) / 1800;

            pBarFlightTimeEnd.Value = ssBar;
        }
Exemplo n.º 4
0
        public void AlertFlight()
        {
            a = new UserInfo();

            if (CurrentLocation != a.Location)
            {
                flightAssignmentCtrl.assingmentCtrl.comboTypeRatings();
            }

            if (Flightid != 0)
            {
                if (!f.OnFlight)
                {
                    lblFlightAlert.Text       = String.Format("Alert!! You have one flight with callsign {0}, from {1} to {2} with {3}", FlightCallsign, UserDeparture, UserArrival, UserAircraft);
                    lblFlightAlert.ForeColor  = Color.Red;
                    lblFlightAlert.Visible    = true;
                    label1.Visible            = true;
                    pBarFlightTimeEnd.Visible = true;
                    FlightTimeEndTick.Start();
                }
                else
                {
                    lblFlightAlert.Text       = String.Format("On Flying!! -> {0}, from {1} to {2} with {3}", FlightCallsign, UserDeparture, UserArrival, UserAircraft);
                    lblFlightAlert.ForeColor  = Color.ForestGreen;
                    lblFlightAlert.Visible    = true;
                    label1.Visible            = false;
                    pBarFlightTimeEnd.Visible = false;
                    FlightTimeEndTick.Stop();
                }
            }
            else
            {
                if (a.Location != a.Hub)
                {
                    LastFlight lf = new LastFlight();

                    int RemainingDaysToFlightExpire = ((lf.DateOfFlightExpire - DateTime.UtcNow.Date).Days - 1);

                    if (RemainingDaysToFlightExpire <= -1)
                    {
                        lblFlightAlert.Visible = false;
                        LastFlight.ReturnToHub(a.MediaTotalFlights);
                    }
                    else if (RemainingDaysToFlightExpire == 0)
                    {
                        lblFlightAlert.Text      = String.Format("Alert!! Today is last day to return your hub without penalizations", RemainingDaysToFlightExpire.ToString());
                        lblFlightAlert.ForeColor = Color.Red;
                        lblFlightAlert.Visible   = true;
                    }
                    else
                    {
                        lblFlightAlert.Text      = String.Format("Alert!! You have {0} days to return your hub without penalizations", RemainingDaysToFlightExpire.ToString());
                        lblFlightAlert.ForeColor = Color.Orange;
                        lblFlightAlert.Visible   = true;
                    }
                    label1.Visible            = false;
                    pBarFlightTimeEnd.Visible = false;
                    FlightTimeEndTick.Stop();
                }
                else
                {
                    lblFlightAlert.Visible    = false;
                    label1.Visible            = false;
                    pBarFlightTimeEnd.Visible = false;
                    FlightTimeEndTick.Stop();
                }
            }
            CurrentLocation = a.Location;
        }