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