Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Services/HydraRingConfigurationService.cs =================================================================== diff -u -r5b068f4916f07e38a76d936e76d3777229e80d6a -r2d7e8d4b70e86adab6fb0f5e2ddce3a6709df641 --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Services/HydraRingConfigurationService.cs (.../HydraRingConfigurationService.cs) (revision 5b068f4916f07e38a76d936e76d3777229e80d6a) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Services/HydraRingConfigurationService.cs (.../HydraRingConfigurationService.cs) (revision 2d7e8d4b70e86adab6fb0f5e2ddce3a6709df641) @@ -132,6 +132,7 @@ configurationDictionary["HydraulicModels"] = GetHydraulicModelsConfiguration(); configurationDictionary["Sections"] = GetSectionsConfiguration(); + configurationDictionary["SectionCalculationSchemes"] = GetSectionCalculationSchemesConfiguration(); configurationDictionary["DesignTables"] = GetDesignTablesConfiguration(); configurationDictionary["Numerics"] = GetNumericsConfiguration(); configurationDictionary["VariableDatas"] = GetVariableDatasConfiguration(); @@ -233,6 +234,32 @@ return orderedDictionaries; } + private IList GetSectionCalculationSchemesConfiguration() + { + var orderedDictionaries = new List(); + + foreach (HydraRingCalculationInput hydraRingCalculationInput in hydraRingInputs) + { + FailureMechanismDefaults failureMechanismDefaults = failureMechanismDefaultsProvider.GetFailureMechanismDefaults(hydraRingCalculationInput.FailureMechanismType); + HydraulicModelsSetting hydraulicModelSetting = hydraRingCalculationInput.HydraulicModelsSetting; + + orderedDictionaries.Add(new OrderedDictionary + { + { + "SectionId", hydraRingCalculationInput.Section.SectionId + }, + { + "MechanismId", failureMechanismDefaults.MechanismId + }, + { + "TimeIntegrationSchemeID", hydraulicModelSetting.TimeIntegrationSchemeId + } + }); + } + + return orderedDictionaries; + } + private IList GetDesignTablesConfiguration() { var orderedDictionaries = new List(); Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Calculator/HydraRingCalculatorBaseTest.cs =================================================================== diff -u -r5b068f4916f07e38a76d936e76d3777229e80d6a -r2d7e8d4b70e86adab6fb0f5e2ddce3a6709df641 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Calculator/HydraRingCalculatorBaseTest.cs (.../HydraRingCalculatorBaseTest.cs) (revision 5b068f4916f07e38a76d936e76d3777229e80d6a) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Calculator/HydraRingCalculatorBaseTest.cs (.../HydraRingCalculatorBaseTest.cs) (revision 2d7e8d4b70e86adab6fb0f5e2ddce3a6709df641) @@ -109,6 +109,7 @@ 1, new NumericsSetting(11, 4, 150, 0.15, 0.005, 0.005, 0.005, 2, 10000, 40000, 0.1, -6.0, 6.0, 25) } }; + HydraulicModelsSetting = new HydraulicModelsSetting(1); } public override HydraRingFailureMechanismType FailureMechanismType Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Integration/HydraRingConfigurationServiceIntegrationTest.cs =================================================================== diff -u -r5b068f4916f07e38a76d936e76d3777229e80d6a -r2d7e8d4b70e86adab6fb0f5e2ddce3a6709df641 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Integration/HydraRingConfigurationServiceIntegrationTest.cs (.../HydraRingConfigurationServiceIntegrationTest.cs) (revision 5b068f4916f07e38a76d936e76d3777229e80d6a) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Integration/HydraRingConfigurationServiceIntegrationTest.cs (.../HydraRingConfigurationServiceIntegrationTest.cs) (revision 2d7e8d4b70e86adab6fb0f5e2ddce3a6709df641) @@ -54,7 +54,8 @@ { 1, new NumericsSetting(1, 9, 150, 0.15, 0.01, 0.01, 0.01, 2, 3000, 10000, 0.1, -6, 6, 25) } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -63,6 +64,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 0, 0);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 1, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 1, 1, 1, 9, 26, 0, 0, 0, 0, 1.1, 2.2, 3.71901648545568);" + Environment.NewLine + Environment.NewLine + @@ -135,7 +139,8 @@ { 11, new NumericsSetting(1, 9, 150, 0.15, 0.01, 0.01, 0.01, 2, 3000, 10000, 0.1, -6, 6, 25) } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -144,6 +149,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 0, 0);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 11, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 11, 1, 1, 9, 28, 0, 0, 0, 0, 1.1, 2.2, 3.71901648545568);" + Environment.NewLine + Environment.NewLine + @@ -256,7 +264,8 @@ { 103, numericsSetting } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -265,6 +274,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 101, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 101, 1, 1, 1, 1, 0, 0, 0, 0, 17.17, 18.18, 0);" + Environment.NewLine + Environment.NewLine + @@ -390,7 +402,8 @@ { 103, numericsSetting } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); var expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -399,6 +412,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 101, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 101, 1, 1, 9, 1, 0, 0, 0, 0, 16.16, 17.17, 3.09023230616781);" + Environment.NewLine + Environment.NewLine + @@ -543,7 +559,8 @@ { 423, numericsSetting } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -552,6 +569,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 110, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 110, 1, 1, 1, 60, 0, 0, 0, 0, 0, 0, 0);" + Environment.NewLine + Environment.NewLine + @@ -660,7 +680,8 @@ { 5, new NumericsSetting(4, 1, 50, 0.15, 0.01, 0.01, 0.01, 2, 3000, 10000, 0.1, -6, 6, 25) } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -669,6 +690,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 56.23, 0);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 3, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 3, 1, 1, 8, 114, 0, 0, 0, 0, 7.7, 8.8, 3.71901648545568);" + Environment.NewLine + Environment.NewLine + @@ -767,7 +791,8 @@ { 5, new NumericsSetting(4, 1, 50, 0.15, 0.01, 0.01, 0.01, 2, 3000, 10000, 0.1, -6, 6, 25) } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -776,6 +801,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 86.48, 0);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 3, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 3, 1, 1, 8, 114, 0, 0, 0, 0, 8.8, 9.9, 3.71901648545568);" + Environment.NewLine + Environment.NewLine + @@ -868,7 +896,8 @@ 23.3, 24.4, 25.5, 26.6) { DesignTablesSetting = new DesignTablesSetting(0, 0), - NumericsSettings = CreateStructuresClosureNumericsSettings() + NumericsSettings = CreateStructuresClosureNumericsSettings(), + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -877,6 +906,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 111, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 111, 1, 1, 1, 58, 0, 0, 0, 0, 0, 0, 0);" + Environment.NewLine + Environment.NewLine + @@ -986,7 +1018,8 @@ 27.7, 28.8, 29.9, 30.0) { DesignTablesSetting = new DesignTablesSetting(0, 0), - NumericsSettings = CreateStructuresClosureNumericsSettings() + NumericsSettings = CreateStructuresClosureNumericsSettings(), + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -995,6 +1028,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 111, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 111, 1, 1, 1, 58, 0, 0, 0, 0, 0, 0, 0);" + Environment.NewLine + Environment.NewLine + @@ -1106,7 +1142,8 @@ 27.7, 28.8, 29.9, 30.0) { DesignTablesSetting = new DesignTablesSetting(0, 0), - NumericsSettings = CreateStructuresClosureNumericsSettings() + NumericsSettings = CreateStructuresClosureNumericsSettings(), + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -1115,6 +1152,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 111, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 111, 1, 1, 1, 58, 0, 0, 0, 0, 0, 0, 0);" + Environment.NewLine + Environment.NewLine + @@ -1235,7 +1275,8 @@ 59.9) { DesignTablesSetting = new DesignTablesSetting(0, 0), - NumericsSettings = CreateStructuresStabilityPointNumericsSettings() + NumericsSettings = CreateStructuresStabilityPointNumericsSettings(), + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -1244,6 +1285,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 112, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 112, 1, 1, 1, 58, 0, 0, 0, 0, 0, 0, 0);" + Environment.NewLine + Environment.NewLine + @@ -1386,7 +1430,8 @@ 59.9) { DesignTablesSetting = new DesignTablesSetting(0, 0), - NumericsSettings = CreateStructuresStabilityPointNumericsSettings() + NumericsSettings = CreateStructuresStabilityPointNumericsSettings(), + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -1395,6 +1440,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 112, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 112, 1, 1, 1, 58, 0, 0, 0, 0, 0, 0, 0);" + Environment.NewLine + Environment.NewLine + @@ -1537,7 +1585,8 @@ 59.9) { DesignTablesSetting = new DesignTablesSetting(0, 0), - NumericsSettings = CreateStructuresStabilityPointNumericsSettings() + NumericsSettings = CreateStructuresStabilityPointNumericsSettings(), + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -1546,6 +1595,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 112, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 112, 1, 1, 1, 58, 0, 0, 0, 0, 0, 0, 0);" + Environment.NewLine + Environment.NewLine + @@ -1688,7 +1740,8 @@ 59.9) { DesignTablesSetting = new DesignTablesSetting(0, 0), - NumericsSettings = CreateStructuresStabilityPointNumericsSettings() + NumericsSettings = CreateStructuresStabilityPointNumericsSettings(), + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -1697,6 +1750,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 112, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 112, 1, 1, 1, 58, 0, 0, 0, 0, 0, 0, 0);" + Environment.NewLine + Environment.NewLine + Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Services/HydraRingConfigurationServiceTest.cs =================================================================== diff -u -r5b068f4916f07e38a76d936e76d3777229e80d6a -r2d7e8d4b70e86adab6fb0f5e2ddce3a6709df641 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Services/HydraRingConfigurationServiceTest.cs (.../HydraRingConfigurationServiceTest.cs) (revision 5b068f4916f07e38a76d936e76d3777229e80d6a) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Services/HydraRingConfigurationServiceTest.cs (.../HydraRingConfigurationServiceTest.cs) (revision 2d7e8d4b70e86adab6fb0f5e2ddce3a6709df641) @@ -99,7 +99,8 @@ { 1, new NumericsSetting(8, 9, 10, 11.11, 12.12, 13.13, 14.14, 15, 16, 17, 18.18, 19.19, 20.20, 21) } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(3) }); var expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -108,6 +109,9 @@ "DELETE FROM [Sections];" + Environment.NewLine + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 1, 3);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 1, 1, 1, 4, 5, 0, 0, 0, 0, 6.6, 7.7, 1.1);" + Environment.NewLine + Environment.NewLine + @@ -194,7 +198,8 @@ { 1, new NumericsSetting(8, 9, 10, 11.11, 12.12, 13.13, 14.14, 15, 16, 17, 18.18, 19.19, 20.20, 21) } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(2) }); hydraRingConfigurationService.AddHydraRingCalculationInput(new HydraRingCalculationInputImplementation(2, 700005) { @@ -204,7 +209,8 @@ { 1, new NumericsSetting(108, 109, 110, 111.11, 112.12, 113.13, 114.14, 115, 116, 117, 118.18, 119.19, 120.20, 121) } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(3) }); hydraRingConfigurationService.AddHydraRingCalculationInput(new HydraRingCalculationInputImplementation(3, 700006) { @@ -214,7 +220,8 @@ { 1, new NumericsSetting(208, 209, 210, 211.11, 212.12, 213.13, 214.14, 215, 216, 217, 218.18, 219.19, 220.20, 221) } - } + }, + HydraulicModelsSetting = new HydraulicModelsSetting(1) }); var expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + @@ -225,6 +232,11 @@ "INSERT INTO [Sections] VALUES (2, 1, 1, 2, 2, 0, 0, 0, 0, 700005, 700005, 100, 3.3, 2.2);" + Environment.NewLine + "INSERT INTO [Sections] VALUES (3, 1, 1, 3, 3, 0, 0, 0, 0, 700006, 700006, 100, 3.3, 2.2);" + Environment.NewLine + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 1, 2);" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (2, 1, 3);" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (3, 1, 1);" + Environment.NewLine + + Environment.NewLine + "DELETE FROM [DesignTables];" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (1, 1, 1, 1, 4, 5, 0, 0, 0, 0, 6.6, 7.7, 1.1);" + Environment.NewLine + "INSERT INTO [DesignTables] VALUES (2, 1, 1, 1, 4, 5, 0, 0, 0, 0, 8.8, 9.9, 1.1);" + Environment.NewLine +