Пример #1
0
        //public IEnumerable<Contact> GetContacts()
        //{
        //    return context.Contacts.ToList();
        //}

        public IEnumerable <Contact> GetContacts(ContactCriteria criteria)
        {
            IQueryable <Contact> query = context.Contacts;

            if (criteria.AgentId > 0)
            {
                query = query.Where(contact => contact.AgentId == criteria.AgentId);
            }

            query = query.OrderByDescending(contact => contact.LastName);

            return(query.ToList());
        }
Пример #2
0
        public IList <Contact> ContactPaging(Pagination pageInfo, ContactCriteria criteria)
        {
            Expression <Func <Contact, bool> > condition = t => true;

            if (null != criteria)
            {
                if (!String.IsNullOrEmpty(criteria.Keyword))
                {
                    condition = condition.And(c => c.Name.Contains(criteria.Keyword) || c.Mobile.Contains(criteria.Keyword));
                }
                if (criteria.Id > 0)
                {
                    condition = condition.And(c => c.ContactId.Equals(criteria.Id));
                }
            }

            var result = this.GetPage(pageInfo, condition, p => p.CreateTime).ToList();

            return(result);
        }
Пример #3
0
 public IList <Contact> ContactPaging(Pagination pageInfo, ContactCriteria criteria)
 {
     return(this.contactRepository.ContactPaging(pageInfo, criteria));
 }