//-> SelectByID public async Task <CheckLoanRequestViewDTO> SelectByID(int id) { var accountHandler = new AccountHandler(); var checkLoanRequest = new CheckLoanRequestViewDTO(); checkLoanRequest.account = DoubleHelper.TwoPrecision(await accountHandler.SelectByID(id)); var loanRequest = await db.tblLoanRequests.FirstOrDefaultAsync(l => (l.loan_Status.ToLower() != "approved" && l.loan_Status.ToLower() != "rejected") && l.loan_Deleted == null && l.loan_AccountID == id); if (loanRequest == null) { loanRequest = new tblLoanRequest(); } checkLoanRequest.loanRequest = DoubleHelper.TwoPrecision(MappingHelper.MapDBClassToDTO <tblLoanRequest, LoanRequestViewDTO>(loanRequest)); //checkLoanRequest.loanRequest = MappingHelper.MapDBClassToDTO<tblLoanRequest, LoanRequestViewDTO>(loanRequest); return(DoubleHelper.TwoPrecision(checkLoanRequest)); }
//*** private method ***/ private async Task <GetListDTO <CheckLoanRequestViewDTO> > Listing(int currentPage, IQueryable <tblAccount> accounts, string search = null) { var checkLoanRequests = new List <CheckLoanRequestViewDTO>(); foreach (var account in PaginationHelper.GetList(currentPage, accounts)) { var checkLoanRequest = new CheckLoanRequestViewDTO(); //var accountHandler = new AccountHandler(); //checkLoanRequest.account = await accountHandler.SelectByID(account.id); checkLoanRequest = await SelectByID(account.id); checkLoanRequests.Add(checkLoanRequest); } var getList = new GetListDTO <CheckLoanRequestViewDTO>(); getList.metaData = await PaginationHelper.GetMetaData(currentPage, accounts, "id", "asc", search); getList.items = checkLoanRequests; return(getList); }