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();
}
