public static void AddDataForNovanaPejl(IEnumerable <JupiterIntake> Intakes, DateTime start, DateTime end) { ShapeOutputTables.PejlingerDataTable DT1 = new ShapeOutputTables.PejlingerDataTable(); ShapeOutputTables.PejlingerRow CurrentRow; ShapeOutputTables.IntakeCommonDataTable DT2 = new ShapeOutputTables.IntakeCommonDataTable(); foreach (JupiterIntake CurrentIntake in Intakes) { CurrentIntake.Data = DT2.NewIntakeCommonRow(); AddCommonDataForNovana(CurrentIntake); DT2.Rows.Add(CurrentIntake.Data); CurrentRow = DT1.NewPejlingerRow(); CurrentRow.NOVANAID = CurrentIntake.Data["NOVANAID"].ToString(); DT1.Rows.Add(CurrentRow); var selectedobs = CurrentIntake.HeadObservations.ItemsInPeriod(start, end); //Create statistics on water levels CurrentRow.ANTPEJ = selectedobs.Count(); if (CurrentRow.ANTPEJ > 0) { CurrentRow.REFPOINT = CurrentIntake.RefPoint; CurrentRow.MINDATO = selectedobs.First().Time; CurrentRow.MAXDATO = selectedobs.Last().Time; CurrentRow.AKTAAR = CurrentRow.MAXDATO.Year - CurrentRow.MINDATO.Year + 1; CurrentRow.AKTDAGE = CurrentRow.MAXDATO.Subtract(CurrentRow.MINDATO).Days + 1; CurrentRow.PEJPRAAR = CurrentRow.ANTPEJ / CurrentRow.AKTAAR; CurrentRow.MAXPEJ = selectedobs.Max(num => num.Value); CurrentRow.MINPEJ = selectedobs.Min(num => num.Value); CurrentRow.MEANPEJ = selectedobs.Average(num => num.Value); } } //Add a blank string to ensure length of column DT2.Rows[0]["COMMENT"] = " "; DT2.Merge(DT1); }
public static void AddDataForNovanaPejl(IEnumerable<JupiterIntake> Intakes, DateTime start, DateTime end) { ShapeOutputTables.PejlingerDataTable DT1 = new ShapeOutputTables.PejlingerDataTable(); ShapeOutputTables.PejlingerRow CurrentRow; ShapeOutputTables.IntakeCommonDataTable DT2 = new ShapeOutputTables.IntakeCommonDataTable(); foreach (JupiterIntake CurrentIntake in Intakes) { CurrentIntake.Data = DT2.NewIntakeCommonRow(); AddCommonDataForNovana(CurrentIntake); DT2.Rows.Add(CurrentIntake.Data); CurrentRow = DT1.NewPejlingerRow(); CurrentRow.NOVANAID = CurrentIntake.Data["NOVANAID"].ToString(); DT1.Rows.Add(CurrentRow); var selectedobs = CurrentIntake.HeadObservations.ItemsInPeriod(start, end); //Create statistics on water levels CurrentRow.ANTPEJ = selectedobs.Count(); if (CurrentRow.ANTPEJ > 0) { CurrentRow.REFPOINT = CurrentIntake.RefPoint; CurrentRow.MINDATO = selectedobs.First().Time; CurrentRow.MAXDATO = selectedobs.Last().Time; CurrentRow.AKTAAR = CurrentRow.MAXDATO.Year - CurrentRow.MINDATO.Year + 1; CurrentRow.AKTDAGE = CurrentRow.MAXDATO.Subtract(CurrentRow.MINDATO).Days + 1; CurrentRow.PEJPRAAR = CurrentRow.ANTPEJ / CurrentRow.AKTAAR; CurrentRow.MAXPEJ = selectedobs.Max(num => num.Value); CurrentRow.MINPEJ = selectedobs.Min(num => num.Value); CurrentRow.MEANPEJ = selectedobs.Average(num => num.Value); } } //Add a blank string to ensure length of column DT2.Rows[0]["COMMENT"] = " "; DT2.Merge(DT1); }