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