public override void InsertAsync(TestScenario entity)
{
var sql = @"INSERT OR REPLACE INTO TFS_TestScenario AS TestScenario
(TestScenarioId, ContractRequirementId, ScenarioDescription, ScenarioName, ApplicationArea, ApplicationProcess)
VALUES
(@TestScenarioId, @ContractRequirementId, @ScenarioDescription, @ScenarioName, @ApplicationArea, @ApplicationProcess)";
using (var conn = GetOpenConnection())
{
try
{
conn.ExecuteAsync(sql, entity);
if (entity.TestCases != null)
{
foreach (TestCase testCase in entity.TestCases)
{
TestScenarioTestCaseMap currMap = new TestScenarioTestCaseMap
{
TestCaseId = testCase.TestCaseId,
TestScenarioId = entity.TestScenarioId
};
InsertTestScenarioTestCaseMap(currMap);
}
}
}
catch
{
throw new Exception();
}
}
}
private void InsertTestScenarioTestCaseMap(TestScenarioTestCaseMap testScenarioTestCaseMap)
{
var sql = @"INSERT OR REPLACE INTO MP_TestScenarioTestCaseMap AS TestScenarioTestCaseMap
(TestScenarioTestCaseId, TestScenarioId, TestCaseId)
VALUES
(@TestScenarioTestCaseId, @TestScenarioId, @TestCaseId)";
using (var conn = GetOpenConnection())
{
conn.Execute(sql, testScenarioTestCaseMap);
}
}
