public ContactListViewModel GetContactListViewModel(string id)
        {
            var contacts = _repo.Query<Contact>().Where(c => c.UserId == id).ToList();
            //var contacts = _repo.Query<Contact>().ToList();
            var deals = _repo.Query<Deal>().Where(d => d.UserId == id).ToList();
            //var deals = _repo.Query<Deal>().ToList();
            var tasks = _repo.Query<UserTask>().Where(t => t.UserId == id).ToList();
            //var tasks = _repo.Query<UserTask>().ToList();
            //var companies = _repo.Query<Company>().ToList();
            var companies = _repo.Query<Company>().Where(co => co.UserId == id).ToList();
            //var interactions = _repo.Query<ContactInteraction>().ToList();
            var interactions = _repo.Query<ContactInteraction>().ToList();

            var contactListViewModel = new ContactListViewModel
            {
                Companies = companies,
                Contacts = contacts,
                Deals = deals,
                Interactions = interactions,
                Tasks = tasks,
            };

            return contactListViewModel;
        }
        public ContactListViewModel GetFilteredContacts(ContactFilterViewModel vm, string userId)
        {
            var contactsDeals = _repo.Query<DealContact>().Where(d => d.Deal.UserId == userId).Where(d => d.DealId == vm.DealId).Select(c => c.Contact).ToList();
            var contactsCompanies = _repo.Query<Contact>().Where(d => d.Company.UserId == userId).Where(c => c.CompanyId == vm.CompanyId).ToList();
            var contactsTasks = _repo.Query<TaskContact>().Where(d => d.UserTask.UserId == userId).Where(t => t.TaskId == vm.TaskId).Select(c => c.Contact).ToList();
            var contactsFiltered = new List<Contact>();

            if (vm.DealId != 0)
            {
                if (vm.CompanyId != 0)
                {
                    if (vm.TaskId != 0)
                    {
                        contactsFiltered = contactsDeals.Intersect(contactsDeals).Intersect(contactsCompanies).Intersect(contactsTasks).ToList();
                    }
                    else
                    {
                        contactsFiltered = contactsDeals.Intersect(contactsDeals).Intersect(contactsCompanies).ToList();
                    }
                }
                else if (vm.TaskId != 0)
                {
                    contactsFiltered = contactsDeals.Intersect(contactsDeals).Intersect(contactsTasks).ToList();
                }
                else
                {
                    contactsFiltered = _repo.Query<DealContact>().Where(d => d.DealId == vm.DealId).Select(c => c.Contact).ToList();
                }
            }
            else if (vm.TaskId != 0)
            {
                if (vm.CompanyId != 0)
                {
                    if (vm.DealId != 0)
                    {
                        contactsFiltered = contactsTasks.Intersect(contactsTasks).Intersect(contactsCompanies).Intersect(contactsDeals).ToList();
                    }
                    else
                    {
                        contactsFiltered = contactsTasks.Intersect(contactsTasks).Intersect(contactsCompanies).ToList();
                    }
                }
                else if (vm.DealId != 0)
                {
                    contactsFiltered = contactsTasks.Intersect(contactsTasks).Intersect(contactsDeals).ToList();
                }
                else
                {
                    contactsFiltered = _repo.Query<TaskContact>().Where(t => t.TaskId == vm.TaskId).Select(c => c.Contact).ToList();
                }
            }
            else if (vm.CompanyId != 0)
            {
                if (vm.TaskId != 0)
                {
                    if (vm.DealId != 0)
                    {
                        contactsFiltered = contactsCompanies.Intersect(contactsCompanies).Intersect(contactsTasks).Intersect(contactsDeals).ToList();
                    }
                    else
                    {
                        contactsFiltered = contactsCompanies.Intersect(contactsCompanies).Intersect(contactsTasks).ToList();
                    }
                }
                else if (vm.DealId != 0)
                {
                    contactsFiltered = contactsCompanies.Intersect(contactsCompanies).Intersect(contactsDeals).ToList();
                }
                else
                {
                    contactsFiltered = _repo.Query<Contact>().Where(c => c.CompanyId == vm.CompanyId).ToList();
                }
            }

            var deals = _repo.Query<Deal>().Where(d => d.UserId == userId).ToList();
            var companies = _repo.Query<Company>().Where(co => co.UserId == userId).ToList();
            var tasks = _repo.Query<UserTask>().Where(t => t.UserId == userId).ToList();
            var interactions = _repo.Query<ContactInteraction>().ToList();

            var contactListViewModel = new ContactListViewModel
            {
                Companies = companies,
                Contacts = contactsFiltered,
                Deals = deals,
                Interactions = interactions,
                Tasks = tasks,
            };

            return contactListViewModel;
        }