Пример #1
0
        public virtual Models.IndicatorDetails GetIndicatorDetails(int id)
        {
            var query = new Queries.IndicatorQuery();

            query.IdIs = id;

            using (DbConnection db = this.GetDbConnection()) {
                var repository = new Repositories.IndicatorDetailsRepository(
                    db,
                    new Queries.ISqlQuery[] { query });
                return((Models.IndicatorDetails)repository.Single());
            }
        }
Пример #2
0
        public virtual IEnumerable <Models.IndicatorBrief> GetIndicators(
            string name     = null,
            int?accessRight = null)
        {
            var query = new Queries.IndicatorQuery();

            query.NameLike = '%' + name + '%';

            if (accessRight != null)
            {
                query.AccessRightIdIs = accessRight;
            }

            using (DbConnection db = this.GetDbConnection()) {
                var repository = new Repositories.IndicatorBriefRepository(
                    db, new Queries.ISqlQuery[] { query });
                foreach (Models.IndicatorBrief r in repository.FindAll())
                {
                    yield return(r);
                }
            }
        }