public List <Routes> ListOfRoutes()
{
List <Routes> list = SQLHelper.GetAllRoutes();
return(list);
}
public void InsertRoutes(string airportID, string airname, string aircity, string aircountry, string airIATA, string airICAO, string airlatitude, string airlongitude, string airaltitude, string airtimezone) //potrebna izmena naziva
{
string sql = SQLHelper.InsertRout(airportID, Guid.NewGuid().ToString(), aircity, aircountry, airIATA, airICAO, airlatitude, airlongitude, airaltitude, airtimezone);
SQLHelper.ExecuteCommand(sql);
}
public List <Airports> GetInnerAllFrom(string from)
{
List <Airports> temp = SQLHelper.GetInnerListFrom(from);
return(temp);
}
public List <Airports> GetInnerAllTo(string to)
{
List <Airports> temp = SQLHelper.GetInnerListTo(to);
return(temp);
}
public void InsertAirs(string airportID, string airname, string aircity, string aircountry, string airIATA, string airICAO, string airlatitude, string airlongitude, string airaltitude, string airtimezone, string airdst, string airdbtimezone, string airtype, string airsource) //potrebna dorada
{
string sql = SQLHelper.InsertAirs(airportID, airname, aircity, aircountry, airIATA, airICAO, airlatitude, airlongitude, airaltitude, airtimezone, airdst, airdbtimezone, airtype, airsource);
SQLHelper.ExecuteCommand(sql);
}
