public TrainingTest GetTrainingTestById(int id)
{
TestContext context = HttpContext.RequestServices.GetService(typeof(TestContext)) as TestContext;
GetTestByIdHandler handler = new GetTestByIdHandler(context);
return(handler.Handle(id));
}
public void GetTestByIdTest()
{
// arrange
List <TrainingTest> list = new List <TrainingTest>();
int id = 2;
TrainingTest expected = new TrainingTest
{
CourseId = 1,
SpecialistId = 1,
TopicId = 1,
Date = new DateTime(),
Result = 97
};
//act
Test.Data.TestContext context = new Test.Data.TestContext(connString);
GetTestByIdHandler handler = new GetTestByIdHandler(context);
handler.Handle(id);
using (conn = new MySqlConnection(connString))
{
conn.Open();
string query = string.Format("select * from training_tests where training_id=2");
MySqlCommand cmd = new MySqlCommand(query, conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new TrainingTest()
{
Id = Convert.ToInt32(reader["training_id"]),
Date = Convert.ToDateTime(reader["date"]),
Result = Convert.ToInt32(reader["result"]),
SpecialistId = Convert.ToInt32(reader["Specialists_specialist_id"]),
TopicId = Convert.ToInt32(reader["Topics_topic_id"]),
CourseId = Convert.ToInt32(reader["Topics_Courses_course_id"])
});
}
}
}
if (list[0].Result == expected.Result && list[0].SpecialistId == expected.SpecialistId &&
list[0].TopicId == expected.TopicId && list[0].Date == expected.Date &&
list[0].CourseId == expected.CourseId)
{
Assert.IsTrue(true);
}
}
