public void SaveTrk(Trk trk)
{
string ins = $"insert into trk values(?,?,?)";
object[] args = new object[] { null, trk.Title, trk.Tijdstip.ToString("yyy MM dd HH:mm:ss") };
int id = SQLiteService.ExecuteInsert(ins, args);
trk.ID = id;
}
public ObservableCollection<TrkPt> TrkPts(Trk trk)
{
String sql = "select * from trkpt where (trkid = ?)";
object[] args = new object[] { trk.ID };
var l = Select(sql);
ObservableCollection<TrkPt> oc = new ObservableCollection<TrkPt>(l);
return oc;
}
private void NewTrack()
{
Trk trk = new Trk();
TrkRepository repo = new TrkRepository();
trk.Title = "Trk test";
trk.Tijdstip = DateTime.Now;
repo.SaveTrk(trk);
Tracker tracker = new Tracker();
tracker.CurrentTrk = trk;
tracker._isStarted = true;
}
private MapPolyline MakePolyline(Trk trk)
{
if (trk == null) return null;
MapPolyline polyline = new MapPolyline();
polyline.StrokeColor = Colors.Red;
polyline.StrokeThickness = 2;
List<BasicGeoposition> pos = new List<BasicGeoposition>();
BasicGeoposition bpos;
foreach (TrkPt pt in trk.TrkPts)
{
bpos = new BasicGeoposition();
bpos.Latitude = pt.Latitude;
bpos.Longitude = pt.Longitude;
pos.Add(bpos);
}
Geopath p = new Geopath(pos);
polyline.Path = p;
return polyline;
}