public IEnumerable <MedicalCourse> GetAllCourses()
{
CourseContext context = HttpContext.RequestServices.GetService(typeof(CourseContext)) as CourseContext;
GetAllCoursesHandler handler = new GetAllCoursesHandler(context);
return(handler.Handle());
}
public void GetAllCourses()
{
// arrange
List <MedicalCourse> list = new List <MedicalCourse>();
List <MedicalCourse> expected = new List <MedicalCourse>(2);
expected.Add(new MedicalCourse()
{
Name = "Ёндокринологи¤",
Qualification = 2
});
expected.Add(new MedicalCourse()
{
Name = "Ёндокринологи¤",
Qualification = 1
});
//act
Course.Data.CourseContext context = new Course.Data.CourseContext(connString);
GetAllCoursesHandler handler = new GetAllCoursesHandler(context);
handler.Handle();
using (conn = new MySqlConnection(connString))
{
conn.Open();
string query = string.Format("select * from Courses");
MySqlCommand cmd = new MySqlCommand(query, conn);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
list.Add(new MedicalCourse()
{
Id = Convert.ToInt32(reader["course_id"]),
Name = reader["course_name"].ToString(),
Qualification = Convert.ToInt32(reader["qualification"])
});
}
}
}
if (list[0].Name == expected[0].Name && list[0].Qualification == expected[0].Qualification &&
list[1].Name == expected[1].Name && list[1].Qualification == expected[1].Qualification)
{
Assert.IsTrue(true);
}
}
