private Models.Evaluations.Chart.Chart GetMultiLineChartData()
{
Models.Evaluations.Chart.Chart _chart = new Models.Evaluations.Chart.Chart();
_chart.labels = new string[] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "Novemeber", "December" };
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_dataSet.Add(new Datasets()
{
label = "Current Year",
data = new int[] { 28, 48, 40, 19, 86, 27, 90, 20, 45, 65, 34, 22 },
borderColor = new string[] { "rgba(75,192,192,1)" },
backgroundColor = new string[] { "rgba(75,192,192,0.4)" },
borderWidth = "1"
});
_dataSet.Add(new Datasets()
{
label = "Last Year",
data = new int[] { 65, 59, 80, 81, 56, 55, 40, 55, 66, 77, 88, 34 },
borderColor = new string[] { "rgba(75,192,192,1)" },
backgroundColor = new string[] { "rgba(75,192,192,0.4)" },
borderWidth = "1"
});
_chart.datasets = _dataSet;
return(_chart);
}
public static Models.Evaluations.Chart.Chart GetInterviewsChartData(DateRange period, int stageID = default(int))
{
using (var dbContext = new AARPDbContext())
{
var standingsResult = (from interview in dbContext.Interviews
join ratings in dbContext.InterviewRatings on interview.RatingId equals ratings.Id
where interview.Date >= period.dateFrom && interview.Date <= period.dateTo &&
(stageID > 0 ? interview.InterviewStageId == stageID : true)
select new
{
interview.Id,
interview.RatingId,
ratings.Rating,
}).Where(x => x.RatingId != 0).ToList();
Models.Evaluations.Chart.Chart _chart = new Models.Evaluations.Chart.Chart();
_chart.labels = standingsResult.Select(x => x.Rating.ToString()).ToArray();
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_dataSet.Add(new Datasets()
{
label = "Ratings",
data = standingsResult.Select(x => x.RatingId).ToArray(),
backgroundColor = new string[] { "#9068be", "#e62739", "#3fb0ac", "ba9077", "6534ff" },
// borderColor = new string[] { "#FF0000", "#800000", "#808000"},
borderWidth = "1"
});
_chart.datasets = _dataSet;
return(_chart);
}
}
private Models.Evaluations.Chart.Chart GetLineChartData()
{
Models.Evaluations.Chart.Chart _chart = new Models.Evaluations.Chart.Chart();
_chart.labels = new string[] { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "Novemeber", "December" };
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_dataSet.Add(new Datasets()
{
label = "Current Year",
data = new int[] { 28, 48, 40, 19, 86, 27, 90, 20, 45, 65, 34, 22 },
borderColor = new string[] { "#800080" },
borderWidth = "1"
});
_chart.datasets = _dataSet;
return(_chart);
}
public static Models.Evaluations.Chart.Chart GetLengthChartData(DateRange period, int interviewerID = default(int))
{
List <StatsLengthViewModel> OverallLengths = new List <StatsLengthViewModel>();
using (var dbContext = new AARPDbContext())
{
var standingsResult = (from interview in dbContext.Interviews
join length in dbContext.InterviewLengths on interview.InterviewLengthId equals length.Id
where interview.Date >= period.dateFrom && interview.Date <= period.dateTo &&
(interviewerID > 0 ? interview.Id == interviewerID : true)
select new
{
interview.InterviewLengthId,
interview.Id,
length.Length,
}).Where(x => x.InterviewLengthId != 0).ToList();
var groupedLenghts = standingsResult.GroupBy(x => x.Length).ToList();
foreach (var item in groupedLenghts)
{
OverallLengths.Add(new StatsLengthViewModel()
{
Length = item.Key.Trim(), Percent = item.Count()
});
}
}
Models.Evaluations.Chart.Chart _chart = new Models.Evaluations.Chart.Chart();
_chart.labels = OverallLengths.Select(x => x.Length.ToString()).ToArray();
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_dataSet.Add(new Datasets()
{
label = "Length",
data = OverallLengths.Select(x => (int)Math.Round(x.Percent)).ToArray(),
backgroundColor = new string[] { "#9068be", "#e62739", "#3fb0ac", "ba9077", "6534ff" },
// borderColor = new string[] { "#FF0000", "#800000", "#808000"},
borderWidth = "1"
});
_chart.datasets = _dataSet;
return(_chart);
}
public static Models.Evaluations.Chart.Chart GetRatingChartData(DateRange period, int interviewerID = default(int))
{
List <StandingsInterviewRatingViewModel> OverallRatings = new List <StandingsInterviewRatingViewModel>();
using (var dbContext = new AARPDbContext())
{
var standingsResult = (from interview in dbContext.Interviews
join ratings in dbContext.InterviewRatings on interview.RatingId equals ratings.Id
where interview.Date >= period.dateFrom && interview.Date <= period.dateTo &&
(interviewerID > 0 ? interview.Id == interviewerID : true)
select new
{
interview.Id,
interview.RatingId,
ratings.Rating,
}).Where(x => x.RatingId != 0).ToList();
var test = standingsResult.GroupBy(x => x.RatingId).ToList();
foreach (var item in test)
{
OverallRatings.Add(new StandingsInterviewRatingViewModel()
{
Rating = item.Key, RatingCount = item.Count()
});
}
}
Models.Evaluations.Chart.Chart _chart = new Models.Evaluations.Chart.Chart();
_chart.labels = OverallRatings.Select(x => x.Rating.ToString()).ToArray();
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_dataSet.Add(new Datasets()
{
label = "Ratings",
data = OverallRatings.Select(x => x.RatingCount).ToArray(),
backgroundColor = new string[] { "#9068be", "#e62739", "#3fb0ac", "ba9077", "6534ff" },
// borderColor = new string[] { "#FF0000", "#800000", "#808000"},
borderWidth = "1"
});
_chart.datasets = _dataSet;
return(_chart);
}
public static Models.Evaluations.Chart.Chart GetStatsHeaderBarChartData(DateRange period)
{
StandingsAttitudeViewModel attitude = new StandingsAttitudeViewModel();
using (var dbContext = new AARPDbContext())
{
var standingsResult = (from interview in dbContext.Interviews
where interview.Date >= period.dateFrom && interview.Date <= period.dateTo
select new
{
interview.Id,
interview.InterviewerAttitude,
}).Where(x => x.InterviewerAttitude != null).ToList();
if (standingsResult.Count > 0)
{
attitude.Positive = ((double)standingsResult.Count(x => x.InterviewerAttitude.Trim() == DbConstants.AttitudePositive) / (double)standingsResult.Count()) * 100;
attitude.Neutral = ((double)standingsResult.Count(x => x.InterviewerAttitude.Trim() == DbConstants.AttitudeNeutral) / (double)standingsResult.Count()) * 100;
attitude.Negative = ((double)standingsResult.Count(x => x.InterviewerAttitude.Trim() == DbConstants.AttitudeNegative) / (double)standingsResult.Count()) * 100;
}
else
{
attitude.Positive = attitude.Neutral = attitude.Negative = 0;
}
}
if (attitude != null)
{
Models.Evaluations.Chart.Chart _chart = new Models.Evaluations.Chart.Chart();
_chart.labels = new string[] { ((int)attitude.Positive).ToString(), ((int)attitude.Neutral).ToString(), ((int)attitude.Negative).ToString() };
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_dataSet.Add(new Datasets()
{
label = "",
data = new int[] { (int)attitude.Positive, (int)attitude.Neutral, (int)attitude.Negative },
backgroundColor = new string[] { "#9068be", "#e62739", "#3fb0ac", "ba9077", "6534ff" },
//borderColor = new string[] { "green", "grey", "red" },
borderWidth = "1"
});
_chart.datasets = _dataSet;
return(_chart);
}
else
{
Models.Evaluations.Chart.Chart _chart = new Models.Evaluations.Chart.Chart();
_chart.labels = new string[] { "0", "0", "0" };
_chart.datasets = new List <Datasets>();
List <Datasets> _dataSet = new List <Datasets>();
_dataSet.Add(new Datasets()
{
label = "",
data = new int[] { 0, 0, 0 },
backgroundColor = new string[] { "#9068be", "#e62739", "#3fb0ac", "ba9077", "6534ff" },
//borderColor = new string[] { "green", "grey", "red" },
borderWidth = "1"
});
_chart.datasets = _dataSet;
return(_chart);
}
}
