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