public IEnumerable <TraceableIncome> GetMonthlyIncomes() { List <IncomeDB> incomes = (List <IncomeDB>)ParseIncomes(); //IncomeClass.Instance().ParseIncomes(); List <TraceableIncome> tIncomes = new List <TraceableIncome>(); foreach (IncomeDB income in incomes) { TraceableIncome tIncome = new TraceableIncome() { Amount = income.incomeAmount, Year = income.incomeDate.Year, Month = income.incomeDate.Month, DateID = (income.incomeDate.Year * 100) + income.incomeDate.Month }; tIncomes.Add(tIncome); } var traceableIncomes = from income in tIncomes group income.Amount by income.DateID into incomeGroup select new TraceableIncome { DateID = incomeGroup.Key, Amount = incomeGroup.Sum(), Month = incomeGroup.Key % 100, Year = incomeGroup.Key / 100 }; return(traceableIncomes.ToList <TraceableIncome>()); }
public IEnumerable <TraceableIncome> GetMonthlyIncomes() { List <Income> incomes = IncomeClass.Instance().ParseIncomes(); List <TraceableIncome> tIncomes = new List <TraceableIncome>(); foreach (Income income in incomes) { TraceableIncome tIncome = new TraceableIncome() { amount = income.amount, year = income.date.Year, month = income.date.Month, dateID = (income.date.Year * 100) + income.date.Month }; tIncomes.Add(tIncome); } var traceableIncomes = from income in tIncomes group income.amount by income.dateID into incomeGroup select new TraceableIncome { dateID = incomeGroup.Key, amount = incomeGroup.Sum(), month = incomeGroup.Key % 100, year = incomeGroup.Key / 100 }; return(traceableIncomes.ToList <TraceableIncome>()); }