Example #1
0
        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);
        }