public IQueryable <CampaignAssignedAgents> GetAssignedAgentsInfo(int campaignId, int identifier) { var agents = _db.Users.Select(x => x.UserName); var model = new List <CampaignAssignedAgents>(); var count = 0; foreach (var agent in agents) { switch (identifier) { case 1: count = _db.AcquireEmails.Count(e => e.AssignedTo == agent && e.RelatedCampaignId == campaignId); break; case 2: count = _db.Educations.Count(e => e.AssignedTo == agent && e.RelatedCampaignId == campaignId); break; case 3: count = _db.Opportunities.Count(e => e.AssignedTo == agent && e.RelatedCampaignId == campaignId); break; } var temp = new CampaignAssignedAgents() { Agent = agent, NumberOfAssignedEntities = count }; model.Add(temp); } return(model.AsQueryable()); }
public IQueryable <CampaignAssignedAgents> GetAssignedAgentsInfo(int campaignId) { var agents = _db.Users.Select(x => x.UserName); var model = new List <CampaignAssignedAgents>(); foreach (var agent in agents) { var temp = new CampaignAssignedAgents() { Agent = agent, NumberOfAssignedEntities = _db.AcquireEmails.Count(e => e.AssignedTo == agent && e.RelatedCampaignId == campaignId) }; model.Add(temp); } return(model.AsQueryable()); }