private void loadData(string filepath) { using (FileStream fs = new FileStream(filepath, FileMode.Open)) { try { DataSet ds = new DataSet(); ds.ReadXml(fs); tds = new TrajectoryDbDataSet(); tds.Merge(ds); //using (TrajectoryDbDataSetTableAdapters.trajectoriesTableAdapter ta = new TrajectoryDbDataSetTableAdapters.trajectoriesTableAdapter()) //{ // Console.WriteLine(ta.Update(tds.trajectories)); //} //using (TrajectoryDbDataSetTableAdapters.pointsTableAdapter ta = new TrajectoryDbDataSetTableAdapters.pointsTableAdapter()) //{ // Console.WriteLine(ta.Update(tds.points)); //} int[] t_ids = new int[882 - 705]; for (int i = 0; i < 882 - 705; i++) { t_ids[i] = i + 705; } writeToCSV(t_ids); //updateDatabase(); foreach (TrajectoryDbDataSet.trajectoriesRow row in tds.trajectories) { //Console.WriteLine(row.average_velocity.CompareTo(Double.NaN)); if (row.average_velocity.CompareTo(Double.NaN) == 0) { row.average_velocity = 0.0; } } } catch (Exception e) { Console.WriteLine(e); } } }
// Add one point to points table, must refer to a trajectory in trajectories table public void addPointData(SkeletonPoint point, double distance, double deltaDistance, double velocity, string direction, TrajectoryDbDataSet.trajectoriesRow t_key,int milliseconds,double vx, double vz) { try { Globals.ds.points.AddpointsRow(point.X, point.Y, point.Z, distance, deltaDistance, velocity, direction, (byte) trackedSkeleton, t_key,milliseconds,vx,vz); } catch { return; } }