public AllTablesResult LoadAllTables(int stepPrecision) { var result = new AllTablesResult(); var tablesCsv = HydroModel.GetExpandedRatingTables(stepPrecision, CsvMetaHeader, CsvMetadata); if (string.IsNullOrEmpty(tablesCsv)) { return(result); } var csvRatings = AQCSV.Load(tablesCsv, true, new[] { "NumTables", "NumPeriods", "NumPoints" }); var tableNumber = CSVUtil.ToDouble(csvRatings.dataSet[0].datas, 0); var tableName = CSVUtil.ToString(csvRatings.dataSet[0].datas, 1); var numPeriods = CSVUtil.ToDouble(csvRatings.dataSet[0].datas, 2); var numPoints = CSVUtil.ToDouble(csvRatings.dataSet[0].datas, 3); for (var i = 0; i < tableNumber.Length; ++i) { result.Tables.Add(new Table { TableNumber = tableNumber[i], TableName = tableName[i], NumPeriods = numPeriods[i], NumPoints = numPoints[i] }); } var tableNumber2 = CSVUtil.ToDouble(csvRatings.dataSet[1].datas, 0); var startDate = CSVUtil.ToString(csvRatings.dataSet[1].datas, 1); var endDate = CSVUtil.ToString(csvRatings.dataSet[1].datas, 2); for (var i = 0; i < tableNumber2.Length; ++i) { result.TableDates.Add(new TableDate { TableNumber = tableNumber2[i], StartDate = DateTimeParser.Parse(LocationData, startDate[i]), EndDate = string.IsNullOrEmpty(endDate[i]) ? DateTimeOffset.MaxValue : DateTimeParser.Parse(LocationData, endDate[i]) }); } var tableNumber3 = CSVUtil.ToDouble(csvRatings.dataSet[2].datas, 0); var input = CSVUtil.ToDouble(csvRatings.dataSet[2].datas, 1); var output = CSVUtil.ToDouble(csvRatings.dataSet[2].datas, 2); for (var i = 0; i < tableNumber3.Length; ++i) { result.TableValues.Add(new TableValue { TableNumber = tableNumber3[i], Input = input[i], Output = output[i] }); } return(result); }
public RatingCurveResult LoadRatingCurve(RatingCurve curve, int stepPrecision, DateTimeOffset curveEffectiveTime) { var result = new RatingCurveResult(); var curveCsv = HydroModel.GetExpandedRatingTable( curveEffectiveTime.UtcDateTime.ToOADate(), stepPrecision, CsvMetaHeader, CsvMetadata); if (string.IsNullOrEmpty(curveCsv)) { return(result); } var csvRating = AQCSV.Load(curveCsv, true, new[] { "ExpandedPoints", "OriginalPoints" }); var regularStages = CSVUtil.ToDouble(csvRating.dataSet[0].datas, 0); var regularDischarges = CSVUtil.ToDouble(csvRating.dataSet[0].datas, 1); var shiftStages = CSVUtil.ToDouble(csvRating.dataSet[0].datas, 2); var shiftDischarges = CSVUtil.ToDouble(csvRating.dataSet[0].datas, 3); for (var i = 0; i < regularStages.Length; ++i) { result.ExpandedPoints.Add(new ExpandedPoint { Stage = regularStages[i], Discharge = regularDischarges[i], ShiftedStage = shiftStages[i], ShiftedDischarge = shiftDischarges[i] }); } var equationStages = CSVUtil.ToDouble(csvRating.dataSet[1].datas, 0); var equationDischarges = CSVUtil.ToDouble(csvRating.dataSet[1].datas, 1); for (var i = 0; i < equationStages.Length; ++i) { result.EquationPoints.Add(new EquationPoint { Stage = equationStages[i], Discharge = equationDischarges[i] }); } var curveStartTime = curve.PeriodsOfApplicability.First().StartTime; var curveEndTime = curve.PeriodsOfApplicability.Last().EndTime; var exceptions = GetRatingExceptions(curve.Id); var fieldVisitReadings = FieldVisitReadings.Where(r => { var time = new DateTimeOffset(DateTime.SpecifyKind(r.MeasurementTime, DateTimeKind.Unspecified), TimeSpan.FromHours(r.UtcOffset)); return(exceptions.IncludeIds.Contains(r.DiscreteMeasurementId) || !exceptions.ExcludeIds.Contains(r.DiscreteMeasurementId) && curveStartTime <= time && time < curveEndTime); }).ToList(); var measurementIds = fieldVisitReadings .Select(f => f.DiscreteMeasurementId) .Distinct(); result.RatingMeasurements = measurementIds .Select(id => CreateRatingMeasurement(fieldVisitReadings.Where(f => f.DiscreteMeasurementId == id).ToList())) .Where(r => r != null) .ToList(); return(result); }