public static List <HeatMapItem> GetHeatMap(string supervisorId)
{
List <HeatMapItem> items = new List <HeatMapItem>();
List <KPIInfo> kpis = KPIReader.GetKPI();
List <AgentKPIInfo> agentKpis = KPIReader.GetAgentKPI();
List <AgentInfo> agents = AgentReader.GetAgentsForSupervisor(supervisorId);
var result = from k in kpis
join ak in agentKpis on k.KpiId equals ak.KpiId
join a in agents on ak.AgentId equals a.AgentId
orderby a.AgentName, k.KpiName
select new { a.AgentId, a.AgentName, k.KpiId, k.KpiName, ak.KpiValue };
foreach (var row in result)
{
items.Add(new HeatMapItem()
{
AgentId = row.AgentId,
AgentName = row.AgentName,
KpiId = row.KpiId,
KpiName = row.KpiName,
KpiScore = row.KpiValue
});
}
return(items);
}
public static CenterViewResponse GetCenterView(string centerId)
{
List <KPIItem> centerView = new List <KPIItem>();
List <AgentKPIInfo> allKPIs = KPIReader.GetAgentKPI();
List <KPIInfo> kpiNames = KPIReader.GetAllKPIInfo();
List <SupervisorInfo> supervisors = AgentReader.GetSupervisorsForCenter(centerId);
foreach (var supervisor in supervisors)
{
List <KPIItem> supervisorKPI = GetSupervisorView(supervisor.SupervisorId).SupervisorView;
if (supervisorKPI.Count > 0)
{
List <AgentInfo> agents = AgentReader.GetAgentsForSupervisor(supervisor.SupervisorId);
var agentKPIs = from allK in allKPIs
join a in agents on allK.AgentId equals a.AgentId
group allK by allK.KpiId into g
select new { KpiId = g.First().KpiId, KpiTotal = g.Average(a => a.KpiValue) };
string topKpiString = string.Empty;
string bottomKpiString = string.Empty;
var topKPI = agentKPIs.OrderByDescending(a => a.KpiTotal).Take(2);
foreach (var row in topKPI)
{
string kpiName = kpiNames.Where(k => k.KpiId.Equals(row.KpiId)).FirstOrDefault().KpiName;
topKpiString += string.Format("{0}: {1};", kpiName, row.KpiTotal);
}
var bottomKPI = agentKPIs.OrderBy(a => a.KpiTotal).Take(2);
foreach (var row in bottomKPI)
{
string kpiName = kpiNames.Where(k => k.KpiId.Equals(row.KpiId)).FirstOrDefault().KpiName;
bottomKpiString += string.Format("{0}: {1};", kpiName, row.KpiTotal);
}
double avgScore = supervisorKPI.Average(a => a.Score);
centerView.Add(new KPIItem()
{
AgentId = supervisor.SupervisorId,
AgentName = supervisor.SupervisorName,
Score = Convert.ToInt32(avgScore),
TopKPI = topKpiString,
BottomKPI = bottomKpiString
});
}
}
return(new CenterViewResponse()
{
CenterName = AgentReader.GetCenterName(centerId),
CenterView = centerView
});
}
public static SupervisorViewResponse GetSupervisorView(string supervisorId)
{
List <KPIItem> supervisorView = new List <KPIItem>();
List <KPIInfo> kpis = KPIReader.GetKPIInfo();
List <AgentKPIInfo> agentKpis = KPIReader.GetAgentKPI();
List <AgentInfo> agents = AgentReader.GetAgentsForSupervisor(supervisorId);
var result = from k in kpis
join ak in agentKpis on k.KpiId equals ak.KpiId
join a in agents on ak.AgentId equals a.AgentId
orderby a.AgentName, ak.KpiValue ascending
select new { a.AgentName, k.KpiName, ak.KpiValue };
var agentGroups = result.GroupBy(a => a.AgentName).Select(g => g.FirstOrDefault());
foreach (var agentGroup in agentGroups)
{
var agentRows = result.Where(a => a.AgentName.Equals(agentGroup.AgentName));
double avgKpi = agentRows.Average(a => a.KpiValue);
string topKpiString = string.Empty;
string bottomKpiString = string.Empty;
var topKPI = agentRows.OrderByDescending(a => a.KpiValue).Take(2);
foreach (var row in topKPI)
{
topKpiString += string.Format("{0}: {1};", row.KpiName, row.KpiValue);
}
var bottomKPI = agentRows.OrderBy(a => a.KpiValue).Take(2);
foreach (var row in bottomKPI)
{
bottomKpiString += string.Format("{0}: {1};", row.KpiName, row.KpiValue);
}
supervisorView.Add(new KPIItem()
{
AgentName = agentGroup.AgentName,
Score = Convert.ToInt32(avgKpi),
TopKPI = topKpiString,
BottomKPI = bottomKpiString
});
}
return(new SupervisorViewResponse()
{
SupervisorName = AgentReader.GetSupervisorName(supervisorId),
SupervisorView = supervisorView.OrderByDescending(i => i.Score).ToList()
});
}
public static AgentViewResponse GetAgentView(string agentId)
{
List <AgentKPIScore> agentView = new List <AgentKPIScore>();
List <KPIInfo> kpis = KPIReader.GetKPIInfo();
List <AgentKPIInfo> agentKpis = KPIReader.GetAgentKPI();
AgentInfo agentInfo = AgentReader.GetAgentInfo(agentId);
var result = from k in kpis
join ak in agentKpis on k.KpiId equals ak.KpiId
where ak.AgentId == agentId
orderby k.KpiName
select new { k.KpiId, k.KpiName, ak.Date, ak.KpiValue, ak.HadTraining, ak.IsAwarded, ak.Description };
var kpiGroups = result.GroupBy(k => k.KpiName).Select(g => g.FirstOrDefault());
foreach (var kpiGroup in kpiGroups)
{
var kpiRows = result.Where(k => k.KpiName.Equals(kpiGroup.KpiName));
List <KPIScoreInfo> scoreList = new List <KPIScoreInfo>();
foreach (var row in kpiRows)
{
var dateRows = kpiRows.Where(k => Convert.ToDateTime(k.Date) <= row.Date);
double centerAverage = dateRows.Average(k => k.KpiValue);
scoreList.Add(new KPIScoreInfo()
{
Date = row.Date,
Score = row.KpiValue.ToString(),
CenterAverage = centerAverage.ToString("F"),
HadTraining = row.HadTraining,
IsAwarded = row.IsAwarded,
Description = row.Description
});
}
agentView.Add(new AgentKPIScore()
{
KPIName = kpiGroup.KpiName,
ScoreDetails = scoreList
});
}
return(new AgentViewResponse()
{
AgentName = AgentReader.GetAgentInfo(agentId).AgentName,
AgentView = agentView
});
}
public static List <AgentKPIScore> GetAgentDashboard(string agentId)
{
List <AgentKPIScore> items = new List <AgentKPIScore>();
List <KPIInfo> kpis = KPIReader.GetKPI();
List <AgentKPIInfo> agentKpis = KPIReader.GetAgentKPI();
AgentInfo agentInfo = AgentReader.GetAgentInfo(agentId);
var result = from k in kpis
join ak in agentKpis on k.KpiId equals ak.KpiId
where ak.AgentId == agentId
orderby k.KpiName
select new { k.KpiId, k.KpiName, ak.Date, ak.KpiValue, ak.HadTraining, ak.IsAwarded, ak.Description };
var kpiGroups = result.GroupBy(k => k.KpiName).Select(g => g.FirstOrDefault());
foreach (var kpiGroup in kpiGroups)
{
var kpiRows = result.Where(k => k.KpiName.Equals(kpiGroup.KpiName));
List <KPIScoreInfo> scoreList = new List <KPIScoreInfo>();
foreach (var row in kpiRows)
{
scoreList.Add(new KPIScoreInfo()
{
Date = row.Date,
Score = row.KpiValue.ToString(),
HadTraining = row.HadTraining,
IsAwarded = row.IsAwarded,
Description = row.Description
});
}
items.Add(new AgentKPIScore()
{
KPIName = kpiGroup.KpiName,
ScoreDetails = scoreList
});
}
return(items);
}
public static HeatMapViewResponse GetHeatMapView(string supervisorId)
{
var heatMapItems = new List <Dictionary <string, string> >();
List <KPIInfo> kpis = KPIReader.GetAllKPIInfo();
List <AgentKPIInfo> agentKpis = KPIReader.GetAgentKPI();
List <AgentInfo> agents = AgentReader.GetAgentsForSupervisor(supervisorId);
string centerId = AgentReader.GetCenterIdForSupervisor(supervisorId);
List <AgentInfo> centerAgents = AgentReader.GetAgentsForCenter(centerId);
var result = from k in kpis
join ak in agentKpis on k.KpiId equals ak.KpiId
join a in agents on ak.AgentId equals a.AgentId
orderby k.Category, k.KpiId, a.AgentName
select new { a.AgentId, a.AgentName, a.Date, k.KpiId, k.KpiName, ak.KpiValue, k.Category };
var kpiGroups = result.GroupBy(a => a.KpiName).Select(g => g.FirstOrDefault());
foreach (var kpiGroup in kpiGroups)
{
var kpiRows = from a in result
where a.KpiName.Equals(kpiGroup.KpiName)
group a by a.AgentName into g
select g.OrderByDescending(i => i.Date).FirstOrDefault();
var item = new Dictionary <string, string>();
item.Add("..Category", kpiGroup.Category);
item.Add(".Behavior Attribute", kpiGroup.KpiName);
var centerResult = from ak in agentKpis
join ca in centerAgents on ak.AgentId equals ca.AgentId
where ak.KpiId == kpiGroup.KpiId
group ak by ak.KpiId into g
select new { CenterAverage = g.Average(a => a.KpiValue) };
var sdResult = from ak in agentKpis
join ca in centerAgents on ak.AgentId equals ca.AgentId
where ak.KpiId == kpiGroup.KpiId
select new { ak.KpiValue };
List <double> sdList = new List <double>();
foreach (var row in sdResult)
{
sdList.Add(row.KpiValue);
}
double centerAverage = Convert.ToInt32(centerResult.First().CenterAverage);
item.Add(".Center Average", centerAverage.ToString("F"));
double standardDeviation = StatisticsHelper.GetStandardDeviation(sdList);
item.Add(".Standard Deviation", standardDeviation.ToString("F"));
foreach (var row in kpiRows)
{
item.Add(row.AgentName, row.KpiValue.ToString("F"));
}
heatMapItems.Add(item);
}
return(new HeatMapViewResponse()
{
SupervisorName = AgentReader.GetSupervisorName(supervisorId),
HeatMapView = heatMapItems
});
}