/// <summary> /// Load list of facility base on input conditions /// </summary> /// <param name="facilityName">Facility name</param> /// <param name="facilityType">Facility type</param> /// <param name="isActive">Status</param> /// <returns></returns> public async Task <List <SP_TAKE_FACILITY_AND_TYPEResult> > LoadListOfFacility( string facilityName, int facilityType, bool isActive) { // Search for suitable hospitals in database using (LinqDBDataContext data = new LinqDBDataContext()) { return(await Task.Run(() => data.SP_TAKE_FACILITY_AND_TYPE(facilityName, facilityType, isActive).ToList())); } }
/// <summary> /// Load a list of facilities in database /// </summary> /// <returns>List[Facility] that contains a list of services</returns> public static async Task <IEnumerable <GroupedSelectListItem> > LoadFacilityAsync() { // Return list of dictionary words using (LinqDBDataContext data = new LinqDBDataContext()) { return(await Task.Run(() => (from f in data.SP_TAKE_FACILITY_AND_TYPE(null, 0, true).ToList() select new GroupedSelectListItem { GroupKey = f.Type_ID.ToString(), GroupName = f.Type_Name, Text = f.Facility_Name, Value = f.Facility_ID.ToString() }))); } }