/// <summary> /// Get income, payment, total 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 <CollectionByYearModel> > SummaryByYear(int year, Guid userID) { Task <List <CollectionByYearModel> > _return = Task.Run(() => { try { List <CollectionByYearModel> _listResult = new List <CollectionByYearModel>(); using (var _context = new TDHEntities()) { var _list = (from m in _context.FNC_MN_REPORT_SUMMARY_BY_YEAR(year) orderby m.month ascending select m).ToList(); foreach (var item in _list) { _listResult.Add(new CollectionByYearModel() { Year = item.year, Month = item.month, Income = item.input, Payment = item.output, Total = item.final }); } } return(_listResult); } catch (Exception ex) { throw new ServiceException(FILE_NAME, "SummaryByYear", userID, ex); } }); await _return; return(_return.Result); }