Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Parsers/OvertoppingCalculationWaveHeightParser.cs =================================================================== diff -u -r1d8c35ad08fddf6471c168876fc01552af29fd6a -r43a84f4c8402972a269b12fcc1eaf262fb6393b8 --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Parsers/OvertoppingCalculationWaveHeightParser.cs (.../OvertoppingCalculationWaveHeightParser.cs) (revision 1d8c35ad08fddf6471c168876fc01552af29fd6a) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Parsers/OvertoppingCalculationWaveHeightParser.cs (.../OvertoppingCalculationWaveHeightParser.cs) (revision 43a84f4c8402972a269b12fcc1eaf262fb6393b8) @@ -32,7 +32,6 @@ /// public class OvertoppingCalculationWaveHeightParser : IHydraRingFileParser { - private const string sectionIdParameterName = "@sectionId"; private const string waveHeightColumn = "WaveHeight"; private const string isOvertoppingDominantColumn = "IsOvertoppingDominant"; @@ -42,15 +41,15 @@ "(SELECT d.OuterIterationId, d.PeriodId, BetaValue, ClosingSituationId, d.WindDirectionId, LevelTypeId, SubMechanismId " + "FROM GoverningWind g " + "JOIN DesignBeta d ON d.WindDirectionId = g.WindDirectionId AND d.OuterIterationId = g.OuterIterationId AND d.PeriodId = g.PeriodId " + - $"WHERE LevelTypeId = 7 AND d.SubMechanismId = 102 AND SectionId = {sectionIdParameterName} " + + $"WHERE LevelTypeId = 7 AND d.SubMechanismId = 102 AND SectionId = {HydraRingDatabaseConstants.SectionIdParameterName} " + "ORDER BY d.OuterIterationId DESC, d.PeriodId, BetaValue " + "LIMIT 1) as g " + "JOIN " + "(SELECT Value FROM GoverningWind g " + "JOIN DesignPointResults d ON d.WindDirectionId = g.WindDirectionId AND d.OuterIterationId = g.OuterIterationId AND d.PeriodId = g.PeriodId " + "JOIN DesignBeta db ON db.WindDirectionId = d.WindDirectionId AND db.ClosingSituationId = d.ClosingSituationId AND db.OuterIterationId = d.OuterIterationId " + "AND db.PeriodId = d.PeriodId " + - $"WHERE OutputVariableId = 3 AND db.LevelTypeId = 7 AND db.SectionId = {sectionIdParameterName} " + + $"WHERE OutputVariableId = 3 AND db.LevelTypeId = 7 AND db.SectionId = {HydraRingDatabaseConstants.SectionIdParameterName} " + "ORDER BY d.OuterIterationId DESC, d.PeriodId, db.BetaValue " + "LIMIT 1) " + "Order By g.BetaValue " +