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); } }
public void CreateTestTest() { // arrange List <TrainingTest> list = new List <TrainingTest>(); TrainingTest expected = new TrainingTest { CourseId = 1, SpecialistId = 1, TopicId = 1, Date = new DateTime(2010, 8, 18, 16, 32, 0), Result = 97 }; CreateTestCommand command = new CreateTestCommand { CourseId = 1, Date = new DateTime(2010, 8, 18, 16, 32, 0), Result = 98, SpecialistId = 1, TopicId = 1 }; //act Test.Data.TestContext context = new Test.Data.TestContext(connString); CreateTestHandler handler = new CreateTestHandler(context); handler.Handle(command); using (conn = new MySqlConnection(connString)) { conn.Open(); string query = string.Format("select * from training_tests where result=98 and specialists_specialist_id=1" + "and topics_topic_id=1, date='{0}' and topics_courses_course_id=1", command.Date.ToString("yyyy-MM-dd HH:mm:ss")); 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); } }