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