public List <HospitalServices> GetHospitalServices(int hospitalServiceMedicalId)
{
Query = "SELECT Id, ServiceName FROM HospitalServices WHERE MedicalId = @medicalId ORDER BY ServiceName";
Command = new SqlCommand(Query, Connection);
Command.Parameters.AddWithValue("medicalId", hospitalServiceMedicalId);
Connection.Open();
Reader = Command.ExecuteReader();
List <HospitalServices> hospitalServices = new List <HospitalServices>();
while (Reader.Read())
{
HospitalServices hospitalService = new HospitalServices();
hospitalService.Id = Convert.ToInt32(Reader["Id"]);
hospitalService.ServiceName = Reader["ServiceName"].ToString();
hospitalServices.Add(hospitalService);
}
Reader.Close();
Connection.Close();
return(hospitalServices);
}
public HospitalController(IMapper mapper)
{
_hospitalservices = new HospitalServices(mapper);
}
