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;
}
}
