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