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