public void ToIsoDatabase() { try { IsolatedStorageSettings settings = IsolatedStorageSettings.ApplicationSettings; using (JustRunDataContext db = new JustRunDataContext(JustRunDataContext.ConnectionString)) { db.CreateIfNotExists(); db.LogDebug = true; var info = (User)settings["UserInfo"]; UserData a = new UserData(); a.Age = info.age; a.Gender = info.gender; a.Grade = info.grade; a.Weight = info.weight; db.UserDatas.InsertOnSubmit(a); db.SubmitChanges(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void DrawRoute(RunData item) { JustRunDataContext db = new JustRunDataContext(JustRunDataContext.ConnectionString); GeoCoordinateCollection geoCollection = new GeoCoordinateCollection(); var geoCords = db.GeoCords.Where(p => p.No == item.No); foreach(var gc in geoCords) { GeoCoordinate _geoCord=new GeoCoordinate(); _geoCord.Longitude=gc.Longitude; _geoCord.Latitude=gc.Latitude; geoCollection.Add(_geoCord); } if (geoCollection.Count != 0) Map.Center = geoCollection[0]; else { MessageBox.Show(AppResources.NoGeoFoundMsg); NavigationService.GoBack(); return; } Map.ZoomLevel = 16; Time.Text = item.Datetime.ToShortTimeString(); Date.Text = item.Datetime.ToShortDateString(); foreach (var geoCord in geoCollection) { _line.Path.Add(geoCord); } MapOverlay myLocationOverlay = new MapOverlay(); BitmapImage tn = new BitmapImage(); tn.SetSource(Application.GetResourceStream(new Uri(@"Assets/finishflag.png", UriKind.Relative)).Stream); Image img = new Image(); img.Source = tn; img.Height = 80; img.Width = 80; myLocationOverlay.Content = img; myLocationOverlay.PositionOrigin = new Point(0.5, 0.5); myLocationOverlay.GeoCoordinate = geoCollection[geoCollection.Count - 1]; MapLayer myLocationLayer = new MapLayer(); myLocationLayer.Add(myLocationOverlay); myLocationOverlay = new MapOverlay(); tn = new BitmapImage(); tn.SetSource(Application.GetResourceStream(new Uri(@"Assets/GreenBall.png", UriKind.Relative)).Stream); img = new Image(); img.Source = tn; img.Height = 25; img.Width = 25; myLocationOverlay.Content = img; myLocationOverlay.PositionOrigin = new Point(0.5, 0.5); myLocationOverlay.GeoCoordinate = geoCollection[0]; myLocationLayer.Add(myLocationOverlay); Map.Layers.Add(myLocationLayer); Map.Center = geoCollection[geoCollection.Count / 2]; }
protected override void OnNavigatedTo(NavigationEventArgs e) { base.OnNavigatedTo(e); if (NavigationContext.QueryString.ContainsKey("no")) { JustRunDataContext db = new JustRunDataContext(JustRunDataContext.ConnectionString); var data = db.RunDatas; RunData item = data.Single(p => p.No == int.Parse(NavigationContext.QueryString["no"])); DrawRoute(item); } //if (NavigationContext.QueryString.ContainsKey("item")) //{ // //int no = int.Parse(NavigationContext.QueryString["item"]); // var item = (RunData)IsolatedStorageSettings.ApplicationSettings["TempData"]; // DrawRoute(item); //} }
public static ObservableCollection<ChartDataContext> GetChartData(DateTime datetime, string type, int dayNumber) { JustRunDataContext db = new JustRunDataContext(JustRunDataContext.ConnectionString); ObservableCollection<ChartDataContext> values = new ObservableCollection<ChartDataContext>(); var RunDatas = new List<RunData>(); foreach (var item in db.RunDatas) { var a = item; // MessageBox.Show(a.Datetime.ToString()); a.Datetime = item.Datetime.Date; //MessageBox.Show(a.Datetime.ToString()); RunDatas.Add(a); } //MessageBox.Show(datetime.AddDays(-dayNumber).ToString()); var data = from p in RunDatas where p.Datetime >= datetime.AddDays(-dayNumber) && p.Datetime <= datetime group p by p.Datetime into g select new { _dateTime = g.Key, _burnedCalories = g.Sum(p => p.BurnedCalories), _distance = g.Sum(p => p.Distance) }; if (type == "Calories") foreach (var item in data) { // MessageBox.Show(item.ToString()); values.Add(new ChartDataContext(item._dateTime.ToShortDateString(), item._burnedCalories)); } if (type == "Distance") foreach (var item in data) { values.Add(new ChartDataContext(item._dateTime.ToShortDateString(), (double)item._distance)); } return values; }
public static void ToGeoCordTable(GeoCoordinateCollection geoCordCollection, int No) { using (JustRunDataContext db = new JustRunDataContext(JustRunDataContext.ConnectionString)) { db.CreateIfNotExists(); db.LogDebug = true; foreach (var _geoCord in geoCordCollection) { GeoCord geoCord = new GeoCord(); geoCord.No = No; geoCord.Latitude = _geoCord.Latitude; geoCord.Longitude = _geoCord.Longitude; db.GeoCords.InsertOnSubmit(geoCord); } db.SubmitChanges(); } }
public static void ToIsoDatabase() { try { JustRunDataContext db = new JustRunDataContext(JustRunDataContext.ConnectionString); db.CreateIfNotExists(); db.LogDebug = true; var data = (List<ARunData>)IsolatedStorageSettings.ApplicationSettings["RunData"]; foreach (var item in data) { RunData runData = new RunData(); runData.Duration = item.Duration; runData.Distance = item.Distance; runData.AvgPace = item.AvgPace; runData.AvgSpeed = item.AvgSpeed; runData.BurnedCalories = item.BurnedCalories; runData.Datetime = item.datetime; db.RunDatas.InsertOnSubmit(runData); db.SubmitChanges(); var max = db.RunDatas.Max(p => p.No); ARunData.ToGeoCordTable(item.geoCollection, max); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Constructor for the Application object. /// </summary> public App() { // Global handler for uncaught exceptions. UnhandledException += Application_UnhandledException; // Standard XAML initialization InitializeComponent(); // Phone-specific initialization InitializePhoneApplication(); using (JustRunDataContext db = new JustRunDataContext(JustRunDataContext.ConnectionString)) { db.CreateIfNotExists(); db.LogDebug = true; } try { IsolatedStorageSettings settings = IsolatedStorageSettings.ApplicationSettings; if (!settings.Contains("ReleaseCount")) // 1.0.0.2 version { settings.Add("ReleaseCount", int.Parse(AppResources._ReleaseCount)); if (!settings.Contains("NewRelease")) settings.Add("NewRelease", true); else settings["NewRelease"] = true; if (!settings.Contains("LaunchCount")) settings.Add("LaunchCount", 0); //else //{ // settings["LaunchCount"] = 0; //} } else { if ((int)settings["ReleaseCount"] < int.Parse(AppResources._ReleaseCount)) { if (!settings.Contains("NewRelease")) settings.Add("NewRelease", true); else settings["NewRelease"] = true; if (!settings.Contains("LaunchCount")) settings.Add("LaunchCount", 0); } } if (!settings.Contains("Voted")) settings.Add("Voted", false); if (!settings.Contains("FirstRunAndNotRegistered")) { using (JustRunDataContext db = new JustRunDataContext(JustRunDataContext.ConnectionString)) { db.CreateIfNotExists(); db.LogDebug = true; UserData userInfo = new UserData(); db.UserDatas.InsertOnSubmit(userInfo); db.SubmitChanges(); } AppSettings appSettings = new AppSettings(); appSettings._language = Thread.CurrentThread.CurrentCulture.Name; if (!settings.Contains("NewRelease")) settings.Add("NewRelease", true); else { settings["NewRelese"] = true; } settings.Add("AppSettings", appSettings); settings.Add("FirstRunAndNotRegistered", true); //TRUE or NOT FOUND means first run and haven't registered yet while // FALSE means IT"S NOT FIRST RUN & ALREADY REGISTERED!! } settings.Save(); } catch { } // Language display initialization InitializeLanguage(); // Show graphics profiling information while debugging. if (Debugger.IsAttached) { // Display the current frame rate counters. Application.Current.Host.Settings.EnableFrameRateCounter = true; // Show the areas of the app that are being redrawn in each frame. //Application.Current.Host.Settings.EnableRedrawRegions = true; // Enable non-production analysis visualization mode, // which shows areas of a page that are handed off to GPU with a colored overlay. //Application.Current.Host.Settings.EnableCacheVisualization = true; // Prevent the screen from turning off while under the debugger by disabling // the application's idle detection. // Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run // and consume battery power when the user is not using the phone. PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled; } }