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