public MonthBalanceDTO GetMonthBalance(int month) { int MonthIncome = 0; int MonthOutcome = 0; //Get All addition Orders var InOrders = unitofwork.Order.GetAll().Where(x => x.TypeId == 1 && x.OrderDate.Year == DateTime.Now.Year && x.OrderDate.Month == month); foreach (var order in InOrders) { MonthIncome = MonthIncome + order.TotalAmount; } //Get All Out Orders var OutOrders = unitofwork.Order.GetAll().Where(x => x.TypeId == 2 && x.OrderDate.Year == DateTime.Now.Year && x.OrderDate.Month == month); foreach (var order in OutOrders) { MonthOutcome = MonthOutcome + order.TotalAmount; } MonthBalanceDTO monthBalance = new MonthBalanceDTO(); monthBalance.Income = MonthIncome; monthBalance.Outcome = MonthOutcome; return(monthBalance); }
public List <MonthBalanceDTO> GetQuarterBalancePerMonth(int QuarterNum) { List <MonthBalanceDTO> quarterBalance = new List <MonthBalanceDTO>(); List <int> QuarterMonthes = this.GetQuarterMonthes(QuarterNum); foreach (var m in QuarterMonthes) { MonthBalanceDTO monthBalance = new MonthBalanceDTO(); monthBalance = this.GetMonthBalance(m); quarterBalance.Add(monthBalance); } return(quarterBalance); }