/// <summary>
/// Load all speciality by hospital code
/// </summary>
/// <returns>List[SpecialityEntity] that contains a list of speciality</returns>
public static async Task <List <Speciality> > LoadSpecialityByHospitalIDAsync(int HospitalID)
{
List <SP_LOAD_SPECIALITY_BY_HOSPITALIDResult> result = null;
// Take specalities in a specific hospital in database
using (LinqDBDataContext data = new LinqDBDataContext())
{
result = await Task.Run(() =>
data.SP_LOAD_SPECIALITY_BY_HOSPITALID(HospitalID).ToList());
}
List <Speciality> specialityList = new List <Speciality>();
Speciality speciality = null;
// Assign values for each speciality
foreach (SP_LOAD_SPECIALITY_BY_HOSPITALIDResult re in result)
{
if (re.Speciality_ID != 1)
{
speciality = new Speciality();
speciality.Speciality_ID = re.Speciality_ID;
speciality.Speciality_Name = re.Speciality_Name;
specialityList.Add(speciality);
}
}
// Return list of speciality
return(specialityList);
}
public static List <Speciality> LoadSpecialitiesByHospitalId(int id)
{
List <Speciality> sepcilities = null;
using (LinqDBDataContext data = new LinqDBDataContext())
{
sepcilities = (from s in data.SP_LOAD_SPECIALITY_BY_HOSPITALID(id)
select new Speciality()
{
Speciality_ID = s.Speciality_ID,
Speciality_Name = s.Speciality_Name
}).ToList <Speciality>();
}
return(sepcilities);
}
