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." })); } }