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