/// <summary> /// Read in water levels from a Jupiter access database. /// Entries with blank dates of waterlevels are skipped. /// </summary> /// <param name="DataBaseFile"></param> /// <param name="CreateWells"></param> public void Waterlevels(IWellCollection Wells, bool OnlyRo) { JXL.ReadWaterLevels(OnlyRo); foreach (var WatLev in JXL.WATLEVEL) { //Find the well in the dictionary if (Wells.Contains(WatLev.BOREHOLENO)) { IIntake I = Wells[WatLev.BOREHOLENO].Intakes.FirstOrDefault(var => var.IDNumber == WatLev.INTAKENO); if (I != null) { FillInWaterLevel(I, WatLev); } } } JXL.WATLEVEL.Clear(); foreach (Well W in Wells) { foreach (Intake I in W.Intakes) { I.HeadObservations.Sort(); } } }