public string ConsultarDadosDashBoard()
        {
            try
            {
                DashBoardViewModel dbvm = new DashBoardViewModel();

                dbvm.QtdeUsuariosAtivos = _usuarioService.GetQtdUsersActive();
                dbvm.QtdeVagasAtivas    = _vagaService.GetQtdVacanciesActive();
                dbvm.QtdeVeiculosAtivos = _veiculoService.GetQtdVehicleActive();
                dbvm.QteLocacoes        = _locacaoService.GetQtdLocationActive();

                dbvm.QtdeVagasPendentes   = _vagaService.GetVacanciesForApproval().Count();
                dbvm.QtdeEventosPendentes = _eventoService.GetEventsForApproval().Count();

                DateTime dataAtual = DateTime.Today;

                dbvm.ArrMeses           = new string[12];
                dbvm.ArrValoresUsuarios = new int[12];
                dbvm.ArrValoresVagas    = new int[12];
                dbvm.ArrValoresVeiculos = new int[12];
                dbvm.ArrValoresLocacoes = new int[12];

                var m = 0;

                for (var i = 11; i >= 0; i--)
                {
                    string nomeMes = System.Globalization.DateTimeFormatInfo.CurrentInfo.GetMonthName(dataAtual.AddMonths(m).Month);
                    dbvm.ArrMeses[i] = nomeMes + " de " + dataAtual.AddMonths(m).Year;

                    dbvm.ArrValoresUsuarios[i] = _usuarioService.GetQtdUsersActivePerMonth(dataAtual.AddMonths(m).Month, dataAtual.AddMonths(m).Year);
                    dbvm.ArrValoresVagas[i]    = _vagaService.GetQtdVacanciesActivePerMonth(dataAtual.AddMonths(m).Month, dataAtual.AddMonths(m).Year);
                    dbvm.ArrValoresVeiculos[i] = _veiculoService.GetQtdVehicleActivePerMonth(dataAtual.AddMonths(m).Month, dataAtual.AddMonths(m).Year);
                    dbvm.ArrValoresLocacoes[i] = _locacaoService.GetQtdLocationActivePerMonth(dataAtual.AddMonths(m).Month, dataAtual.AddMonths(m).Year);

                    m--;
                }

                return(JsonConvert.SerializeObject(new { code = 200, dashboard = dbvm }));
            }
            catch
            {
                return(JsonConvert.SerializeObject(new { code = 400, message = "Erro ao consultar os dados. Por favor, tente novamente." }));
            }
        }