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);
        }
示例#2
0
        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
            });
        }
示例#3
0
        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()
            });
        }
示例#4
0
        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);
        }
示例#6
0
        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
            });
        }