private DashboardKPI GetOutstandingDisputeCount() { var monthStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var monthEnd = monthStart.AddMonths(1).AddDays(-1); var kpi = new KPISinglePoint <int> { ColumnNumber = 4, Title = "Outstanding Disputes", Type = "single", Data = _context.Disputes.Count(d => d.DecisionId == null && d.DecisionDateTime == null), DataFormat = "G0", DataLabel = "" }; return(kpi); }
private DashboardKPI GetAuditCount() { var monthStart = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var monthEnd = monthStart.AddMonths(1).AddDays(-1); var kpi = new KPISinglePoint <int> { ColumnNumber = 4, Title = "Completed Audits", Type = "single", Data = _context.Audits.Count(a => a.AuditDateTime >= monthStart && a.AuditDateTime <= monthEnd), DataFormat = "G0", DataLabel = "" }; return(kpi); }