public List <int> getValuesForList() { var assembly = typeof(Measurement).GetTypeInfo().Assembly; /*Definovanie cesty suboru*/ //Stream stream = assembly.GetManifestResourceStream("Xamarin.Forms_EFCore.initializationValues.txt"); Stream stream = assembly.GetManifestResourceStream("Xamarin.Forms_EFCore.initDataset.txt"); DatabaseContext databaseContext = new DatabaseContext(); // List<Json> objects = new List<Json>(); List <DatasetJson> objects = new List <DatasetJson>(); List <int> occurs = new List <int>(); using (StreamReader sr = new StreamReader(stream)) { while (sr.Peek() >= 0) { /*Json obj = Newtonsoft.Json.JsonConvert.DeserializeObject<Json>(sr.ReadLine()); * objects.Add(obj); * occurs.Add(Convert.ToInt32(obj.body.heart_rate.value));*/ DatasetJson obj = Newtonsoft.Json.JsonConvert.DeserializeObject <DatasetJson>(sr.ReadLine()); objects.Add(obj); occurs.Add(Convert.ToInt32(obj.value)); } } return(occurs); }
public async void readLineFromDatasetFile() { try { DatabaseContext context = new DatabaseContext(); IFileSystem fileSystem = FileSystem.Current; IFolder rootFolder = fileSystem.LocalStorage; IFile tempFile = await rootFolder.GetFileAsync("pulseDataset.txt"); string newFileText; string line; string fileText = await tempFile.ReadAllTextAsync(); using (System.IO.StringReader reader = new System.IO.StringReader(fileText)) { line = reader.ReadLine(); //System.Diagnostics.Debug.WriteLine("READ from file pulse " + line); newFileText = reader.ReadToEnd(); } tempFile.WriteAllTextAsync(newFileText); DatasetJson obj = Newtonsoft.Json.JsonConvert.DeserializeObject <DatasetJson>(line); int index = 1; if (!context.Pulse.Any()) { index = 1; } else { Tep tmp = context.Pulse.FirstOrDefault(t => t.TepId == context.Pulse.Max(x => x.TepId)); index = tmp.TepId; index++; } Tep tep = new Tep { TepId = index, //TimeStamp = obj.header.creation_date_time.ToString(), TimeStamp = obj.timestamp.ToString(), Hodnota = obj.value }; context.Pulse.Add(tep); //System.Diagnostics.Debug.WriteLine("****** VLOZENIE TEPU DO DB: " + tep.TepId + " " + tep.Hodnota + " " + tep.TimeStamp); context.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine("Citanie pulz suboru zo zariadenia: " + nameof(LoadPulse) + e.ToString()); } }
public void LoadPulseDataset(DatabaseContext context) { var assembly = typeof(LoadPulse).GetTypeInfo().Assembly; /*Definovanie cesty suboru*/ //Stream stream = assembly.GetManifestResourceStream("Xamarin.Forms_EFCore.pulseWeek.txt"); Stream stream = assembly.GetManifestResourceStream("Xamarin.Forms_EFCore.pulseDataset.txt"); List <Json> objects = new List <Json>(); /*nahranie dat a sparsovanie*/ int i = 0; int index = 1; if (!context.Pulse.Any()) { index = 1; } else { Tep tmp = context.Pulse.FirstOrDefault(t => t.TepId == context.Pulse.Max(x => x.TepId)); index = tmp.TepId; index++; } using (StreamReader sr = new StreamReader(stream)) { while (sr.Peek() >= 0) { DatasetJson obj = Newtonsoft.Json.JsonConvert.DeserializeObject <DatasetJson>(sr.ReadLine()); //objects.Add(obj); //System.Diagnostics.Debug.WriteLine(i++ +" + " + obj.header.creation_date_time.ToString() + " + " + obj.body.heart_rate.value); Tep tep = new Tep { TepId = index++, TimeStamp = obj.timestamp.ToString(), Hodnota = obj.value }; context.Pulse.Add(tep); } } try { context.SaveChanges(); } catch (Exception e) { throw e; } /*Vypis tabulky z DB*/ /* var all = context.Pulse.ToList(); * foreach (var a in all) * { * System.Diagnostics.Debug.WriteLine(a.TepId + " " + a.TimeStamp + " " + a.Hodnota); * * * } */ }
public void loadValues() { var assembly = typeof(Measurement).GetTypeInfo().Assembly; /*Definovanie cesty suboru*/ // Stream stream = assembly.GetManifestResourceStream("Xamarin.Forms_EFCore.initializationValues.txt"); Stream stream = assembly.GetManifestResourceStream("Xamarin.Forms_EFCore.initDataset.txt"); DatabaseContext databaseContext = new DatabaseContext(); //List<Json> objects = new List<Json>(); List <DatasetJson> objects = new List <DatasetJson>(); /*nahranie dat a sparsovanie*/ int i = 0; int index = 1; if (!databaseContext.Pulse.Any()) { index = 1; } else { Tep tmp = databaseContext.Pulse.FirstOrDefault(t => t.TepId == databaseContext.Pulse.Max(x => x.TepId)); index = tmp.TepId; } index++; using (StreamReader sr = new StreamReader(stream)) { while (sr.Peek() >= 0) { /* Json obj = Newtonsoft.Json.JsonConvert.DeserializeObject<Json>(sr.ReadLine()); * objects.Add(obj); * * String create_date = obj.header.creation_date_time; * float value = obj.body.heart_rate.value; */ DatasetJson obj = Newtonsoft.Json.JsonConvert.DeserializeObject <DatasetJson>(sr.ReadLine()); objects.Add(obj); String create_date = obj.timestamp.ToString(); float value = obj.value; Tep tep = new Tep { TepId = index++, TimeStamp = create_date, Hodnota = value }; databaseContext.Pulse.Add(tep); } } try { databaseContext.SaveChanges(); } catch (Exception e) { System.Diagnostics.Debug.WriteLine("measurement load values* "); } var all = databaseContext.Pulse.ToList(); foreach (var a in all) { System.Diagnostics.Debug.WriteLine("******************************* " + a.TepId + " " + a.TimeStamp + " " + a.Hodnota); } }