/* * public DataResponse<EntityList<EntitySelectItem>> GetProvidersByServiceId(int serviceId, int? currentBusinessId) * { * var response = new DataResponse<EntityList<EntitySelectItem>>(); * try * { * base.DBInit(); * * var query = DBEntity.ReportMasters.Where(a => a.ServiceId == serviceId && a.BusinessId == currentBusinessId) * .Select(s => new EntitySelectItem * { * Id = s.Provider.Id, * Value = s.Provider.FirstName + " " + s.Provider.MiddleName + " " + s.Provider.LastName + " (" + s.Provider.NPI + ")" * }).OrderBy(o => o.Value).DistinctBy(a => a.Id); * * response = GetList(query, 0, 100); * } * catch (Exception ex) * { * ex.Log(); * } * finally * { * base.DBClose(); * } * return response; * } */ public DataResponse <EntityList <EntitySelectItem> > GetAllTaskTypes(int?currentBusinessId) { var response = new DataResponse <EntityList <EntitySelectItem> >(); try { var cachedResponse = response.GetCached <EntityList <EntitySelectItem> >(CacheKeys.TaskType + currentBusinessId); if (cachedResponse.IsOk()) { return(cachedResponse); } base.DBInit(); var query = DBEntity.LookupTaskTypes.Where(a => a.BusinessId == currentBusinessId).Select(s => new EntitySelectItem { Id = s.Id, Value = s.TaskType }).OrderBy(o => o.Value); response = GetList <EntitySelectItem>(query, 0, 100); response.CacheIt <EntityList <EntitySelectItem> >(CacheKeys.TaskType + currentBusinessId); } catch (Exception ex) { ex.Log(); } finally { base.DBClose(); } return(response); }
public DataResponse <EntityList <EntitySelectItem> > GetPracticeTypes() { var response = new DataResponse <EntityList <EntitySelectItem> >(); try { var cachedData = response.GetCached <EntityList <EntitySelectItem> >(CacheKeys.PracticeTypes); if (cachedData.IsOk()) { return(cachedData); } base.DBInit(); var query = DBEntity.LookupPracticeTypes.Where(s => s.IsActive == true).Select(s => new EntitySelectItem { Id = s.Id, Value = s.PracticeType }).OrderBy(o => o.Value); response = GetList <EntitySelectItem>(query, 0, 100); if (response.IsOk()) { response.CacheIt <EntityList <EntitySelectItem> >(CacheKeys.PracticeTypes); } } catch (Exception ex) { ex.Log(); } finally { base.DBClose(); } return(response); }