// 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; }