public IEnumerable <MedicalHealthFacility> GetAllHealthFacilities() { HealthFacilityContext context = HttpContext.RequestServices.GetService(typeof(HealthFacilityContext)) as HealthFacilityContext; GetAllHealthFacilitiesHandler handler = new GetAllHealthFacilitiesHandler(context); return(handler.Handle()); }
public void GetAllTests() { // arrange List <MedicalHealthFacility> list = new List <MedicalHealthFacility>(); List <MedicalHealthFacility> expected = new List <MedicalHealthFacility>(2); expected.Add(new MedicalHealthFacility { Name = "string", Address = new Address { Street = "string", City = "string", Country = "string", House = 0 } }); expected.Add(new MedicalHealthFacility { Name = "Facility#3", Address = new Address { Street = "street", City = "city", Country = "country", House = 11 } }); //act HealthFacilityContext context = new HealthFacilityContext(connString); GetAllHealthFacilitiesHandler handler = new GetAllHealthFacilitiesHandler(context); handler.Handle(); using (conn = new MySqlConnection(connString)) { conn.Open(); string query = string.Format("select * from health_facilities"); MySqlCommand cmd = new MySqlCommand(query, conn); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { string addressString = reader["address"].ToString(); Address address = Converter.ConvertToAddress(addressString); list.Add(new MedicalHealthFacility() { Id = Convert.ToInt32(reader["faculty_id"]), Name = reader["name"].ToString(), Address = address, }); } } } if (list[0].Name == expected[0].Name && list[0].Address == expected[0].Address && list[1].Name == expected[1].Name && list[1].Address == expected[1].Address) { Assert.IsTrue(true); } }