public JsonResult LineChart(string date, int shiftId, int skillGroupid, int skillAggregationId) { WFMDBDataContext db = new WFMDBDataContext(); List <tblChart> lstCalls = db.uspWFMGetPredictionAndActualInboundCallForChart(this.TenantID, date, shiftId, skillGroupid, skillAggregationId).ToList(); LineChart line = new LineChart(); List <Dataset> datasets = new List <Dataset>(); Dataset inCallDs = new Dataset(); Dataset inCompletedCallDs = new Dataset(); string lables = ""; int[] dataInCalls = new int[lstCalls.Count]; int[] dataCompleteds = new int[lstCalls.Count]; int index = 0; foreach (var item in lstCalls) { lables += "," + item.dtCreatedCall.ToString("HH:mm"); dataInCalls[index] = item.iCountOfInboundCall; dataCompleteds[index] = item.iCountOfCompletedInCall; index++; } if (!string.IsNullOrEmpty(lables)) { line.labels = lables.Substring(1).Split(','); } inCallDs.data = dataInCalls; inCallDs.fillColor = "rgba(151,187,205,0.2)"; inCallDs.strokeColor = "rgba(151,187,205,1)"; inCallDs.pointColor = "rgba(151,187,205,1)"; inCallDs.pointStrokeColor = "#fff"; inCallDs.label = "実績"; inCompletedCallDs.data = dataCompleteds; inCompletedCallDs.fillColor = "rgba(220,220,220,0.5)"; inCompletedCallDs.strokeColor = "rgba(220,220,220,1)"; inCompletedCallDs.pointColor = "rgba(220,220,220,1)"; inCompletedCallDs.pointStrokeColor = "#fff"; inCompletedCallDs.label = "予測"; datasets.Add(inCallDs); datasets.Add(inCompletedCallDs); line.datasets = datasets; return(this.Json(line, JsonRequestBehavior.AllowGet)); }
public JsonResult LineChart(string date,int shiftId,int skillGroupid,int skillAggregationId) { WFMDBDataContext db = new WFMDBDataContext(); List<tblChart> lstCalls = db.uspWFMGetPredictionAndActualInboundCallForChart(this.TenantID, date, shiftId, skillGroupid, skillAggregationId).ToList(); LineChart line = new LineChart(); List<Dataset> datasets = new List<Dataset>(); Dataset inCallDs = new Dataset(); Dataset inCompletedCallDs = new Dataset(); string lables = ""; int[] dataInCalls = new int[lstCalls.Count]; int[] dataCompleteds = new int[lstCalls.Count]; int index = 0; foreach (var item in lstCalls) { lables += "," + item.dtCreatedCall.ToString("HH:mm"); dataInCalls[index] = item.iCountOfInboundCall; dataCompleteds[index] = item.iCountOfCompletedInCall; index++; } if (!string.IsNullOrEmpty(lables)) line.labels = lables.Substring(1).Split(','); inCallDs.data = dataInCalls; inCallDs.fillColor = "rgba(151,187,205,0.2)"; inCallDs.strokeColor = "rgba(151,187,205,1)"; inCallDs.pointColor = "rgba(151,187,205,1)"; inCallDs.pointStrokeColor = "#fff"; inCallDs.label = "実績"; inCompletedCallDs.data = dataCompleteds; inCompletedCallDs.fillColor = "rgba(220,220,220,0.5)"; inCompletedCallDs.strokeColor = "rgba(220,220,220,1)"; inCompletedCallDs.pointColor = "rgba(220,220,220,1)"; inCompletedCallDs.pointStrokeColor = "#fff"; inCompletedCallDs.label = "予測"; datasets.Add(inCallDs); datasets.Add(inCompletedCallDs); line.datasets = datasets; return this.Json(line, JsonRequestBehavior.AllowGet); }