public override void OnBeginIndex() { ViewBag.Personas = personaService.GetAll().Count(); ViewBag.Usuarios = usuarioService.GetAll().Count(); ViewBag.Agendas = agendaService.GetAll().Count(); ViewBag.Medicamentos = medicamentoService.GetAll().Count(); ViewBag.CitasAnteriorAnual = EntityService.GetAll().Where(x => x.AppointmentDate.Year == (DateTime.Now.Year - 1)).Count(); ViewBag.CitasActualesAnual = EntityService.GetAll().Where(x => x.AppointmentDate.Year == DateTime.Now.Year).Count(); ViewBag.CitasMesAnterior = EntityService.GetAll().Where(x => x.AppointmentDate.Month == (DateTime.Now.Month - 1) && x.AppointmentDate.Year == DateTime.Now.Year).Count(); ViewBag.CitasMesActual = EntityService.GetAll().Where(x => x.AppointmentDate.Month == DateTime.Now.Month && x.AppointmentDate.Year == DateTime.Now.Year).Count(); ViewBag.CitasAnteriorDias = EntityService.GetAll().Where(x => x.AppointmentDate.Day == (DateTime.Now.Day - 1) && x.AppointmentDate.Month == DateTime.Now.Month && x.AppointmentDate.Year == DateTime.Now.Year).Count(); ViewBag.CitasActualesDias = EntityService.GetAll().Where(x => x.AppointmentDate.Day == DateTime.Now.Day && x.AppointmentDate.Month == DateTime.Now.Month && x.AppointmentDate.Year == DateTime.Now.Year).Count(); }