private ICollection <MonthIncomeExpense> GetReports(int year)
{
var months = new AllMonth();
var a = months.AllMonthNames;
var b = _db.Expanses.MonthlyAmounts(year);
var c = _db.Selling.MonthlyAmounts(year);
var result = (from m in months.AllMonthNames
//from e in _db.Expanses.MonthlyAmounts(year).Where(x => x.MonthNumber == m.MonthNumber).DefaultIfEmpty()
//from s in _db.Selling.MonthlyAmounts(year).Where(i => i.MonthNumber == m.MonthNumber).DefaultIfEmpty()
join e in _db.Expanses.MonthlyAmounts(year) on m.MonthNumber equals e.MonthNumber
into expanse
from e in expanse.DefaultIfEmpty()
join s in _db.Selling.MonthlyAmounts(year) on m.MonthNumber equals s.MonthNumber
into sell
from s in sell.DefaultIfEmpty()
select new MonthIncomeExpense
{
Month = m.Month,
Income = s?.Amount ?? 0,
Expense = e?.Amount ?? 0
}).ToList();
return(result ?? new List <MonthIncomeExpense>());;
}
private ICollection <MonthIncomeExpenseNet> GetReports(int year)
{
var months = new AllMonth();
var result = (from m in months.AllMonthNames
join e in _db.Expanses.MonthlyAmounts(year) on m.MonthNumber equals e.MonthNumber
into expanse
from e in expanse.DefaultIfEmpty()
join s in _db.Selling.MonthlyAmounts(year) on m.MonthNumber equals s.MonthNumber
into sell
from s in sell.DefaultIfEmpty()
select new MonthIncomeExpenseNet
{
Month = m.Month,
Income = s?.Amount ?? 0,
Expense = e?.Amount ?? 0,
Net = (s?.Amount ?? 0) - (e?.Amount ?? 0)
}).ToList();
return(result ?? new List <MonthIncomeExpenseNet>());
}