private void gerarListaCompletaDespesa(ref ResumoMensalModel resumoMensal)
        {
            List <ResumoCategoriaMesModel> listaDetalhada = gerarListaDespesa(resumoMensal.sMesAno);

            double dTotal = 0;
            Dictionary <string, double> dcExpense = new Dictionary <string, double>();

            foreach (ResumoCategoriaMesModel exp in listaDetalhada)
            {
                if (!dcExpense.ContainsKey(exp.sCategoryID))
                {
                    dcExpense.Add(exp.sCategoryID, 0);
                }
                dcExpense[exp.sCategoryID] += exp.dValor;
                dTotal += exp.dValor;
            }

            dcExpense = dcExpense.OrderByDescending(d => d.Value).ToDictionary(x => x.Key, x => x.Value);;
            int iTotElementos = dcExpense.Count;

            foreach (var hr in dcExpense)
            {
                HomeResumoCategoriaModel homeResumo = new HomeResumoCategoriaModel();
                homeResumo.sMesAno      = resumoMensal.sMesAno;
                homeResumo.dValor       = hr.Value;
                homeResumo.sCategoriaID = hr.Key;
                homeResumo.sDescricao   = categoryBusiness.Get.FirstOrDefault(c => c.sID == hr.Key).descricao;
                homeResumo.dPercentual  = (hr.Value * 100) / dTotal;
                resumoMensal.lstCategoriaGastos.Add(homeResumo);

                if (string.IsNullOrEmpty(resumoMensal.sLstCategoriaGastos))
                {
                    resumoMensal.sLstCategoriaGastos = homeResumo.sDescricao + "|&" + Math.Round(homeResumo.dPercentual, 2);
                }
                else
                {
                    resumoMensal.sLstCategoriaGastos += "|&" + homeResumo.sDescricao + "|&" + Math.Round(homeResumo.dPercentual, 2);
                }
            }
            resumoMensal.dTotalDespesa = dTotal;
        }
        private HomeModel gerarConteudoHome()
        {
            HomeModel home = new HomeModel();

            home.listaContas = accountBusiness.Get.Where(a => a.sUserID == AuthProvider.UserAntenticated.sID && a.StatusType == StatusType.Ativo).ToList();
            #region ----- Notification ---------------------------------------------------------------------------------------------
            List <Notification> lstNotification = notificationBusiness.Get.Where(n => n.sUserID == AuthProvider.UserAntenticated.sID && n.StatusType == StatusType.Ativo).ToList();
            foreach (Notification not in lstNotification)
            {
                if (not.NotificationType == NotificationType.OcorrenciaUnica)
                {
                    if (!expenseIncomeBusiness.Get.Any(e => e.sNotificationID == not.sID) && not.dData < (DateTime.Now.AddDays(10)))
                    {
                        home.listaNotificacoes.Add(new HomeNotificacaoModel()
                        {
                            sID = not.sID, dData = not.dData, dValorPrevisto = not.dValor, sDescricao = not.sDescricao, sCategoriaDescricao = categoryBusiness.Get.FirstOrDefault(c => c.sID == not.sCategoryID).descricao
                        });
                    }
                }
                else
                {
                    List <HomeNotificacaoModel> lstNotTemp = new List <HomeNotificacaoModel>();
                    // mês anterior
                    DateTime dDataCalculo = OperacaoData.retornoDataTimeValido(DateTime.Now.AddMonths(-1).Year, DateTime.Now.AddMonths(-1).Month, not.dData.Day);
                    if (dDataCalculo < (DateTime.Now.AddDays(10)) && !expenseIncomeBusiness.Get.Any(e => e.sNotificationID == not.sID && e.dDataBase.Month == dDataCalculo.Month))
                    {
                        lstNotTemp.Add(new HomeNotificacaoModel()
                        {
                            sID = not.sID, dData = dDataCalculo, dValorPrevisto = not.dValor, sDescricao = not.sDescricao, sCategoriaDescricao = categoryBusiness.Get.FirstOrDefault(c => c.sID == not.sCategoryID).descricao
                        });
                    }
                    // mês atual
                    dDataCalculo = OperacaoData.retornoDataTimeValido(DateTime.Now.Year, DateTime.Now.Month, not.dData.Day);
                    if (dDataCalculo < (DateTime.Now.AddDays(10)) && !expenseIncomeBusiness.Get.Any(e => e.sNotificationID == not.sID && e.dDataBase.Month == dDataCalculo.Month))
                    {
                        lstNotTemp.Add(new HomeNotificacaoModel()
                        {
                            sID = not.sID, dData = dDataCalculo, dValorPrevisto = not.dValor, sDescricao = not.sDescricao, sCategoriaDescricao = categoryBusiness.Get.FirstOrDefault(c => c.sID == not.sCategoryID).descricao
                        });
                    }
                    // verifica próximo mês
                    dDataCalculo = OperacaoData.retornoDataTimeValido(DateTime.Now.AddMonths(1).Year, DateTime.Now.AddMonths(1).Month, not.dData.Day);
                    if (dDataCalculo < (DateTime.Now.AddDays(10)) && !expenseIncomeBusiness.Get.Any(e => e.sNotificationID == not.sID && e.dDataBase.Month == dDataCalculo.Month))
                    {
                        lstNotTemp.Add(new HomeNotificacaoModel()
                        {
                            sID = not.sID, dData = dDataCalculo, dValorPrevisto = not.dValor, sDescricao = not.sDescricao, sCategoriaDescricao = categoryBusiness.Get.FirstOrDefault(c => c.sID == not.sCategoryID).descricao
                        });
                    }

                    foreach (HomeNotificacaoModel hNot in lstNotTemp)
                    {
                        if (hNot.dData >= not.dData && ((not.NotificationType == NotificationType.OcorrenciaUnica) || (not.NotificationType == NotificationType.Mensal && hNot.dData <= not.dDataFim)))
                        {
                            home.listaNotificacoes.Add(hNot);
                        }
                    }
                }
            }
            #endregion
            #region ----- Resumo Categorias Mês Atual ------------------------------------------------------------------------------
            DateTime             dDataInicio = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
            DateTime             dDataFim    = dDataInicio.AddMonths(1) - (new TimeSpan(0, 0, 0, 1));
            List <ExpenseIncome> lstMesAtual = expenseIncomeBusiness.Get.Where(e => e.sUserID == AuthProvider.UserAntenticated.sID && e.dData >= dDataInicio && e.dData <= dDataFim && e.CategoryType == CategoryType.Despesa).OrderBy(e => e.sCategoryID).ToList();

            double dTotal = 0;
            Dictionary <string, double> dcExpense = new Dictionary <string, double>();
            foreach (ExpenseIncome exp in lstMesAtual)
            {
                if (!dcExpense.ContainsKey(exp.sCategoryID))
                {
                    dcExpense.Add(exp.sCategoryID, 0);
                }
                dcExpense[exp.sCategoryID] += exp.dValor;
                dTotal += exp.dValor;
            }

            dcExpense = dcExpense.OrderByDescending(d => d.Value).ToDictionary(x => x.Key, x => x.Value);
            double dPercOutros = 0;
            int    iTotElementos = dcExpense.Count, iOcorrencia = 0;
            foreach (var hr in dcExpense)
            {
                HomeResumoCategoriaModel homeResumo = new HomeResumoCategoriaModel();
                homeResumo.sMesAno      = dDataInicio.ToString("MMyyyy");
                homeResumo.dValor       = hr.Value;
                homeResumo.sCategoriaID = hr.Key;
                homeResumo.sDescricao   = categoryBusiness.Get.FirstOrDefault(c => c.sID == hr.Key).descricao;
                homeResumo.dPercentual  = (hr.Value * 100) / dTotal;
                home.listaResumoMesAtual.Add(homeResumo);

                if (string.IsNullOrEmpty(home.sListaResumoMesAtual))
                {
                    home.sListaResumoMesAtual = homeResumo.sDescricao + "|&" + Math.Round(homeResumo.dPercentual, 2);
                }
                else
                {
                    home.sListaResumoMesAtual += "|&" + homeResumo.sDescricao + "|&" + Math.Round(homeResumo.dPercentual, 2);
                }
            }
            #endregion
            #region ----- Resumo Categorias Mês Anterior ---------------------------------------------------------------------------
            DateTime dtTemp = DateTime.Now;
            dtTemp      = dtTemp.AddMonths(-1);
            dDataInicio = new DateTime(dtTemp.Year, dtTemp.Month, 1);
            dDataFim    = dDataInicio.AddMonths(1) - (new TimeSpan(0, 0, 0, 1));
            List <ExpenseIncome> lstMesAnterior = expenseIncomeBusiness.Get.Where(e => e.sUserID == AuthProvider.UserAntenticated.sID && e.dData >= dDataInicio && e.dData <= dDataFim && e.CategoryType == CategoryType.Despesa).OrderBy(e => e.sCategoryID).ToList();

            dTotal    = 0;
            dcExpense = new Dictionary <string, double>();
            foreach (ExpenseIncome exp in lstMesAnterior)
            {
                if (!dcExpense.ContainsKey(exp.sCategoryID))
                {
                    dcExpense.Add(exp.sCategoryID, 0);
                }
                dcExpense[exp.sCategoryID] += exp.dValor;
                dTotal += exp.dValor;
            }

            dcExpense     = dcExpense.OrderByDescending(d => d.Value).ToDictionary(x => x.Key, x => x.Value);;
            dPercOutros   = 0;
            iTotElementos = dcExpense.Count;
            iOcorrencia   = 0;
            foreach (var hr in dcExpense)
            {
                HomeResumoCategoriaModel homeResumo = new HomeResumoCategoriaModel();
                homeResumo.sMesAno      = dDataInicio.ToString("MMyyyy");
                homeResumo.dValor       = hr.Value;
                homeResumo.sCategoriaID = hr.Key;
                homeResumo.sDescricao   = categoryBusiness.Get.FirstOrDefault(c => c.sID == hr.Key).descricao;
                homeResumo.dPercentual  = (hr.Value * 100) / dTotal;
                home.listaResumoMesAnterior.Add(homeResumo);

                if (string.IsNullOrEmpty(home.sListaResumoMesAnterior))
                {
                    home.sListaResumoMesAnterior = homeResumo.sDescricao + "|&" + Math.Round(homeResumo.dPercentual, 2);
                }
                else
                {
                    home.sListaResumoMesAnterior += "|&" + homeResumo.sDescricao + "|&" + Math.Round(homeResumo.dPercentual, 2);
                }
            }

            #endregion
            return(home);
        }