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