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