/// <summary>
///
/// </summary>
/// <param name="stateID"></param>
/// <returns></returns>
public List<City> GetCitiesByStateID(long stateID)
{
List<City> cities = new List<City>();
QuironContext context = new QuironContext();
cities = context.Cities.Where(x => x.StateID == stateID).ToList();
return cities;
}
public List<State> GetStatesByCountryID(long countryID)
{
List<State> states = new List<State>();
QuironContext context = new QuironContext();
states = context.States.Where(x => x.CountryID == countryID).ToList();
return states;
}
/// <summary>
///
/// </summary>
/// <param name="typeID"></param>
/// <returns></returns>
public List<MedicalCentre> GetCentresByType(long typeID)
{
QuironContext context = new QuironContext();
return context.MedicalCentres.Where(x => x.MedicalCentreTypeID == typeID).ToList();
}
/// <summary>
///
/// </summary>
/// <param name="cityID"></param>
/// <returns></returns>
public List<MedicalCentre> GetCentresByCity(long cityID)
{
QuironContext context = new QuironContext();
return context.MedicalCentres.Where(x => x.CityID == cityID).ToList();
}
/// <summary>
///
/// </summary>
/// <param name="centreID"></param>
/// <returns></returns>
public List<ConsultingRoom> GetByMedicalCentre(long centreID)
{
QuironContext context = new QuironContext();
return context.ConsultingRooms.Where(x => x.MedicalCentreID == centreID).ToList();
}