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