public List <TestsDTO> GetTestsByServiceName(string serviceName)
{
var resultsList = new List <TestsDTO>();
using (var con = new SqlConnection(Config.ConnectionStings.AppDatabase))
{
var cmd = new SqlCommand("SELECT * FROM TESTCASES where ServiceName=@serviceName", con);
cmd.Parameters.Add(new SqlParameter("serviceName", serviceName));
con.Open();
var dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
var resultEntry = new TestsDTO()
{
Id = int.Parse(dataReader["id"].ToString()),
ProcessingTime = TimeSpan.Parse(dataReader["ProcessingTime"].ToString()),
Request = dataReader["request"].ToString(),
Response = dataReader["response"].ToString(),
UserId = int.Parse(dataReader["userId"].ToString()),
Uri = dataReader["Uri"].ToString(),
ServiceName = dataReader["ServiceName"].ToString()
};
resultsList.Add(resultEntry);
}
return(resultsList);
}
}
public bool InsertTestcaseInDB(TestsDTO testcase)
{
using (var con = new SqlConnection(Config.ConnectionStings.AppDatabase))
{
var cmd = new SqlCommand("INSERT INTO TESTCASES VALUES ( @request, @response, @userId, @procTime, @uri,@header, @servicename);", con);
cmd.Parameters.Add(new SqlParameter("procTime", testcase.ProcessingTime));
cmd.Parameters.Add(new SqlParameter("request", testcase.Request));
cmd.Parameters.Add(new SqlParameter("response", testcase.Response));
cmd.Parameters.Add(new SqlParameter("userId", testcase.UserId));
cmd.Parameters.Add(new SqlParameter("uri", testcase.Uri));
cmd.Parameters.Add(new SqlParameter("header", testcase.ServiceName));
cmd.Parameters.Add(new SqlParameter("servicename", testcase.ServiceName));
con.Open();
var dataReader = cmd.ExecuteNonQuery();
if (dataReader > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public static bool InsertInDB(Test test)
{
var testcaseRepo = new ResultsRepository();
var testcase = new TestsDTO
{
Request = test.Request,
Response = test.Response,
ProcessingTime = test.ProcessingTime,
UserId = test.UserId,
Uri = test.Uri,
ServiceName = test.ServiceName
};
return(testcaseRepo.InsertTestcaseInDB(testcase));
}
