/// <summary>
/// Get summary income by month in a year
/// line chart
/// </summary>
/// <param name="year">Year</param>
/// <param name="userID">The user identifier</param>
/// <returns>List<ReportCollectionByYearModel></returns>
public async Task <List <IncomeByYearModel> > SummaryIncomeByYear(int year, Guid userID)
{
Task <List <IncomeByYearModel> > _return = Task.Run(() =>
{
try
{
List <IncomeByYearModel> _listResult = new List <IncomeByYearModel>();
using (var _context = new TDHEntities())
{
var _list = (from m in _context.FNC_MN_REPORT_INCOME_BY_CATEGORY_BY_YEAR(year)
orderby m.cate_name ascending
select m).ToList();
foreach (var item in _list)
{
_listResult.Add(new IncomeByYearModel()
{
Name = item.cate_name,
T01 = item.t1,
T02 = item.t2,
T03 = item.t3,
T04 = item.t4,
T05 = item.t5,
T06 = item.t6,
T07 = item.t7,
T08 = item.t8,
T09 = item.t9,
T10 = item.t10,
T11 = item.t11,
T12 = item.t12
});
}
}
return(_listResult);
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "SummaryIncomeByYear", userID, ex);
}
});
await _return;
return(_return.Result);
}
