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