public void UpdateFacilityTest()
{
// arrange
List <MedicalHealthFacility> list = new List <MedicalHealthFacility>();
int id = 2;
MedicalHealthFacility expected = new MedicalHealthFacility
{
Name = "Facility#3",
Address = new Address {
Street = "s", City = "c", Country = "c", House = 1
},
};
CreateHealthFacitityCommand command = new CreateHealthFacitityCommand
{
Name = "Facility#3",
Address = new Address {
Street = "street", City = "city", Country = "country", House = 11
},
};
//act
HealthFacilityContext context = new HealthFacilityContext(connString);
UpdateHealthFacilityHandler handler = new UpdateHealthFacilityHandler(context);
handler.Handle(2, command);
using (conn = new MySqlConnection(connString))
{
conn.Open();
string query = string.Format("select * from health_facilities where address='улица street, дом 11, город city, страна country' and name='Facility#3'");
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.Name && list[0].Address == expected.Address && list[0].Id == id)
{
Assert.IsTrue(true);
}
}
public void GetTestByIdTest()
{
// arrange
List <MedicalHealthFacility> list = new List <MedicalHealthFacility>();
int id = 2;
MedicalHealthFacility expected = new MedicalHealthFacility
{
Name = "Facility#3",
Address = new Address {
Street = "street", City = "city", Country = "country", House = 11
}
};
//act
HealthFacilityContext context = new HealthFacilityContext(connString);
GetHealthFacilityByIdHandler handler = new GetHealthFacilityByIdHandler(context);
handler.Handle(id);
using (conn = new MySqlConnection(connString))
{
conn.Open();
string query = string.Format("select * from health_facilities where faculty_id=2");
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.Name && list[0].Address == expected.Address)
{
Assert.IsTrue(true);
}
}