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