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