public ProtocolReportDisplayItem(ProtocolReportSummary protocol)
{
PracticeName = protocol.PracticeName;
PracticeId = protocol.PracticeId;
AverageDLP = protocol.AverageDLP;
AverageCTDI = protocol.AverageCTDI;
DRL_DLP = protocol.DRL_DLP;
DRL_CTDI = protocol.DRL_CTDI;
VarianceDLP = protocol.VarianceDLP;
VarianceDLPClass = VarianceDLP < 0 ? "Neg" : "Pos";
VarianceCTDI = protocol.VarianceCTDI;
VarianceCTDIClass = VarianceCTDI < 0 ? "Neg" : "Pos";
}
public SummaryDisplayItem(ProtocolReportSummary protocol)
{
Name = protocol.Name;
Id = protocol.Id;
AverageDLP = protocol.AverageDLP;
AverageCTDI = protocol.AverageCTDI;
DRL_DLP = protocol.DRL_DLP;
DRL_CTDI = protocol.DRL_CTDI;
VarianceDLP = protocol.VarianceDLP;
VarianceDLPClass = VarianceDLP < 0 ? "Neg" : "Pos";
VarianceCTDI = protocol.VarianceCTDI;
VarianceCTDIClass = VarianceCTDI < 0 ? "Neg" : "Pos";
}
internal IEnumerable<ProtocolReportSummary> FetchGroupSummary()
{
var protocolsGroupedById = _context.Practice_Protocol.GroupBy(p => p.ProtocolId);
var result = new List<ProtocolReportSummary>();
foreach (var g in protocolsGroupedById) {
var protocol = new ProtocolReportSummary();
protocol.Id = g.Key;
protocol.Name = _context.Protocols.FirstOrDefault(p => p.Id == g.Key).Name;
protocol.AverageDLP = (int)Math.Round(g.Average(p => p.AverageDLP));
protocol.AverageCTDI = (int)Math.Round(g.Average(p => p.AverageCTDI));
var regionId = g.First().RegionId;
var region = _context.Regions.First(r => r.Id == regionId);
protocol.DRL_DLP = region.DRL_DLP;
protocol.DRL_CTDI = region.DRL_CTDI;
result.Add(protocol);
}
return result;
}
internal IEnumerable<ProtocolReportSummary> FetchProtocolSummary(int protocolId)
{
var protocolsGroupedByPracticeName = _context.Practice_Protocol.Where(p => p.ProtocolId == protocolId).GroupBy(p => p.Practice);
var result = new List<ProtocolReportSummary>();
foreach (var g in protocolsGroupedByPracticeName) {
var protocol = new ProtocolReportSummary();
protocol.Name = _context.Protocols.First(p => p.Id == protocolId).Name;
protocol.PracticeName = g.Key.Name;
protocol.PracticeId = _context.Practices.FirstOrDefault(p => p.Name == g.Key.Name).Id;
protocol.AverageDLP = calculateAverageDLP(g);
protocol.AverageCTDI = calculateAverageCTDI(g);
var regionId = g.First().RegionId;
var region = _context.Regions.First(r => r.Id == regionId);
protocol.DRL_DLP = region.DRL_DLP;
protocol.DRL_CTDI = region.DRL_CTDI;
result.Add(protocol);
}
return result;
}
