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);
}
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();
}