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