public ModelView() { X = new List<double>(); Y = new List<double>(); dr = new DataRepository(); this.ListaStacji = dr.GetMeteoStations(); this.pomiaryT = new List<Measurement>(); this.pomiaryW = new List<Measurement>(); this.pomiaryC = new List<Measurement>(); // string nazwa = string.Empty; // nazwa = Chart.Okno.NazwyStacjiBox.SelectedItem.Name; this.Temp = new PlotModel { Title = "Temperatura" }; this.Wilg = new PlotModel { Title = "Wilgotnosc" }; this.Cis = new PlotModel { Title = "Cisnienie" }; this.LineTemp = new LineSeries { Title = "T" }; this.LineWilg = new LineSeries { Title = "W" }; this.LineCis = new LineSeries { Title = "C" }; this.AproTemp = new LineSeries { Title = "Aproksymacja" }; this.AproWilg = new LineSeries { Title = "Aproksymacja" }; this.AproCis = new LineSeries { Title = "Aproksymacja" }; this.dataPoczatkowa = Chart.Okno.pierwszaData; this.dataKoncowa = Chart.Okno.ostatniaData; Temperatura(); Wilgotnosc(); Cisnienie(); }
public void DisplayStation() { DataRepository dr = new DataRepository(); var q = from a in dr.GetMeteoStations() select a.Name; }
public void SaveMeasurement(double pressureValue, double temperatureValue, double wetnessValue, string stationName, DateTime dateOfMeasurement) { DataContainer dc = new DataContainer(); DataRepository dr = new DataRepository(); var stations = from meteostaion in dr.GetMeteoStations() where meteostaion.Name == stationName select meteostaion; dc.PressureList.Add(new Pressure { Value = pressureValue, Unit = "hPA", DateOfMeasuement = dateOfMeasurement, MeteoStationOfMeasurement = stations.First() }); dc.TemperatureList.Add(new Temperature { Value = temperatureValue, Unit = "C", DateOfMeasuement = dateOfMeasurement, MeteoStationOfMeasurement = stations.First() }); dc.WetnessList.Add(new Wetness { Value = wetnessValue, Unit = "%", DateOfMeasuement = dateOfMeasurement, MeteoStationOfMeasurement = stations.First() }); dc.SaveMeasurements(dr.GetCurrentDBContext()); }
//pochrzaniłem ;] public void SubmitMeasurements(string temperatureValue, string unitT, string pressureValue, string unitP, string wetnessValue, string unitW, //Wywołanie tej funkcji wrzucasz do guzika i tyle wystarczy, chyba nic nie DateTime timeOfMeasurement, string meteoStationName) { DataRepository dr = new DataRepository(); var querry = from station in dr.GetMeteoStations() where meteoStationName == station.Name select station; List<MeteoStation> stationOfMeasurementList = querry.ToList(); MeteoStation stationOfMeasurement = stationOfMeasurementList.First(); DataContainer dc = new DataContainer(); dc.PressureList.Add(SetPressure(pressureValue, unitP, timeOfMeasurement, stationOfMeasurement)); dc.TemperatureList.Add(SetTemperature(temperatureValue, unitT, timeOfMeasurement, stationOfMeasurement)); dc.WetnessList.Add(SetWetness(wetnessValue,unitW, timeOfMeasurement, stationOfMeasurement)); dc.SaveMeasurements(dr.GetCurrentDBContext()); }
public void RemoveMeasurements(Measurement toDelete, DataRepository dr) { List<Measurement> toDeleteList = getToDeleteList(toDelete, dr); MeteoStationDBContext currentContext = dr.GetCurrentDBContext(); var pressureListToDelete = from p in dr.GetPressures() where p.Id == toDeleteList[0].Id select p; Pressure pressureToDelete = pressureListToDelete.First(); var temperatureListToDelete = from p in dr.GetTemperatures() where p.Id == toDeleteList[0].Id select p; Temperature temperatureToDelete = temperatureListToDelete.First(); var wetnessListToDelete = from p in dr.GetWetneses() where p.Id == toDeleteList[0].Id select p; Wetness wetnessToDelete = wetnessListToDelete.First(); currentContext.Temperature.Remove(temperatureToDelete); currentContext.Pressure.Remove(pressureToDelete); currentContext.Wetness.Remove(wetnessToDelete); currentContext.SaveChanges(); }
private void Wilgotnosc() { SetUp(this.Wilg); DataRepository dr = new DataRepository(); if (dataKoncowa.ToString() != "01.01.0001 00:00:00" && dataPoczatkowa.ToString() != "01.01.0001 00:00:00") { var q = from a in dr.GetWetneses() where a.MeteoStationOfMeasurement.Name == Chart.Okno.NazwyStacjiBox.Text && (a.DateOfMeasuement >= Chart.Okno.pierwszaData && a.DateOfMeasuement <= Chart.Okno.ostatniaData) select new { a.DateOfMeasuement, a.Value }; foreach (var item in q.OrderBy(x => x.DateOfMeasuement.Date)) { this.pomiaryW.Add(new Wetness { DateOfMeasuement = item.DateOfMeasuement, Value = item.Value }); this.LineWilg.Points.Add(new DataPoint(DateTimeAxis.ToDouble(item.DateOfMeasuement.Date), item.Value)); } } else { var q = from a in dr.GetWetneses() where a.MeteoStationOfMeasurement.Name == Chart.Okno.NazwyStacjiBox.Text select new { a.DateOfMeasuement, a.Value }; foreach (var item in q.OrderBy(x => x.DateOfMeasuement.Date)) { this.pomiaryW.Add(new Wetness { DateOfMeasuement = item.DateOfMeasuement, Value = item.Value }); this.LineWilg.Points.Add(new DataPoint(DateTimeAxis.ToDouble(item.DateOfMeasuement.Date), item.Value)); } } this.Wilg.Series.Add(LineWilg); WypelnijListyZinterpolowanymiDanymi(pomiaryW, 0.1, Wilg, AproWilg); OnPropertyChanged("Wilgotnosc"); }
public ExcelExport() { //em = new ExcelManager(); dr = new DataRepository(); InitializeComponent(); }
public void RemoveStation(MeteoStation meteoStation, DataRepository dr) { removeMeasurementsByStationDeletion(meteoStation, dr); dr.meteoStationDbContext.MeteoStation.Remove(meteoStation); dr.meteoStationDbContext.SaveChanges(); }
/// <summary> /// Usuwa pomiar dla zadanej stacji. Obiekt DataRepository musi być ten sam, który został użyty do pobrania stacji, wiec należy go podać w parametrze. /// </summary> /// <param name="meteoStation"></param> /// <param name="dr"></param> private void removeMeasurementsByStationDeletion(MeteoStation meteoStation, DataRepository dr) { List<Measurement> list = new List<Measurement>(); dr.GetMeasurementsOfStation(meteoStation, this); foreach (var measurement in this.PressureList) { dr.meteoStationDbContext.Pressure.Remove(measurement); } foreach (var measurement in this.TemperatureList) { dr.meteoStationDbContext.Temperature.Remove(measurement); } foreach (var measurement in this.WetnessList) { dr.meteoStationDbContext.Wetness.Remove(measurement); } dr.meteoStationDbContext.SaveChanges(); }
private List<Measurement> getToDeleteList(Measurement toDelete, DataRepository dr) { var measurement = from a in dr.GetAllMeasurements() where a.Id == toDelete.Id select a; List<Measurement> toDeleteList = measurement.ToList(); return toDeleteList; }