public static string AddTest(TestItem item) { var updateMessage = string.Empty; string connectionString = GetConnectionString(); var param = new { item.ContractId, item.TestNumber, item.InputJson, item.TestFileDescription, item.OutputJson }; using (var connection = new SqlConnection(connectionString)) { // result = connection.Query<TestItem>(SelectOneTestCommand, param).First(); try { connection.Execute(AddTestStr, param); } catch (Exception excep) { updateMessage = excep.Message; } return updateMessage; } }
public static string UpdateTest(TestItem item) { var updateMessage = string.Empty; string connectionString = GetConnectionString(); var param = new { item.ContractId, item.TestNumber, item.InputJson, item.TestFileDescription, item.OutputJson, item.TestRequestFileId }; using (var connection = new SqlConnection(connectionString)) { try { connection.Execute(UpdateTestStr, param); } catch (Exception excep) { updateMessage = excep.Message; } return updateMessage; } }