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