Example #1
0
        public static List <string> GetSpecAirIata(string cityname)
        {
            string        temp;
            List <string> sviAir = new List <string>();

            temp = Airports.InnerAirRout(cityname);
            SQLiteCommand    command = new SQLiteCommand(temp, m_dbConnection);
            SQLiteDataReader reader  = command.ExecuteReader();

            while (reader.Read())
            {
                sviAir.Add(reader["airIATA"].ToString());
            }
            return(sviAir);
        }
Example #2
0
        public static List <Airports> GetInnerListTo(string to)
        {
            string          tempTo;
            List <Airports> sviAirTo = new List <Airports>();

            tempTo = Airports.InnerAirRout(to);

            SQLiteCommand    command = new SQLiteCommand(tempTo, m_dbConnection);
            SQLiteDataReader reader  = command.ExecuteReader();

            while (reader.Read())
            {
                Airports tt = new Airports();
                tt.airIATA = reader["airIATA"].ToString();

                sviAirTo.Add(tt);
            }

            return(sviAirTo);
        }
        public void InitDatabase()
        {
            Users s = new Users();

            s.InsertUsers();

            City c = new City();

            c.InserCity();

            Airports a = new Airports();

            a.SqlAir();

            Comment cc = new Comment();

            cc.InsertComment();

            Routes r = new Routes();

            r.SQLRoutes();
        }