public bool Handle(int healthFacilityId, CreateHealthFacitityCommand request)
{
var model = request.Adapt <Model.MedicalHealthFacility>();
using (MySqlConnection conn = _context.GetConnection())
{
conn.Open();
string query = string.Format("update health_facilities set name = '{1}', address= '{2}' where faculty_id={0}",
healthFacilityId.ToString(),
model.Name,
Converter.ConvertToString(model.Address));
MySqlCommand cmd = new MySqlCommand(query, conn);
try
{
cmd.ExecuteNonQuery();
}
catch
{
return(false);
}
finally
{
conn.CloseAsync();
}
}
return(true);
}
public bool Handle(CreateHealthFacitityCommand request)
{
var model = request.Adapt <MedicalHealthFacility>();
string address = string.Format("улица {0}, дом {1}, город {2}, страна {3}", model.Address.Street, model.Address.House, model.Address.City, model.Address.Country);
using (MySqlConnection conn = _context.GetConnection())
{
conn.Open();
string query = string.Format("insert into Health_Facilities(name, address) values('{0}', '{1}')",
model.Name, address);
MySqlCommand cmd = new MySqlCommand(query, conn);
try
{
cmd.ExecuteNonQuery();
}
catch
{
return(false);
}
finally
{
conn.CloseAsync();
}
}
return(true);
}
public MedicalHealthFacility Handle(int facitityId)
{
List <MedicalHealthFacility> list = new List <MedicalHealthFacility>();
using (MySqlConnection conn = _context.GetConnection())
{
conn.Open();
string query = "select * from Health_Facilities where faculty_id=" + facitityId.ToString();
MySqlCommand cmd = new MySqlCommand(query, conn);
try
{
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,
});
}
}
}
catch
{
return(null);
}
finally
{
conn.CloseAsync();
}
}
return(list[0]);
}