// Hier wird die Tabelle Route mit den nötigen Werten gefüllt.
// Es wurde nur am anfang benötigt um Änderungen bei jedem Start zu übernehmen
// Wird zurzeit nicht mehr genutzt
public void filltableRoute()
{
Debug.Log ("RoutePoints");
IDbConnection _connection = new SqliteConnection(_strDBName);
IDbCommand _command = _connection .CreateCommand();
string sql;
_connection.Open();
// Leeren der Tabelle
sql = " Delete From ROUTE";
_command.CommandText = sql;
_command.ExecuteNonQuery ();
_command.Dispose ();
_command = null;
_connection.Close ();
_connection.Dispose ();
_connection = null;
Route PointstoRoute = new Route ();
//First Route
PointstoRoute.setRoutenID ("1");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("1");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("2");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("1");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("3");this.addRoute (PointstoRoute);
//Second Route
PointstoRoute.setRoutenID ("2");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("2");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("4");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("2");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("5");this.addRoute (PointstoRoute);
//Third Route
PointstoRoute.setRoutenID ("3");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("3");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("6");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("3");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("7");this.addRoute (PointstoRoute);
//Fourth Route
PointstoRoute.setRoutenID ("4");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("4");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("8");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("4");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("9");this.addRoute (PointstoRoute);
//Fifth Route
PointstoRoute.setRoutenID ("5");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("5");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("8");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("5");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("10");this.addRoute (PointstoRoute);
//Six Route
PointstoRoute.setRoutenID ("6");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("6");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("11");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("6");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("12");this.addRoute (PointstoRoute);
//Seven Route
PointstoRoute.setRoutenID ("7");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("7");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("11");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("7");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("13");this.addRoute (PointstoRoute);
//eight Route
PointstoRoute.setRoutenID ("8");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("8");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("14");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("8");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("15");this.addRoute (PointstoRoute);
//nine Route
PointstoRoute.setRoutenID ("9");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("9");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("14");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("9");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("16");this.addRoute (PointstoRoute);
//ten Route
PointstoRoute.setRoutenID ("10");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("10");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("17");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("10");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("18");this.addRoute (PointstoRoute);
//eleven Route
PointstoRoute.setRoutenID ("11");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("11");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("17");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("11");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("19");this.addRoute (PointstoRoute);
//12 Route
PointstoRoute.setRoutenID ("12");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("12");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("20");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("12");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("21");this.addRoute (PointstoRoute);
//13 Route
PointstoRoute.setRoutenID ("13");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("13");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("20");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("13");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("22");this.addRoute (PointstoRoute);
//14 Route
PointstoRoute.setRoutenID ("14");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("14");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("23");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("14");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("24");this.addRoute (PointstoRoute);
//15 Route
PointstoRoute.setRoutenID ("15");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("15");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("23");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("15");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("25");this.addRoute (PointstoRoute);
//16 Route
PointstoRoute.setRoutenID ("16");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("16");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("26");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("16");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("27");this.addRoute (PointstoRoute);
//17 Route
PointstoRoute.setRoutenID ("17");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("17");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("26");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("17");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("28");this.addRoute (PointstoRoute);
//18 Route
PointstoRoute.setRoutenID ("18");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("18");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("29");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("18");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("30");this.addRoute (PointstoRoute);
//19 Route
PointstoRoute.setRoutenID ("19");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("1");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("19");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("29");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("19");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("31");this.addRoute (PointstoRoute);
//20 Route
PointstoRoute.setRoutenID ("20");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("20");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("33");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("20");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("34");this.addRoute (PointstoRoute);
//21 Route
PointstoRoute.setRoutenID ("21");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("21");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("35");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("21");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("36");this.addRoute (PointstoRoute);
//22 Route
PointstoRoute.setRoutenID ("22");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("22");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("35");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("22");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("37");this.addRoute (PointstoRoute);
//23 Route
PointstoRoute.setRoutenID ("23");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("23");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("38");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("23");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("39");this.addRoute (PointstoRoute);
//24 Route
PointstoRoute.setRoutenID ("24");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("24");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("38");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("24");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("40");this.addRoute (PointstoRoute);
//25 Route
PointstoRoute.setRoutenID ("25");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("25");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("41");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("25");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("42");this.addRoute (PointstoRoute);
//26 Route
PointstoRoute.setRoutenID ("26");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("26");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("41");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("26");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("43");this.addRoute (PointstoRoute);
//27 Route
PointstoRoute.setRoutenID ("27");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("27");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("44");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("27");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("45");this.addRoute (PointstoRoute);
//28 Route
PointstoRoute.setRoutenID ("28");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("28");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("44");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("28");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("46");this.addRoute (PointstoRoute);
//29 Route
PointstoRoute.setRoutenID ("29");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("29");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("47");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("29");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("48");this.addRoute (PointstoRoute);
//30 Route
PointstoRoute.setRoutenID ("30");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("30");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("47");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("30");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("49");this.addRoute (PointstoRoute);
//31 Route
PointstoRoute.setRoutenID ("31");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("31");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("50");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("31");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("51");this.addRoute (PointstoRoute);
//32 Route
PointstoRoute.setRoutenID ("32");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("32");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("50");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("32");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("52");this.addRoute (PointstoRoute);
//33 Route
PointstoRoute.setRoutenID ("33");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("33");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("53");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("33");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("54");this.addRoute (PointstoRoute);
//34 Route
PointstoRoute.setRoutenID ("34");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("32");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("34");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("53");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("34");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("55");this.addRoute (PointstoRoute);
//35 Route
PointstoRoute.setRoutenID ("35");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("35");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("57");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("35");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("58");this.addRoute (PointstoRoute);
//36 Route
PointstoRoute.setRoutenID ("36");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("36");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("57");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("36");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("59");this.addRoute (PointstoRoute);
//37 Route
PointstoRoute.setRoutenID ("37");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("37");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("60");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("37");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("61");this.addRoute (PointstoRoute);
//38 Route
PointstoRoute.setRoutenID ("38");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("38");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("60");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("38");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("62");this.addRoute (PointstoRoute);
//39 Route
PointstoRoute.setRoutenID ("39");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("39");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("63");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("39");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("64");this.addRoute (PointstoRoute);
//40 Route
PointstoRoute.setRoutenID ("40");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("40");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("63");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("40");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("65");this.addRoute (PointstoRoute);
//41 Route
PointstoRoute.setRoutenID ("41");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("41");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("66");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("41");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("67");this.addRoute (PointstoRoute);
//42 Route
PointstoRoute.setRoutenID ("42");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("42");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("66");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("42");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("68");this.addRoute (PointstoRoute);
//43 Route
PointstoRoute.setRoutenID ("43");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("43");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("69");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("43");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("70");this.addRoute (PointstoRoute);
//44 Route
PointstoRoute.setRoutenID ("44");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("44");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("69");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("44");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("71");this.addRoute (PointstoRoute);
//45 Route
PointstoRoute.setRoutenID ("45");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("45");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("72");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("45");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("73");this.addRoute (PointstoRoute);
//46 Route
PointstoRoute.setRoutenID ("46");PointstoRoute.setPositionID ("1");PointstoRoute.setKnotenID ("56");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("46");PointstoRoute.setPositionID ("2");PointstoRoute.setKnotenID ("72");this.addRoute (PointstoRoute);
PointstoRoute.setRoutenID ("46");PointstoRoute.setPositionID ("3");PointstoRoute.setKnotenID ("74");this.addRoute (PointstoRoute);
}
// Hier wird ein COntainer erzeugt der alle punkte der Ausgewechlten Routen beinhaltet.
// Die Ausgewählte Route wird per PArameter gegeben
// Rückgabe ist ein RoutenContainer
public RouteContainer getRouteViaROUTEID(String RouteID)
{
IDbConnection _connection = new SqliteConnection(_strDBName);
IDbCommand _command = _connection .CreateCommand();
string sql;
IDataReader _reader;
_connection .Open();
sql = "SELECT * FROM Route WHERE ROUTENID='"+RouteID+"' ";
_command.CommandText = sql;
_reader = _command.ExecuteReader();
RouteContainer container=new RouteContainer();
// Hier wird die Schleife so oft Durchlaufen bis alle Funde durchfahren worden sind.
while (_reader.Read()){
Route Routeelement=new Route();
Routeelement.setRoutenID(System.Convert.ToString(_reader["ROUTENID"]));
Routeelement.setPositionID(System.Convert.ToString(_reader["POSITION"]));
Routeelement.setKnotenID(System.Convert.ToString(_reader["PUNKTID"]));
container.addRoute(Routeelement);
}
_command.Dispose ();
_command = null;
_connection.Close ();
_connection.Dispose ();
_connection = null;
_reader.Close ();
_reader.Dispose ();
_reader = null;
return container;
}
