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;
}
