public void Build_Prediction_Marker(PointLatLng Base_Position, string ACID, MySqlProvider.PredictionTableNumberType Table_Type, ref GMapOverlay Overlay) { MySqlProvider SqlProvider = new MySqlProvider(); System.Collections.Generic.List <MySqlProvider.PredictionDataSetOneRow> Record = SqlProvider.GetOneRecordPerTimeAndACID(Table_Type, SharedData.LookAheadTime, ACID, false); // If prediction data for the given parameters exists // then lets add it to the display list. if (Record.Count > 0) { GeoCordSystemDegMinSecUtilities.LatLongClass P_Pont = new GeoCordSystemDegMinSecUtilities.LatLongClass(double.Parse(Record[0].Lat), double.Parse(Record[0].Lon)); PointLatLng PredictedPoint = new PointLatLng(P_Pont.GetLatLongDecimal().LatitudeDecimal, P_Pont.GetLatLongDecimal().LongitudeDecimal); PredictionMarker PM; string label = Record[0].ACID + "\n" + Record[0].Time.ToShortTimeString(); switch (Table_Type) { case MySqlProvider.PredictionTableNumberType.One: PM = new PredictionMarker(Base_Position, Color.Magenta, PredictedPoint, label); Overlay.Markers.Add(PM); break; case MySqlProvider.PredictionTableNumberType.Two: PM = new PredictionMarker(Base_Position, Color.Blue, PredictedPoint, label); Overlay.Markers.Add(PM); break; case MySqlProvider.PredictionTableNumberType.Three: PM = new PredictionMarker(Base_Position, Color.Orange, PredictedPoint, label); Overlay.Markers.Add(PM); break; } } }
//DateTimeOut = "'2013-1-29 10:14:00'"; public static string BuildMySqlDateTimeString(TimeSpan TimeToAdd, bool Is_DBM_Lookup, MySqlProvider.PredictionTableNumberType Table) { DateTime T; if (SharedData.UseDBM_Replay_Time == false) { T = DateTime.UtcNow + TimeToAdd; } else { if (Is_DBM_Lookup) { MySqlProvider MySQL = new MySqlProvider(); System.Collections.Generic.List <MySqlProvider.PredictionDataSetOneRow> DataRetreived = MySQL.GetFirstTimeFromTable(Table); T = DataRetreived[0].Time + TimeToAdd; } else { T = P_Test.TimeHanlder.GetDBMTime() + TimeToAdd; } } string DateTimeOut = "'" + T.Year.ToString() + "-" + T.Month + "-" + T.Day.ToString() + " " + T.Hour.ToString() + ":" + T.Minute.ToString() + ":" + T.Second.ToString() + "'"; return(DateTimeOut); }