public Institution GetByUserName(string userName) { if (String.IsNullOrWhiteSpace(userName)) throw new ArgumentNullException("userName"); InstitutionFilter filter = new InstitutionFilter(); filter.UserName = userName; InstitutionRepository repository = new InstitutionRepository(); return repository.Select(filter).SingleOrDefault(); }
public List<Institution> Select(InstitutionFilter filter) { if (filter == null) return null; List<Institution> list = null; using (var db = new DozpContext()) { list = (from i in db.Institutions.Include(e => e.Catalogues) where (0 == filter.InstitutionID || i.InstitutionID == filter.InstitutionID) && (String.IsNullOrEmpty(filter.UserName) || i.Users.Count(r => r.UserName == filter.UserName) > 0) && (!filter.Active || i.Enabled == true) select i).ToList(); } return list; }