public Fact(QualityInformation Quality, SegmentInformation Segment, TemporalInformation Temporal, SpatialInformation Spatial, MeasureInformation Measure) { this._Quality = Quality; this._Segment = Segment; this.Temporal = Temporal; this.Spatial = Spatial; this.Measure = Measure; }
public Fact(Int64 EntryId, int CarId, Int64 TripId, QualityInformation Quality, SegmentInformation Segment, TemporalInformation Temporal, SpatialInformation Spatial, MeasureInformation Measure, FlagInformation Flag) { this._EntryId = EntryId; this.CarId = CarId; this._TripId = TripId; this._Quality = Quality; this._Segment = Segment; this.Temporal = Temporal; this.Spatial = Spatial; this.Measure = Measure; this.Flag = Flag; }
public int AddQualityInformation(QualityInformation QI) { string sql = @"INSERT INTO qualityinformation(satellites, hdop) VALUES (@satellites, @hdop)"; NpgsqlCommand command = new NpgsqlCommand(sql, Connection); command.Parameters.AddWithValue("@satellites", QI.Sat); command.Parameters.AddWithValue("@hdop", QI.Hdop); return NonQuery(command, "qualityinformation"); }
public Fact(DataRow row) { if (row.Table.Columns.Contains("entryid")) { this._EntryId = row.Field<Int64>("entryid"); } if (row.Table.Columns.Contains("carid")) { this.CarId = row.Field<int>("carid"); } if (row.Table.Columns.Contains("tripid")) { this._TripId = row.Field<Int64>("tripid"); } /* if (row.Table.Columns.Contains("localtripid")) { this._LocalTripId = row.Field<Int64>("localtripid"); } */ //Spatial Information if (row.Table.Columns.Contains("distancetolag") && row.Table.Columns.Contains("pathline")) { row["distancetolag"] = row["distancetolag"] is DBNull ? -1.0 : row["distancetolag"]; row["pathline"] = row["pathline"] is DBNull ? null : row["pathline"]; this.Spatial = new SpatialInformation(new GeoCoordinate(row.Field<double>("latitude"), row.Field<double>("longitude")), (double)row.Field<Single>("distancetolag"), row.Field<PostgisLineString>("pathline")); } else if (row.Table.Columns.Contains("pointlatitude")) { this.Spatial = new SpatialInformation(new GeoCoordinate(row.Field<double>("pointlatitude"), row.Field<double>("pointlongitude")), this._TripId); } else { this.Spatial = new SpatialInformation(new GeoCoordinate(row.Field<double>("latitude"), row.Field<double>("longitude"))); } //Temporal Information if (row.Table.Columns.Contains("secondstolag")) { row["secondstolag"] = row["secondstolag"] is DBNull ? 0 : row["secondstolag"]; this.Temporal = new TemporalInformation(DateTimeHelper.ConvertToDateTime(row.Field<int>("dateid"), row.Field<int>("timeid")), new TimeSpan(0, 0, row.Field<Int16>("secondstolag"))); } else { this.Temporal = new TemporalInformation(DateTimeHelper.ConvertToDateTime(row.Field<int>("dateid"), row.Field<int>("timeid"))); } //Measure Information if (row.Table.Columns.Contains("speed") && row.Table.Columns.Contains("acceleration") && row.Table.Columns.Contains("jerk")) { row["speed"] = row["speed"] is DBNull ? 0 : row["speed"]; row["acceleration"] = row["acceleration"] is DBNull ? 0 : row["acceleration"]; row["jerk"] = row["jerk"] is DBNull ? 0 : row["jerk"]; this.Measure = new MeasureInformation((double)row.Field<Single>("speed"), (double)row.Field<Single>("acceleration"), (double)row.Field<Single>("jerk")); } //Flag Information if (row.Table.Columns.Contains("speeding")) { row["speeding"] = row["speeding"] is DBNull ? false : row["speeding"]; row["accelerating"] = row["accelerating"] is DBNull ? false : row["accelerating"]; row["jerking"] = row["jerking"] is DBNull ? false : row["jerking"]; row["braking"] = row["braking"] is DBNull ? false : row["braking"]; row["steadyspeed"] = row["steadyspeed"] is DBNull ? false : row["steadyspeed"]; this.Flag = new FlagInformation(row.Field<bool>("speeding"), row.Field<bool>("accelerating"), row.Field<bool>("jerking"), row.Field<bool>("braking"), row.Field<bool>("steadyspeed")); } //Segment Information if (row.Table.Columns.Contains("segmentid") && row.Table.Columns.Contains("maxspeed")) { row["segmentid"] = row["segmentid"] is DBNull ? -1 : row["segmentid"]; row["maxspeed"] = row["maxspeed"] is DBNull ? -1 : row["maxspeed"]; this._Segment = new SegmentInformation(row.Field<int>("segmentid"), row.Field<Int16>("maxspeed")); } //Quality Information if (row.Table.Columns.Contains("qualityid") && row.Table.Columns.Contains("satellites") && row.Table.Columns.Contains("hdop")) { row["qualityid"] = row["qualityid"] is DBNull ? -1 : row["qualityid"]; row["satellites"] = row["satellites"] is DBNull ? -1 : row["satellites"]; row["hdop"] = row["hdop"] is DBNull ? -1 : row["hdop"]; this._Quality = new QualityInformation(row.Field<Int16>("qualityid"), row.Field<Int16>("satellites"), (double)row.Field<Single>("hdop")); } else if (row.Table.Columns.Contains("qualityid")) { this._Quality = new QualityInformation(-1, -1, -1); } }