List <GeoLocationModel> GetData() { DateTime sdate = DateTime.Today; DateTime edate; if (txtdate.Text != "") { sdate = Utility.ConvertToDate(txtdate.Text); } edate = sdate.AddDays(1); List <GeoLocationModel> list = new System.Collections.Generic.List <GeoLocationModel>(); using (var db = new SQLite.SQLiteConnection(pathToDatabase, true)) { var geos = db.Table <GeoLocation> ().Where(x => x.Date >= sdate && x.Date <= edate).OrderBy(x => x.Date).ToList(); foreach (var geo in geos) { GeoLocationModel m = new GeoLocationModel(); m.Altitude = geo.Altitude; m.Date = geo.Date.ToString("dd-MM-yy hh:mm tt"); m.lat = geo.lat; m.lng = geo.lng; m.Desc = geo.Date.ToString("dd-MM-yy hh:mm tt"); list.Add(m); } } return(list); }
List<GeoLocationModel> GetData() { DateTime sdate =DateTime.Today; DateTime edate; if (txtdate.Text!="") sdate = Utility.ConvertToDate (txtdate.Text); edate = sdate.AddDays (1); List<GeoLocationModel> list= new System.Collections.Generic.List<GeoLocationModel>(); using (var db = new SQLite.SQLiteConnection(pathToDatabase, true)) { var geos = db.Table<GeoLocation> ().Where (x => x.Date >= sdate && x.Date <= edate).OrderBy (x => x.Date).ToList(); foreach(var geo in geos){ GeoLocationModel m = new GeoLocationModel (); m.Altitude = geo.Altitude; m.Date = geo.Date.ToString ("dd-MM-yy hh:mm tt"); m.lat = geo.lat; m.lng = geo.lng; m.Desc= geo.Date.ToString ("dd-MM-yy hh:mm tt"); list.Add (m); } } return list; }