public Bestaetigung(GPX_Viewer gv) { InitializeComponent(); this.gv = gv; }
public void ExportGPX(List<int> ToExport, List<int> ToExport_Waypoint) { m.con.Open(); GPX_Viewer exportLocation = new GPX_Viewer(); if (exportLocation.dlg_export.ShowDialog() == DialogResult.OK) { ExportPath = exportLocation.dlg_export.FileName; MessageBox.Show(ExportPath); } StreamWriter myFile = new StreamWriter(ExportPath); //Header myFile.Write("<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\" ?>\n"); myFile.Write("<gpx xmlns=\"http://www.topografix.com/GPX/1/1\" creator=\"\" version=\"1.1\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd\">\n"); //Track for (int i = 0; i < ToExport.Count; i++) { //Track aus DB SQL = String.Format("Select * From tbl_track WHERE ID_Track like '{0}'", ToExport[i]); m.cmd = new OleDbCommand(SQL, m.con); m.dr = m.cmd.ExecuteReader(); m.dr.Read(); myFile.Write("<trk>\n<name>"+(string)m.dr[1]+"</name>\n<trkseg>\n"); //Trackpoints //Trackpoint aus DB SQL = String.Format("Select * From tbl_Trackpoint WHERE FS_ID_Track like '{0}'", ToExport[i]); m.cmd = new OleDbCommand(SQL, m.con); m.dr = m.cmd.ExecuteReader(); while (m.dr.Read()) { myFile.Write(string.Format("<trkpt lat=\"{0}\" lon=\"{1}\">\n", m.dr[2].ToString().Replace(',', '.'), m.dr[1].ToString().Replace(',', '.'))); myFile.Write(string.Format("<ele>{0}</ele>\n", m.dr[4].ToString().Replace(',', '.'))); myFile.Write(string.Format("<time>{0}</time>\n", m.dr[3].ToString())); myFile.Write("</trkpt>\n"); } //Trackpoints Ende myFile.Write("</trkseg>\n</trk>\n\n"); } //Track Ende //Waypoints for (int i = 0; i < ToExport_Waypoint.Count; i++) { //Waypoint aus DB SQL = String.Format("Select * From tbl_Wegpunkt WHERE ID_Wegpunkt like '{0}'", ToExport_Waypoint[i]); m.cmd = new OleDbCommand(SQL, m.con); m.dr = m.cmd.ExecuteReader(); m.dr.Read(); myFile.Write("<wpt lat=\"" + m.dr[2].ToString().Replace(',', '.') + "\" lon=\"" + m.dr[1].ToString().Replace(',', '.') + "\">\n"); myFile.Write("<ele>" + m.dr[3].ToString().Replace(',', '.') + "</ele>\n"); myFile.Write("<name>" + m.dr[4] + "</name>\n"); myFile.Write("<cmt>" + m.dr[5] + "</cmt>\n"); myFile.Write("<desc>" + m.dr[6] + "</desc>\n"); myFile.Write("<sym>" + m.dr[7] + "</sym>\n"); myFile.Write("<extensions>\n<gpxx:WaypointExtension xmlns:gpxx=\"http://www.garmin.com/xmlschemas/GpxExtensions/v3\">\n<gpxx:DisplayMode>SymbolAndName</gpxx:DisplayMode>\n</gpxx:WaypointExtension>\n</extensions>\n</wpt>\n\n"); } //Waypoints ende //ende der Datei myFile.Write("</gpx>"); myFile.Close(); MessageBox.Show("Fertig!"); m.con.Close(); }
public Controller( GPX_Viewer gw) { i = new Import(m); e = new Export(m); this.gw = gw; }
public void ExportGPX(List <int> ToExport, List <int> ToExport_Waypoint) { m.con.Open(); GPX_Viewer exportLocation = new GPX_Viewer(); if (exportLocation.dlg_export.ShowDialog() == DialogResult.OK) { ExportPath = exportLocation.dlg_export.FileName; MessageBox.Show(ExportPath); } StreamWriter myFile = new StreamWriter(ExportPath); //Header myFile.Write("<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"no\" ?>\n"); myFile.Write("<gpx xmlns=\"http://www.topografix.com/GPX/1/1\" creator=\"\" version=\"1.1\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:schemaLocation=\"http://www.topografix.com/GPX/1/1 http://www.topografix.com/GPX/1/1/gpx.xsd\">\n"); //Track for (int i = 0; i < ToExport.Count; i++) { //Track aus DB SQL = String.Format("Select * From tbl_track WHERE ID_Track like '{0}'", ToExport[i]); m.cmd = new OleDbCommand(SQL, m.con); m.dr = m.cmd.ExecuteReader(); m.dr.Read(); myFile.Write("<trk>\n<name>" + (string)m.dr[1] + "</name>\n<trkseg>\n"); //Trackpoints //Trackpoint aus DB SQL = String.Format("Select * From tbl_Trackpoint WHERE FS_ID_Track like '{0}'", ToExport[i]); m.cmd = new OleDbCommand(SQL, m.con); m.dr = m.cmd.ExecuteReader(); while (m.dr.Read()) { myFile.Write(string.Format("<trkpt lat=\"{0}\" lon=\"{1}\">\n", m.dr[2].ToString().Replace(',', '.'), m.dr[1].ToString().Replace(',', '.'))); myFile.Write(string.Format("<ele>{0}</ele>\n", m.dr[4].ToString().Replace(',', '.'))); myFile.Write(string.Format("<time>{0}</time>\n", m.dr[3].ToString())); myFile.Write("</trkpt>\n"); } //Trackpoints Ende myFile.Write("</trkseg>\n</trk>\n\n"); } //Track Ende //Waypoints for (int i = 0; i < ToExport_Waypoint.Count; i++) { //Waypoint aus DB SQL = String.Format("Select * From tbl_Wegpunkt WHERE ID_Wegpunkt like '{0}'", ToExport_Waypoint[i]); m.cmd = new OleDbCommand(SQL, m.con); m.dr = m.cmd.ExecuteReader(); m.dr.Read(); myFile.Write("<wpt lat=\"" + m.dr[2].ToString().Replace(',', '.') + "\" lon=\"" + m.dr[1].ToString().Replace(',', '.') + "\">\n"); myFile.Write("<ele>" + m.dr[3].ToString().Replace(',', '.') + "</ele>\n"); myFile.Write("<name>" + m.dr[4] + "</name>\n"); myFile.Write("<cmt>" + m.dr[5] + "</cmt>\n"); myFile.Write("<desc>" + m.dr[6] + "</desc>\n"); myFile.Write("<sym>" + m.dr[7] + "</sym>\n"); myFile.Write("<extensions>\n<gpxx:WaypointExtension xmlns:gpxx=\"http://www.garmin.com/xmlschemas/GpxExtensions/v3\">\n<gpxx:DisplayMode>SymbolAndName</gpxx:DisplayMode>\n</gpxx:WaypointExtension>\n</extensions>\n</wpt>\n\n"); } //Waypoints ende //ende der Datei myFile.Write("</gpx>"); myFile.Close(); MessageBox.Show("Fertig!"); m.con.Close(); }
public Controller(GPX_Viewer gw) { i = new Import(m); e = new Export(m); this.gw = gw; }