Пример #1
0
 public async Task <IEnumerable <Company> > GetAllCompanies()
 {
     using (var db = new ContactListWebAppContext())
     {
         return(await db.Companies.ToListAsync());
     }
 }
 public async Task <IEnumerable <Job> > GetAllJobs()
 {
     using (var db = new ContactListWebAppContext())
     {
         return(await db.Jobs.ToListAsync());
     }
 }
        public async Task UpdateContact(Contact contact)
        {
            if (contact == null)
            {
                throw new ArgumentException("Contact instance is not initiallized");
            }


            using (var db = new ContactListWebAppContext())
            {
                var contactInDb = db.Contacts.FirstOrDefault(x => x.Id == contact.Id);

                if (contactInDb == null)
                {
                    throw new InvalidOperationException($"There was no contact with this id: {contact.Id}");
                }

                contactInDb.Avatar    = contact.Avatar;
                contactInDb.Company   = contact.Company;
                contactInDb.Email     = contact.Email;
                contactInDb.FirstName = contact.FirstName;
                contactInDb.Gender    = contact.Gender;
                contactInDb.Job       = contact.Job;
                contactInDb.LastName  = contact.LastName;
                contactInDb.Phone     = contact.Phone;
                contactInDb.CompanyId = contact.CompanyId;
                contactInDb.JobId     = contact.JobId;

                await db.SaveChangesAsync();
            }
        }
 private IQueryable <Contact> GetFilteredContactsQuery(ContactListWebAppContext db, FilterDto filter)
 {
     return(db.Contacts.Where(
                x => (string.IsNullOrEmpty(filter.Gender) || x.Gender.ToUpper() == filter.Gender.ToUpper())
                &&
                (string.IsNullOrEmpty(filter.FirstName) ||
                 x.FirstName.ToUpper().Contains(filter.FirstName.ToUpper()))
                &&
                (string.IsNullOrEmpty(filter.LastName) ||
                 x.LastName.ToUpper().Contains(filter.LastName.ToUpper())))
            .Include(x => x.Company)
            .Include(x => x.Job));
 }
        public async Task <int> GetNumberOfFilteredContacts(FilterDto filter)
        {
            using (var db = new ContactListWebAppContext())
            {
                Task <int> task;
                if (filter == null)
                {
                    task = new Task <int>(() => db.Contacts.Count());
                }

                task = new Task <int>(() => GetFilteredContactsQuery(db, filter).OrderBy(x => x.Id).Count());
                task.Start();
                return(await task);
            }
        }
        public async Task DeleteContact(int id)
        {
            using (var db = new ContactListWebAppContext())
            {
                var contactInDb = db.Contacts.FirstOrDefault(x => x.Id == id);

                if (contactInDb == null)
                {
                    throw new InvalidOperationException($"There was no contact with this id: {id}");
                }

                db.Contacts.Remove(contactInDb);
                await db.SaveChangesAsync();
            }
        }
        public async Task <int> AddContact(Contact contact)
        {
            if (contact == null)
            {
                throw new ArgumentException("Contact instance is not initiallized");
            }

            using (var db = new ContactListWebAppContext())
            {
                db.Contacts.Add(contact);
                await db.SaveChangesAsync();

                return(--contact.Id);
            }
        }
        public async Task <IEnumerable <Contact> > GetFilteredContacts(FilterDto filter)
        {
            using (var db = new ContactListWebAppContext())
            {
                if (filter == null)
                {
                    return(await db.Contacts.ToListAsync());
                }

                return(await GetFilteredContactsQuery(db, filter)
                       .OrderBy(x => x.Id)
                       .Skip((filter.PageNumber - 1) * filter.PageSize)
                       .Take(filter.PageSize)
                       .ToListAsync());
            }
        }